APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on BEN_EXT_DFN

Line 27: ,ben_ext_dfn dfn

23: rcd.ext_rcd_id,
24: rcd.rcd_type_cd
25: FROM ben_ext_rcd rcd
26: ,ben_ext_rcd_in_file rin
27: ,ben_ext_dfn dfn
28: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
29: AND rin.ext_file_id = dfn.ext_file_id
30: AND rin.ext_rcd_id = rcd.ext_rcd_id
31: ORDER BY rin.seq_num;

Line 130: ,ben_ext_dfn dfn

126: CURSOR c_get_rcd_id(c_seq IN Number) IS
127: SELECT rcd.ext_rcd_id
128: FROM ben_ext_rcd rcd
129: ,ben_ext_rcd_in_file rin
130: ,ben_ext_dfn dfn
131: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
132: AND rin.ext_file_id = dfn.ext_file_id
133: AND rin.ext_rcd_id = rcd.ext_rcd_id
134: AND rin.seq_num = c_seq;

Line 145: ,ben_ext_dfn dfn

141: ) IS
142: SELECT rcd.ext_rcd_id
143: FROM ben_ext_rcd rcd
144: ,ben_ext_rcd_in_file rin
145: ,ben_ext_dfn dfn
146: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
147: AND rin.ext_file_id = dfn.ext_file_id
148: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
149: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 159: ,ben_ext_dfn dfn

155: CURSOR csr_ext_rcd_id_hidden(c_rcd_type_cd IN Varchar2) IS
156: SELECT rcd.ext_rcd_id
157: FROM ben_ext_rcd rcd
158: ,ben_ext_rcd_in_file rin
159: ,ben_ext_dfn dfn
160: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
161: AND rin.ext_file_id = dfn.ext_file_id
162: AND rin.ext_rcd_id = rcd.ext_rcd_id
163: AND rcd.rcd_type_cd = c_rcd_type_cd

Line 315: FROM ben_ext_dfn ed

311:
312: CURSOR csr_ext_name(c_ext_dfn_id IN Number
313: )IS
314: SELECT Substr(ed.NAME,1,240)
315: FROM ben_ext_dfn ed
316: WHERE ed.ext_dfn_id = p_ext_dfn_id;
317:
318: CURSOR csr_pay_name(c_payroll_id IN Number
319: ,c_end_date IN Date

Line 334: l_extract_name ben_ext_dfn.NAME%TYPE;

330: FROM pay_consolidation_sets con
331: WHERE con.consolidation_set_id = c_con_set;
332:
333: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
334: l_extract_name ben_ext_dfn.NAME%TYPE;
335: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
336: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
337: l_org_name hr_all_organization_units.NAME%TYPE;
338:

Line 1989: ,ben_ext_dfn dfn

1985: rcd.ext_rcd_id,
1986: rcd.rcd_type_cd
1987: FROM ben_ext_rcd rcd
1988: ,ben_ext_rcd_in_file rin
1989: ,ben_ext_dfn dfn
1990: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
1991: AND rin.ext_file_id = dfn.ext_file_id
1992: AND rin.ext_rcd_id = rcd.ext_rcd_id
1993: ORDER BY rin.seq_num;

Line 2267: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

2263: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
2264: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
2265: bg_id per_all_assignments_f.business_group_id%TYPE;
2266: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
2267: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2268: l_return_value Varchar2(2) :='N';
2269: l_valid_action Varchar2(2);
2270: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2271: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;