APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 2237: FROM pay_payrolls_f pay

2233: CURSOR csr_pay_name(c_payroll_id IN Number
2234: ,c_end_date IN Date
2235: )IS
2236: SELECT pay.payroll_name
2237: FROM pay_payrolls_f pay
2238: WHERE pay.payroll_id = c_payroll_id
2239: AND c_end_date BETWEEN pay.effective_start_date
2240: AND pay.effective_end_date;
2241:

Line 2251: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;

2247:
2248:
2249: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
2250: l_extract_name ben_ext_dfn.NAME%TYPE;
2251: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
2252: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
2253: l_org_name hr_all_organization_units.NAME%TYPE;
2254:
2255: