eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 1686: FROM ben_ext_data_elmt_in_rcd der

1682: ) IS
1683: SELECT der.ext_data_elmt_id,
1684: der.seq_num,
1685: ede.NAME
1686: FROM ben_ext_data_elmt_in_rcd der
1687: ,ben_ext_data_elmt ede
1688: WHERE der.ext_rcd_id = c_ext_rcd_id
1689: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
1690: AND ede.NAME LIKE '%'|| c_ext_data_element_name

Line 2321: ben_ext_data_elmt_in_rcd xer,

2317: xel.data_elmt_rl,
2318: xel.ext_fld_id,
2319: fld.frmt_mask_typ_cd
2320: FROM ben_ext_where_clause xwc,
2321: ben_ext_data_elmt_in_rcd xer,
2322: ben_ext_rcd xrc,
2323: ben_ext_data_elmt xel,
2324: ben_ext_fld fld
2325: WHERE xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id

Line 2500: FROM ben_ext_data_elmt_in_rcd xer,

2496: SELECT xer.seq_num,
2497: xer.sprs_cd,
2498: xer.ext_data_elmt_in_rcd_id,
2499: xdm.NAME
2500: FROM ben_ext_data_elmt_in_rcd xer,
2501: ben_ext_data_elmt xdm
2502: WHERE ext_rcd_id = p_ext_rcd_id
2503: AND xer.sprs_cd IS NOT NULL
2504: AND xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;

Line 2512: ben_ext_data_elmt_in_rcd xer

2508: xwc.val,
2509: xwc.and_or_cd,
2510: xer.seq_num
2511: FROM ben_ext_where_clause xwc,
2512: ben_ext_data_elmt_in_rcd xer
2513: WHERE xwc.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
2514: AND xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
2515: ORDER BY xwc.seq_num;
2516: --

Line 2802: (c_ext_rcd_id IN ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) IS

2798: ,p_asgaction_no IN NUMBER
2799: ,p_error_message OUT NOCOPY VARCHAR2) IS
2800:
2801: CURSOR csr_rule_ele
2802: (c_ext_rcd_id IN ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) IS
2803: SELECT a.ext_data_elmt_in_rcd_id
2804: ,a.seq_num
2805: ,a.sprs_cd
2806: ,a.strt_pos

Line 2821: ben_ext_data_elmt_in_rcd a

2817: ,b.dflt_val
2818: ,b.max_length_num
2819: ,b.just_cd
2820: FROM ben_ext_data_elmt b,
2821: ben_ext_data_elmt_in_rcd a
2822: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
2823: AND b.data_elmt_typ_cd = 'R'
2824: AND a.ext_rcd_id = c_ext_rcd_id
2825: ORDER BY a.seq_num;