APPS.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_DATA_ELMT

Line 1348: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

1344: -- ~ Update_Record_Values :
1345: -- ============================================================================
1346: PROCEDURE Update_Record_Values
1347: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1348: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1349: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1350: ,p_data_ele_seqnum IN Number
1351: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1352: ) IS

Line 1354: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

1350: ,p_data_ele_seqnum IN Number
1351: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1352: ) IS
1353: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1354: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1355: ) IS
1356: SELECT der.ext_data_elmt_id,
1357: der.seq_num,
1358: ede.NAME

Line 1359: FROM ben_ext_data_elmt_in_rcd der

1355: ) IS
1356: SELECT der.ext_data_elmt_id,
1357: der.seq_num,
1358: ede.NAME
1359: FROM ben_ext_data_elmt_in_rcd der
1360: ,ben_ext_data_elmt ede
1361: WHERE der.ext_rcd_id = c_ext_rcd_id
1362: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
1363: AND ede.NAME LIKE '%'|| c_ext_data_element_name

Line 1360: ,ben_ext_data_elmt ede

1356: SELECT der.ext_data_elmt_id,
1357: der.seq_num,
1358: ede.NAME
1359: FROM ben_ext_data_elmt_in_rcd der
1360: ,ben_ext_data_elmt ede
1361: WHERE der.ext_rcd_id = c_ext_rcd_id
1362: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
1363: AND ede.NAME LIKE '%'|| c_ext_data_element_name
1364: ORDER BY seq_num;

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

1888: ,p_asgaction_no IN Number DEFAULT NULL
1889: ,p_error_message OUT NOCOPY Varchar2) IS
1890:
1891: CURSOR csr_rule_ele
1892: (c_ext_rcd_id IN ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) IS
1893: SELECT a.ext_data_elmt_in_rcd_id
1894: ,a.seq_num
1895: ,a.sprs_cd
1896: ,a.strt_pos

Line 1909: FROM ben_ext_data_elmt b,

1905: ,b.string_val
1906: ,b.dflt_val
1907: ,b.max_length_num
1908: ,b.just_cd
1909: FROM ben_ext_data_elmt b,
1910: ben_ext_data_elmt_in_rcd a
1911: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
1912: AND b.data_elmt_typ_cd = 'R'
1913: AND a.ext_rcd_id = c_ext_rcd_id

Line 1910: ben_ext_data_elmt_in_rcd a

1906: ,b.dflt_val
1907: ,b.max_length_num
1908: ,b.just_cd
1909: FROM ben_ext_data_elmt b,
1910: ben_ext_data_elmt_in_rcd a
1911: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
1912: AND b.data_elmt_typ_cd = 'R'
1913: AND a.ext_rcd_id = c_ext_rcd_id
1914: -- AND a.hide_flag = 'N'