APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 832: from per_all_assignments_f paa,

828:
829: cursor csr_get_organization(p_payroll_id number
830: ,p_effective_date date) is
831: select distinct paei.aei_information7 legal_entity_id
832: from per_all_assignments_f paa,
833: per_assignment_extra_info paei
834: where paa.payroll_id = p_payroll_id
835: and p_effective_date between paa.effective_start_date
836: and paa.effective_end_date

Line 840: from per_all_assignments_f paa1

836: and paa.effective_end_date
837: and paa.assignment_id = paei.assignment_id
838: and paei.information_type = 'ZA_SPECIFIC_INFO'
839: and not exists (select 1
840: from per_all_assignments_f paa1
841: where paa1.payroll_id = p_payroll_id
842: and paa1.organization_id = paei.aei_information7
843: And p_effective_date between paa1.effective_start_date
844: and paa1.effective_end_date);

Line 1278: from per_all_assignments_f

1274: -- Retrieve the ZA specific employee details
1275: -- Person Id
1276: select max(person_id)
1277: into l_person_id
1278: from per_all_assignments_f
1279: where assignment_id = p_assignment_id;
1280:
1281: -- Tax Reference Number (Income Tax Number)
1282: begin

Line 2011: per_all_assignments_f paaf,

2007: paa_pre.assignment_action_id prepaid_action_id
2008: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2009: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2013: pay_payroll_actions ppa_run, -- Payroll Action of Run
2014: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2015: where ppa_arch.payroll_action_id = p_pact_id