APPS.PQP_US_SRS_EXTRACTS dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 1367: (c_ext_rcd_id In ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) Is

1363: --
1364: -- Cursor to get all the rule based data-elements for the detail record
1365: --
1366: Cursor csr_rule_ele
1367: (c_ext_rcd_id In ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) Is
1368: Select a.ext_data_elmt_in_rcd_id
1369: ,a.seq_num
1370: ,a.sprs_cd
1371: ,a.strt_pos

Line 1385: ben_ext_data_elmt_in_rcd a

1381: ,b.dflt_val
1382: ,b.max_length_num
1383: ,b.just_cd
1384: from ben_ext_data_elmt b,
1385: ben_ext_data_elmt_in_rcd a
1386: where a.ext_data_elmt_id = b.ext_data_elmt_id
1387: and b.data_elmt_typ_cd = 'R'
1388: and a.ext_rcd_id = c_ext_rcd_id
1389: order by a.seq_num;

Line 1552: from ben_ext_data_elmt_in_rcd der

1548: ) Is
1549: select der.ext_data_elmt_id,
1550: der.seq_num,
1551: ede.name
1552: from ben_ext_data_elmt_in_rcd der
1553: ,ben_ext_data_elmt ede
1554: where der.ext_rcd_id = c_ext_rcd_id
1555: and ede.ext_data_elmt_id = der.ext_data_elmt_id
1556: and ede.name like '%'|| c_ext_data_element_name