APPS.PAY_GB_AEI_API dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 295: per_assignment_extra_info extra

291: from per_all_assignments_f a,
292: pay_all_payrolls_f pay,
293: hr_soft_coding_keyflex flex,
294: per_assignment_status_types past,
295: per_assignment_extra_info extra
296: where a.person_id = c_person_id
297: and flex.segment1 = c_tax_ref
298: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
299: and a.payroll_id = pay.payroll_id

Line 707: l_old_aei_information3 per_assignment_extra_info.aei_information3%type;

703: l_aggregated_paye_flag per_all_people_f.per_information10%type;
704: l_period_of_service_id number;
705:
706:
707: l_old_aei_information3 per_assignment_extra_info.aei_information3%type;
708: l_old_aei_information4 per_assignment_extra_info.aei_information4%type;
709: l_old_effective_date date;
710: l_old_aggregated_paye_flag per_all_people_f.per_information10%type;
711: l_old_asg_tax_dist varchar2(50);

Line 708: l_old_aei_information4 per_assignment_extra_info.aei_information4%type;

704: l_period_of_service_id number;
705:
706:
707: l_old_aei_information3 per_assignment_extra_info.aei_information3%type;
708: l_old_aei_information4 per_assignment_extra_info.aei_information4%type;
709: l_old_effective_date date;
710: l_old_aggregated_paye_flag per_all_people_f.per_information10%type;
711: l_old_asg_tax_dist varchar2(50);
712: l_old_period_of_service_id number;

Line 713: l_information_type per_assignment_extra_info.information_type%type;

709: l_old_effective_date date;
710: l_old_aggregated_paye_flag per_all_people_f.per_information10%type;
711: l_old_asg_tax_dist varchar2(50);
712: l_old_period_of_service_id number;
713: l_information_type per_assignment_extra_info.information_type%type;
714: l_assignment_extra_info_id number;
715: l_object_version_number number;
716:
717: --

Line 720: from per_assignment_extra_info

716:
717: --
718: cursor csr_old_aei_info(c_assignment_extra_info_id number) is
719: select aei_information3, aei_information4, information_type
720: from per_assignment_extra_info
721: where assignment_extra_info_id = c_assignment_extra_info_id;
722: --
723:
724: --

Line 766: per_assignment_extra_info extra

762: from per_all_assignments_f a,
763: pay_all_payrolls_f pay,
764: hr_soft_coding_keyflex flex,
765: per_assignment_status_types past,
766: per_assignment_extra_info extra
767: where a.person_id = c_person_id
768: and flex.segment1 = c_tax_ref
769: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
770: and a.payroll_id = pay.payroll_id

Line 1416: l_aei_information3 per_assignment_extra_info.aei_information3%type;

1412: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
1413: l_assignment_id per_all_assignments_f.assignment_id%type;
1414: l_object_version_number number;
1415:
1416: l_aei_information3 per_assignment_extra_info.aei_information3%type;
1417: l_aei_information4 per_assignment_extra_info.aei_information4%type;
1418: l_information_type per_assignment_extra_info.information_type%type;
1419:
1420: --

Line 1417: l_aei_information4 per_assignment_extra_info.aei_information4%type;

1413: l_assignment_id per_all_assignments_f.assignment_id%type;
1414: l_object_version_number number;
1415:
1416: l_aei_information3 per_assignment_extra_info.aei_information3%type;
1417: l_aei_information4 per_assignment_extra_info.aei_information4%type;
1418: l_information_type per_assignment_extra_info.information_type%type;
1419:
1420: --
1421: cursor csr_aei_info(c_assignment_extra_info_id number) is

Line 1418: l_information_type per_assignment_extra_info.information_type%type;

1414: l_object_version_number number;
1415:
1416: l_aei_information3 per_assignment_extra_info.aei_information3%type;
1417: l_aei_information4 per_assignment_extra_info.aei_information4%type;
1418: l_information_type per_assignment_extra_info.information_type%type;
1419:
1420: --
1421: cursor csr_aei_info(c_assignment_extra_info_id number) is
1422: select aei_information3, aei_information4, information_type, assignment_id

Line 1423: from per_assignment_extra_info

1419:
1420: --
1421: cursor csr_aei_info(c_assignment_extra_info_id number) is
1422: select aei_information3, aei_information4, information_type, assignment_id
1423: from per_assignment_extra_info
1424: where assignment_extra_info_id = c_assignment_extra_info_id;
1425: --
1426:
1427: --

Line 1469: per_assignment_extra_info extra

1465: from per_all_assignments_f a,
1466: pay_all_payrolls_f pay,
1467: hr_soft_coding_keyflex flex,
1468: per_assignment_status_types past,
1469: per_assignment_extra_info extra
1470: where a.person_id = c_person_id
1471: and flex.segment1 = c_tax_ref
1472: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1473: and a.payroll_id = pay.payroll_id