eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

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

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

Line 576: -- must be entered on per_assignment_extra_info

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

Line 591: per_assignment_extra_info paei,

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

Line 653: ,per_assignment_extra_info paei

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

Line 951: l_empl_status per_assignment_extra_info.aei_information2%type;

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

Line 952: l_reason_non_contrib per_assignment_extra_info.aei_information1%type;

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

Line 957: from per_assignment_extra_info paei

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

Line 975: l_legal_entity per_assignment_extra_info.aei_information7%type;

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

Line 979: from per_assignment_extra_info paei

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