APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 575: -- Note: There is no outer join to per_assignment_extra_info, as it is

571:
572: -- This cursor returns all Assignments that are active during,
573: -- or that ends in this UIF Month (not before). It excludes Independent
574: -- Contractors and specific Nature of Person assignments.
575: -- Note: There is no outer join to per_assignment_extra_info, as it is
576: -- mandatory that an Assignment must have a Legal Entity, which
577: -- must be entered on per_assignment_extra_info
578:
579: /* Changes Bug 2798916 - Commenting existing query and rewriting the query */

Line 577: -- must be entered on per_assignment_extra_info

573: -- or that ends in this UIF Month (not before). It excludes Independent
574: -- Contractors and specific Nature of Person assignments.
575: -- Note: There is no outer join to per_assignment_extra_info, as it is
576: -- mandatory that an Assignment must have a Legal Entity, which
577: -- must be entered on per_assignment_extra_info
578:
579: /* Changes Bug 2798916 - Commenting existing query and rewriting the query */
580:
581: /* cursor csr_get_asg (p_pactid number

Line 592: per_assignment_extra_info paei,

588: from per_assignments_f asg,
589: per_assignments_f asg3,
590: --pay_payrolls_f ppf, -- Bug 2608190
591: pay_payroll_actions ppa_arch,
592: per_assignment_extra_info paei,
593: per_periods_of_service pds -- Bug 2654703
594: where asg.business_group_id = ppa_arch.business_group_id
595: and asg.period_of_service_id = pds.period_of_service_id -- Bug 2608190
596: and asg3.period_of_service_id = pds.period_of_service_id -- Bug 2608190

Line 654: ,per_assignment_extra_info paei

650: select ppf.person_id
651: ,paa.assignment_id
652: from per_all_people_f ppf
653: ,per_all_assignments_f paa
654: ,per_assignment_extra_info paei
655: ,pay_payroll_actions ppa_arch
656: ,per_periods_of_service pps
657: where paa.business_group_id = ppa_arch.business_group_id
658: and paa.person_id = ppf.person_id

Line 952: l_empl_status per_assignment_extra_info.aei_information2%type;

948: and asg2.assignment_status_type_id = sta.assignment_status_type_id
949: and sta.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN', 'TERM_ASSIGN'); -- Added 'TERM_ASSIGN' for bug 3869426
950:
951: --Assignment UIF Data:
952: l_empl_status per_assignment_extra_info.aei_information2%type;
953: l_reason_non_contrib per_assignment_extra_info.aei_information1%type;
954:
955: cursor csr_asg_uif_data (p_asg_id number) is
956: select paei.aei_information2 Empl_Status,

Line 953: l_reason_non_contrib per_assignment_extra_info.aei_information1%type;

949: and sta.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN', 'TERM_ASSIGN'); -- Added 'TERM_ASSIGN' for bug 3869426
950:
951: --Assignment UIF Data:
952: l_empl_status per_assignment_extra_info.aei_information2%type;
953: l_reason_non_contrib per_assignment_extra_info.aei_information1%type;
954:
955: cursor csr_asg_uif_data (p_asg_id number) is
956: select paei.aei_information2 Empl_Status,
957: paei.aei_information1 Reason_Non_Contrib

Line 958: from per_assignment_extra_info paei

954:
955: cursor csr_asg_uif_data (p_asg_id number) is
956: select paei.aei_information2 Empl_Status,
957: paei.aei_information1 Reason_Non_Contrib
958: from per_assignment_extra_info paei
959: where paei.assignment_id = p_asg_id
960: and paei.aei_information_category = 'ZA_UIF_INFO';
961:
962:

Line 976: l_legal_entity per_assignment_extra_info.aei_information7%type;

972: and flv.enabled_flag = 'Y';
973:
974:
975: --Assignment Legal Entity Data:
976: l_legal_entity per_assignment_extra_info.aei_information7%type;
977:
978: cursor csr_asg_leg_ent_data (p_asg_id number) is
979: select paei.aei_information7 Legal_Entity
980: from per_assignment_extra_info paei

Line 980: from per_assignment_extra_info paei

976: l_legal_entity per_assignment_extra_info.aei_information7%type;
977:
978: cursor csr_asg_leg_ent_data (p_asg_id number) is
979: select paei.aei_information7 Legal_Entity
980: from per_assignment_extra_info paei
981: where paei.assignment_id = p_asg_id
982: and paei.aei_information_category = 'ZA_SPECIFIC_INFO';
983:
984: