APPS.PAY_IN_EOY_REPORTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 892: FROM per_all_assignments_f paf

888:
889: CURSOR csr_payroll_id(p_assignment_id NUMBER,p_date DATE)
890: IS
891: SELECT paf.payroll_id
892: FROM per_all_assignments_f paf
893: WHERE paf.assignment_id =p_assignment_id
894: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
895:
896: l_total_pay_period NUMBER;

Line 1848: FROM per_all_assignments_f b

1844: per_periods_of_Service pps
1845: WHERE paa.assignment_id = l_assignment_id
1846: AND paa.period_of_service_id =pps.period_of_service_id
1847: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
1848: FROM per_all_assignments_f b
1849: WHERE paa.assignment_id=b.assignment_id );
1850:
1851: l_year_start := pay_in_tax_utils.get_financial_year_start(l_date_earned );
1852: l_year_end := pay_in_tax_utils.get_financial_year_end(l_date_earned );