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_PENSION_EXTRACTS dependencies on BEN_EXT_DATA_ELMT

Line 858: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

854: -- ~ Update_Record_Values :
855: -- ================================================================================
856: PROCEDURE Update_Record_Values
857: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
858: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
859: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
860: ,p_data_ele_seqnum IN NUMBER
861: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
862: ) IS

Line 866: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

862: ) IS
863:
864: CURSOR csr_seqnum
865: (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
866: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
867: ) IS
868: SELECT der.ext_data_elmt_id,
869: der.seq_num,
870: ede.NAME

Line 871: FROM ben_ext_data_elmt_in_rcd der

867: ) IS
868: SELECT der.ext_data_elmt_id,
869: der.seq_num,
870: ede.NAME
871: FROM ben_ext_data_elmt_in_rcd der
872: ,ben_ext_data_elmt ede
873: WHERE der.ext_rcd_id = c_ext_rcd_id
874: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
875: AND ede.NAME LIKE '%'|| c_ext_data_element_name

Line 872: ,ben_ext_data_elmt ede

868: SELECT der.ext_data_elmt_id,
869: der.seq_num,
870: ede.NAME
871: FROM ben_ext_data_elmt_in_rcd der
872: ,ben_ext_data_elmt ede
873: WHERE der.ext_rcd_id = c_ext_rcd_id
874: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
875: AND ede.NAME LIKE '%'|| c_ext_data_element_name
876: ORDER BY seq_num;

Line 1507: ben_ext_data_elmt_in_rcd xer,

1503: xel.ext_fld_id,
1504: fld.frmt_mask_typ_cd
1505:
1506: FROM ben_ext_where_clause xwc,
1507: ben_ext_data_elmt_in_rcd xer,
1508: ben_ext_rcd xrc,
1509: ben_ext_data_elmt xel,
1510: ben_ext_fld fld
1511: WHERE xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id

Line 1509: ben_ext_data_elmt xel,

1505:
1506: FROM ben_ext_where_clause xwc,
1507: ben_ext_data_elmt_in_rcd xer,
1508: ben_ext_rcd xrc,
1509: ben_ext_data_elmt xel,
1510: ben_ext_fld fld
1511: WHERE xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id
1512: AND xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
1513: AND xer.ext_rcd_id = xrc.ext_rcd_id

Line 1686: FROM ben_ext_data_elmt_in_rcd xer,

1682: SELECT xer.seq_num,
1683: xer.sprs_cd,
1684: xer.ext_data_elmt_in_rcd_id,
1685: xdm.NAME
1686: FROM ben_ext_data_elmt_in_rcd xer,
1687: ben_ext_data_elmt xdm
1688: WHERE ext_rcd_id = p_ext_rcd_id
1689: AND xer.sprs_cd IS NOT NULL
1690: AND xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;

Line 1687: ben_ext_data_elmt xdm

1683: xer.sprs_cd,
1684: xer.ext_data_elmt_in_rcd_id,
1685: xdm.NAME
1686: FROM ben_ext_data_elmt_in_rcd xer,
1687: ben_ext_data_elmt xdm
1688: WHERE ext_rcd_id = p_ext_rcd_id
1689: AND xer.sprs_cd IS NOT NULL
1690: AND xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;
1691: --

Line 1698: ben_ext_data_elmt_in_rcd xer

1694: xwc.val,
1695: xwc.and_or_cd,
1696: xer.seq_num
1697: FROM ben_ext_where_clause xwc,
1698: ben_ext_data_elmt_in_rcd xer
1699: WHERE xwc.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
1700: AND xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
1701: ORDER BY xwc.seq_num;
1702: --

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

1982: ,p_asgaction_no IN NUMBER
1983: ,p_error_message OUT NOCOPY VARCHAR2) IS
1984:
1985: CURSOR csr_rule_ele
1986: (c_ext_rcd_id IN ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) IS
1987: SELECT a.ext_data_elmt_in_rcd_id
1988: ,a.seq_num
1989: ,a.sprs_cd
1990: ,a.strt_pos

Line 2004: FROM ben_ext_data_elmt b,

2000: ,b.string_val
2001: ,b.dflt_val
2002: ,b.max_length_num
2003: ,b.just_cd
2004: FROM ben_ext_data_elmt b,
2005: ben_ext_data_elmt_in_rcd a
2006: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
2007: AND b.data_elmt_typ_cd = 'R'
2008: AND a.ext_rcd_id = c_ext_rcd_id

Line 2005: ben_ext_data_elmt_in_rcd a

2001: ,b.dflt_val
2002: ,b.max_length_num
2003: ,b.just_cd
2004: FROM ben_ext_data_elmt b,
2005: ben_ext_data_elmt_in_rcd a
2006: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
2007: AND b.data_elmt_typ_cd = 'R'
2008: AND a.ext_rcd_id = c_ext_rcd_id
2009: ORDER BY a.seq_num;