APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 322: FROM pay_payrolls_f pay

318: CURSOR csr_pay_name(c_payroll_id IN Number
319: ,c_end_date IN Date
320: )IS
321: SELECT pay.payroll_name
322: FROM pay_payrolls_f pay
323: WHERE pay.payroll_id = c_payroll_id
324: AND c_end_date BETWEEN pay.effective_start_date
325: AND pay.effective_end_date;
326:

Line 335: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;

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:
339: BEGIN