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

Line 1675: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

1671: -- ~ Update_Record_Values :
1672: -- ================================================================================
1673: PROCEDURE Update_Record_Values
1674: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1675: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1676: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1677: ,p_data_ele_seqnum IN NUMBER
1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1679: ) IS

Line 1681: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

1677: ,p_data_ele_seqnum IN NUMBER
1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1679: ) IS
1680: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1681: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1682: ) IS
1683: SELECT der.ext_data_elmt_id,
1684: der.seq_num,
1685: ede.NAME

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 1687: ,ben_ext_data_elmt ede

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
1691: ORDER BY seq_num;

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 2323: ben_ext_data_elmt xel,

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
2326: AND xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
2327: AND xer.ext_rcd_id = xrc.ext_rcd_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 2501: ben_ext_data_elmt xdm

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 ;
2505: --

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 2820: FROM ben_ext_data_elmt b,

2816: ,b.string_val
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

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;