BEN Extract Audit

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Extract Audit Report (XML)
Short Name: BENXAUDT_XML
DB package: BEN_BENXAUDT_XMLP_PKG
SELECT b.name record_name,
       a.business_group_id,
       a.request_id,
       b.ext_rcd_id,
       d.name data_elmt_name,
       c.seq_num,
       a.person_id,
       a.prmy_sort_val,
       a.scnd_sort_val,
       a.trans_seq_num,
       a.rcrd_seq_num,
       a.ext_rslt_dtl_id, 
	BEN_BENXAUDT_XMLP_PKG.business_nameformula(a.business_group_id) business_name, 
	BEN_BENXAUDT_XMLP_PKG.valueformula(b.ext_rcd_id, a.ext_rslt_dtl_id, c.seq_num) value
FROM   ben_ext_rslt_dtl a,
       ben_ext_rcd b,
       ben_ext_data_elmt d,
       ben_ext_data_elmt_in_rcd c
WHERE  a.ext_rcd_id = b.ext_rcd_id
AND    a.ext_rslt_id = :p_request_id
AND    b.ext_rcd_id = c.ext_rcd_id
AND    c.ext_data_elmt_id = d.ext_data_elmt_id
order by a.prmy_sort_val,
              a.scnd_sort_val,
              a.thrd_sort_val,
              c.seq_num
Parameter Name SQL text Validation
Record To
 
Number
Record From
 
Number
Request ID
 
LOV Oracle