APPS.PQP_US_SRS_EXTRACTS dependencies on BEN_EXT_DATA_ELMT

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 1384: from ben_ext_data_elmt b,

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

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 1541: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE

1537: -- ================================================================================
1538: -- ~ Update_Record_Values :
1539: -- ================================================================================
1540: Procedure Update_Record_Values ( p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1541: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1542: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
1543: ,p_data_ele_seqnum In Number
1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
1545: ) Is

Line 1547: ,c_ext_data_element_name In ben_ext_data_elmt.name%TYPE

1543: ,p_data_ele_seqnum In Number
1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
1545: ) Is
1546: Cursor csr_seqnum ( c_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1547: ,c_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1548: ) Is
1549: select der.ext_data_elmt_id,
1550: der.seq_num,
1551: ede.name

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

Line 1553: ,ben_ext_data_elmt ede

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
1557: order by seq_num;