APPS.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 1380: FROM ben_ext_data_elmt_in_rcd der

1376: ) IS
1377: SELECT der.ext_data_elmt_id,
1378: der.seq_num,
1379: ede.NAME
1380: FROM ben_ext_data_elmt_in_rcd der
1381: ,ben_ext_data_elmt ede
1382: WHERE der.ext_rcd_id = c_ext_rcd_id
1383: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
1384: AND ede.NAME LIKE '%'|| c_ext_data_element_name

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

1909: ,p_asgaction_no IN Number DEFAULT NULL
1910: ,p_error_message OUT NOCOPY Varchar2) IS
1911:
1912: CURSOR csr_rule_ele
1913: (c_ext_rcd_id IN ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) IS
1914: SELECT a.ext_data_elmt_in_rcd_id
1915: ,a.seq_num
1916: ,a.sprs_cd
1917: ,a.strt_pos

Line 1931: ben_ext_data_elmt_in_rcd a

1927: ,b.dflt_val
1928: ,b.max_length_num
1929: ,b.just_cd
1930: FROM ben_ext_data_elmt b,
1931: ben_ext_data_elmt_in_rcd a
1932: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
1933: AND b.data_elmt_typ_cd = 'R'
1934: AND a.ext_rcd_id = c_ext_rcd_id
1935: -- AND a.hide_flag = 'N'