APPS.PQP_PENSION_EXTRACTS dependencies on BEN_EXT_DFN

Line 266: ,ben_ext_dfn dfn

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
270: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 2028: ,ben_ext_dfn dfn

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;
2032: --

Line 3640: FROM ben_ext_dfn ed

3636:
3637: CURSOR csr_ext_name(c_ext_dfn_id IN NUMBER
3638: )IS
3639: SELECT SUBSTR(ed.NAME,1,240)
3640: FROM ben_ext_dfn ed
3641: WHERE ed.ext_dfn_id = p_ext_dfn_id;
3642:
3643: CURSOR csr_ele_set_name(c_element_set_id IN NUMBER
3644: )IS

Line 3699: l_extract_name ben_ext_dfn.NAME%TYPE;

3695: FROM hr_locations_all
3696: WHERE location_id = c_location_id;
3697:
3698: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
3699: l_extract_name ben_ext_dfn.NAME%TYPE;
3700: l_element_set pay_element_sets.element_set_name%TYPE;
3701: l_element_name pay_element_types_f.element_name%TYPE;
3702: l_gre_name hr_organization_units.NAME%TYPE ;
3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;

Line 4133: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

4129: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
4130: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
4131: i per_all_assignments_f.business_group_id%TYPE;
4132: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
4133: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
4134: l_return_value VARCHAR2(2) :='N';
4135: l_valid_action VARCHAR2(2);
4136: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4137: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;