APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1714: ,per_all_assignments_f paaf

1710: IS
1711: SELECT hsck.segment20 -- Tax Area
1712: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1713: FROM hr_soft_coding_keyflex hsck
1714: ,per_all_assignments_f paaf
1715: ,pay_assignment_actions paa
1716: ,pay_payroll_actions ppa
1717: WHERE paa.assignment_action_id = p_assactid
1718: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1729: FROM per_all_assignments_f paa

1725: --
1726: CURSOR csr_person_id
1727: IS
1728: SELECT paa.person_id
1729: FROM per_all_assignments_f paa
1730: WHERE paa.assignment_id = p_assignment_id
1731: AND p_date_earned BETWEEN paa.effective_start_date
1732: AND paa.effective_end_date;
1733: --

Line 1750: l_person_id per_all_assignments_f.person_id%TYPE;

1746: WHERE pei.person_id = p_person_id
1747: AND pei.pei_information_category = 'PER_PASSPORT_INFO_CN' ;
1748: --
1749: l_passport per_people_extra_info.pei_information2%TYPE;
1750: l_person_id per_all_assignments_f.person_id%TYPE;
1751: l_expatriate per_all_people_f.per_information8%TYPE;
1752:
1753: -- Bug 3139966 ends
1754:

Line 2080: per_all_assignments_f paf,

2076: SELECT pps.actual_termination_date
2077: FROM pay_payroll_actions ppa,
2078: pay_assignment_actions paa,
2079: per_time_periods ptp,
2080: per_all_assignments_f paf,
2081: per_periods_of_service pps
2082: WHERE paa.assignment_action_id = p_assignment_action_id
2083: AND ppa.payroll_action_id = paa.payroll_action_id
2084: AND ptp.payroll_id = ppa.payroll_id