APPS.PQP_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 264: FROM ben_ext_rcd rcd

260: CURSOR csr_ext_rcd_id(c_hide_flag IN VARCHAR2
261: ,c_rcd_type_cd IN VARCHAR2
262: ) IS
263: SELECT rcd.ext_rcd_id
264: FROM ben_ext_rcd rcd
265: ,ben_ext_rcd_in_file rin
266: ,ben_ext_dfn dfn
267: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id -- The extract executing currently
268: AND rin.ext_file_id = dfn.ext_file_id

Line 265: ,ben_ext_rcd_in_file rin

261: ,c_rcd_type_cd IN VARCHAR2
262: ) IS
263: SELECT rcd.ext_rcd_id
264: FROM ben_ext_rcd rcd
265: ,ben_ext_rcd_in_file rin
266: ,ben_ext_dfn dfn
267: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id -- The extract executing currently
268: AND rin.ext_file_id = dfn.ext_file_id
269: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 857: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

853: -- ================================================================================
854: -- ~ Update_Record_Values :
855: -- ================================================================================
856: PROCEDURE Update_Record_Values
857: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
858: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
859: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
860: ,p_data_ele_seqnum IN NUMBER
861: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

Line 865: (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

861: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
862: ) IS
863:
864: CURSOR csr_seqnum
865: (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
866: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
867: ) IS
868: SELECT der.ext_data_elmt_id,
869: der.seq_num,

Line 1508: ben_ext_rcd xrc,

1504: fld.frmt_mask_typ_cd
1505:
1506: FROM ben_ext_where_clause xwc,
1507: ben_ext_data_elmt_in_rcd xer,
1508: ben_ext_rcd xrc,
1509: ben_ext_data_elmt xel,
1510: ben_ext_fld fld
1511: WHERE xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id
1512: AND xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id

Line 1523: l_rcd_name ben_ext_rcd.NAME%TYPE ;

1519: l_condition VARCHAR2(1);
1520: l_cnt NUMBER;
1521: l_value_without_quotes VARCHAR2(500);
1522: l_dynamic_condition VARCHAR2(9999);
1523: l_rcd_name ben_ext_rcd.NAME%TYPE ;
1524: --
1525: --
1526: BEGIN
1527: --

Line 1980: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1976: PROCEDURE Process_Ext_Rslt_Dtl_Rec
1977: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
1978: ,p_organization_id IN per_all_assignments.organization_id%TYPE
1979: ,p_effective_date IN DATE
1980: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1981: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1982: ,p_asgaction_no IN NUMBER
1983: ,p_error_message OUT NOCOPY VARCHAR2) IS
1984:

Line 2027: FROM ben_ext_rcd_in_file rif

2023: ,rif.any_or_all_cd
2024: ,rif.seq_num
2025: ,rif.sprs_cd
2026: ,rif.rqd_flag
2027: FROM ben_ext_rcd_in_file rif
2028: ,ben_ext_dfn dfn
2029: WHERE rif.ext_file_id = dfn.ext_file_id
2030: AND rif.ext_rcd_id = c_rcd_id
2031: AND dfn.ext_dfn_id = c_ext_dfn_id;

Line 4478: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

4474: WHERE err.business_group_id = c_bg_id
4475: AND err.typ_cd = 'E'
4476: AND err.ext_rslt_id = c_ext_rslt_id;
4477:
4478: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
4479: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
4480: l_proc_name VARCHAR2(150):= g_proc_name||'Del_Service_Detail_Recs';
4481: l_return_value NUMBER := 0; --0= Sucess, -1=Error
4482: l_ben_params csr_ben%ROWTYPE;

Line 4479: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

4475: AND err.typ_cd = 'E'
4476: AND err.ext_rslt_id = c_ext_rslt_id;
4477:
4478: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
4479: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
4480: l_proc_name VARCHAR2(150):= g_proc_name||'Del_Service_Detail_Recs';
4481: l_return_value NUMBER := 0; --0= Sucess, -1=Error
4482: l_ben_params csr_ben%ROWTYPE;
4483: BEGIN