APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on BEN_EXT_DATA_ELMT

Line 496: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

492: -- ~ Update_Record_Values :
493: -- ============================================================================
494: PROCEDURE Update_Record_Values
495: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
496: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
497: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
498: ,p_data_ele_seqnum IN Number
499: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
500: ) IS

Line 502: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE

498: ,p_data_ele_seqnum IN Number
499: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
500: ) IS
501: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
502: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
503: ) IS
504: SELECT der.ext_data_elmt_id,
505: der.seq_num,
506: ede.NAME

Line 507: FROM ben_ext_data_elmt_in_rcd der

503: ) IS
504: SELECT der.ext_data_elmt_id,
505: der.seq_num,
506: ede.NAME
507: FROM ben_ext_data_elmt_in_rcd der
508: ,ben_ext_data_elmt ede
509: WHERE der.ext_rcd_id = c_ext_rcd_id
510: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
511: AND ede.NAME LIKE '%'|| c_ext_data_element_name

Line 508: ,ben_ext_data_elmt ede

504: SELECT der.ext_data_elmt_id,
505: der.seq_num,
506: ede.NAME
507: FROM ben_ext_data_elmt_in_rcd der
508: ,ben_ext_data_elmt ede
509: WHERE der.ext_rcd_id = c_ext_rcd_id
510: AND ede.ext_data_elmt_id = der.ext_data_elmt_id
511: AND ede.NAME LIKE '%'|| c_ext_data_element_name
512: ORDER BY seq_num;

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

1248: ,p_asgaction_no IN Number DEFAULT NULL
1249: ,p_error_message OUT NOCOPY Varchar2) IS
1250:
1251: CURSOR csr_rule_ele
1252: (c_ext_rcd_id IN ben_ext_data_elmt_in_rcd.ext_rcd_id%TYPE) IS
1253: SELECT a.ext_data_elmt_in_rcd_id
1254: ,a.seq_num
1255: ,a.sprs_cd
1256: ,a.strt_pos

Line 1269: FROM ben_ext_data_elmt b,

1265: ,b.string_val
1266: ,b.dflt_val
1267: ,b.max_length_num
1268: ,b.just_cd
1269: FROM ben_ext_data_elmt b,
1270: ben_ext_data_elmt_in_rcd a
1271: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
1272: AND b.data_elmt_typ_cd = 'R'
1273: AND a.ext_rcd_id = c_ext_rcd_id

Line 1270: ben_ext_data_elmt_in_rcd a

1266: ,b.dflt_val
1267: ,b.max_length_num
1268: ,b.just_cd
1269: FROM ben_ext_data_elmt b,
1270: ben_ext_data_elmt_in_rcd a
1271: WHERE a.ext_data_elmt_id = b.ext_data_elmt_id
1272: AND b.data_elmt_typ_cd = 'R'
1273: AND a.ext_rcd_id = c_ext_rcd_id
1274: -- AND a.hide_flag = 'N'