APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXT_DFN

Line 233: ,ben_ext_dfn dfn

229: ) IS
230: SELECT rcd.ext_rcd_id
231: FROM ben_ext_rcd rcd
232: ,ben_ext_rcd_in_file rin
233: ,ben_ext_dfn dfn
234: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
235: AND rin.ext_file_id = dfn.ext_file_id
236: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
237: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 2844: ,ben_ext_dfn dfn

2840: ,rif.seq_num
2841: ,rif.sprs_cd
2842: ,rif.rqd_flag
2843: FROM ben_ext_rcd_in_file rif
2844: ,ben_ext_dfn dfn
2845: WHERE rif.ext_file_id = dfn.ext_file_id
2846: AND rif.ext_rcd_id = c_rcd_id
2847: AND dfn.ext_dfn_id = c_ext_dfn_id;
2848: --

Line 4770: FROM ben_ext_dfn ed

4766:
4767: CURSOR csr_ext_name(c_ext_dfn_id IN NUMBER
4768: )IS
4769: SELECT Substr(ed.NAME,1,240)
4770: FROM ben_ext_dfn ed
4771: WHERE ed.ext_dfn_id = p_ext_dfn_id;
4772:
4773: CURSOR csr_ele_set_name(c_element_set_id IN NUMBER
4774: )IS

Line 4810: l_extract_name ben_ext_dfn.NAME%TYPE;

4806: SELECT con.consolidation_set_name
4807: FROM pay_consolidation_sets con
4808: WHERE con.consolidation_set_id = c_con_set;
4809: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
4810: l_extract_name ben_ext_dfn.NAME%TYPE;
4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
4812: l_element_name pay_element_types_f.element_name%TYPE;
4813: l_gre_name hr_organization_units.NAME%TYPE ;
4814: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;

Line 5018: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

5014: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
5015: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
5016: i per_all_assignments_f.business_group_id%TYPE;
5017: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
5018: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
5019: l_return_value VARCHAR2(2) :='N';
5020: l_valid_action VARCHAR2(2);
5021: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
5022: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;