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_TYE_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 626: per_assignment_extra_info AEI

622: 'SELECT distinct paf.person_id
623: FROM per_assignments_f paf,
624: pay_payrolls_f PPY,
625: pay_payroll_actions PPA,
626: per_assignment_extra_info AEI
627: WHERE PPA.payroll_action_id = :payroll_action_id
628: AND paf.business_group_id = PPA.business_group_id
629: AND paf.assignment_type = ''E''
630: AND PPY.payroll_id = paf.payroll_id

Line 748: , per_assignment_extra_info aei

744: , asg.assignment_id assignment_id
745: FROM
746: per_all_assignments_f asg
747: , pay_payroll_actions ppa_arch
748: , per_assignment_extra_info aei
749: WHERE
750: ppa_arch.payroll_action_id = pactid
751: AND asg.business_group_id + 0 = ppa_arch.business_group_id
752: AND asg.person_id BETWEEN stperson AND endperson

Line 2612: from per_assignment_extra_info aei

2608: , aei.aei_information10 labour_broker
2609: , aei.aei_information15 foreign_income
2610: , aei.aei_information13 payment_type
2611: , aei.aei_information14 personal_pay_method_id
2612: from per_assignment_extra_info aei
2613: , pay_assignment_actions paa
2614: where paa.assignment_action_id = p_assactid
2615: and aei.assignment_id = paa.assignment_id
2616: and aei.aei_information_category = 'ZA_SPECIFIC_INFO';