APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1842: ,per_all_assignments_f paaf

1838: IS
1839: SELECT hsck.segment20 -- Tax Area
1840: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1841: FROM hr_soft_coding_keyflex hsck
1842: ,per_all_assignments_f paaf
1843: ,pay_assignment_actions paa
1844: ,pay_payroll_actions ppa
1845: WHERE paa.assignment_action_id = p_assactid
1846: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1857: FROM per_all_assignments_f paa

1853: --
1854: CURSOR csr_person_id
1855: IS
1856: SELECT paa.person_id
1857: FROM per_all_assignments_f paa
1858: WHERE paa.assignment_id = p_assignment_id
1859: AND p_date_earned BETWEEN paa.effective_start_date
1860: AND paa.effective_end_date;
1861: --

Line 1878: l_person_id per_all_assignments_f.person_id%TYPE;

1874: WHERE pei.person_id = p_person_id
1875: AND pei.pei_information_category = 'PER_PASSPORT_INFO_CN' ;
1876: --
1877: l_passport per_people_extra_info.pei_information2%TYPE;
1878: l_person_id per_all_assignments_f.person_id%TYPE;
1879: l_expatriate per_all_people_f.per_information8%TYPE;
1880:
1881: -- Bug 3139966 ends
1882:

Line 2208: per_all_assignments_f paf,

2204: SELECT pps.actual_termination_date
2205: FROM pay_payroll_actions ppa,
2206: pay_assignment_actions paa,
2207: per_time_periods ptp,
2208: per_all_assignments_f paf,
2209: per_periods_of_service pps
2210: WHERE paa.assignment_action_id = p_assignment_action_id
2211: AND ppa.payroll_action_id = paa.payroll_action_id
2212: AND ptp.payroll_id = ppa.payroll_id