DBA Data[Home] [Help]

APPS.PSP_AUTOPOP dependencies on PAY_ALL_PAYROLLS_F

Line 666: pay_all_payrolls_f ppf

662:
663: CURSOR period_type_c IS
664: SELECT distinct(ppf.period_type)
665: FROM per_all_assignments_f paf,
666: pay_all_payrolls_f ppf
667: WHERE paf.assignment_id = p_assignment_id
668: AND p_payroll_date BETWEEN paf.effective_start_date AND NVL(paf.effective_end_date,p_payroll_date)
669: AND paf.payroll_id = ppf.payroll_id;
670: