APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 833: per_assignment_extra_info paei

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
837: and paa.assignment_id = paei.assignment_id

Line 959: from per_assignment_extra_info paei,

955: cursor csr_emp_legal_entity(p_assignment_id number) is
956: select paei.aei_information7 legal_entity_id,
957: hou.name legal_entity_name,
958: hl.telephone_number_1
959: from per_assignment_extra_info paei,
960: hr_organization_units hou,
961: hr_locations hl
962: where paei.assignment_id = p_assignment_id
963: and paei.information_type = 'ZA_SPECIFIC_INFO'

Line 2050: from per_assignment_extra_info paei

2046: for update of paaf.assignment_id;
2047:
2048: cursor csr_get_tax_unit_id (p_assignment_id number) is
2049: select paei.aei_information7
2050: from per_assignment_extra_info paei
2051: where paei.assignment_id = p_assignment_id
2052: and paei.information_type = 'ZA_SPECIFIC_INFO';
2053:
2054: l_payroll_id number;