APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 899: per_assignment_extra_info paei

895: cursor csr_get_organization(p_payroll_id number
896: ,p_effective_date date) is
897: select distinct paei.aei_information7 legal_entity_id
898: from per_all_assignments_f paa,
899: per_assignment_extra_info paei
900: where paa.payroll_id = p_payroll_id
901: and p_effective_date between paa.effective_start_date
902: and paa.effective_end_date
903: and paa.assignment_id = paei.assignment_id

Line 1056: from per_assignment_extra_info paei,

1052: cursor csr_emp_legal_entity(p_assignment_id number) is
1053: select paei.aei_information7 legal_entity_id,
1054: hou.name legal_entity_name,
1055: hl.telephone_number_1
1056: from per_assignment_extra_info paei,
1057: hr_organization_units hou,
1058: hr_locations hl
1059: where paei.assignment_id = p_assignment_id
1060: and paei.information_type = 'ZA_SPECIFIC_INFO'

Line 2310: from per_assignment_extra_info paei

2306: for update of paaf.assignment_id;
2307:
2308: cursor csr_get_tax_unit_id (p_assignment_id number) is
2309: select paei.aei_information7
2310: from per_assignment_extra_info paei
2311: where paei.assignment_id = p_assignment_id
2312: and paei.information_type = 'ZA_SPECIFIC_INFO';
2313:
2314: l_payroll_id number;