APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 2258: FROM pay_payrolls_f pay

2254: CURSOR csr_pay_name(c_payroll_id IN Number
2255: ,c_end_date IN Date
2256: )IS
2257: SELECT pay.payroll_name
2258: FROM pay_payrolls_f pay
2259: WHERE pay.payroll_id = c_payroll_id
2260: AND c_end_date BETWEEN pay.effective_start_date
2261: AND pay.effective_end_date;
2262:

Line 2272: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;

2268:
2269:
2270: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
2271: l_extract_name ben_ext_dfn.NAME%TYPE;
2272: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
2273: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
2274: l_org_name hr_all_organization_units.NAME%TYPE;
2275:
2276: