DBA Data[Home] [Help]

APPS.PSP_AUTOPOP dependencies on PER_ALL_ASSIGNMENTS_F

Line 665: FROM per_all_assignments_f paf,

661:
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;