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

Line 755: from per_assignment_extra_info,

751: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
752: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
753: )
754: and not exists ( select aei_information1
755: from per_assignment_extra_info,
756: hr_lookups
757: where assignment_id = a.assignment_id
758: and aei_information1 is not null
759: and aei_information1 = lookup_code

Line 835: from per_assignment_extra_info,

831: and paat.payroll_action_id = paas.payroll_action_id
832: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
833: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp) --2610141
834: and not exists ( select aei_information1
835: from per_assignment_extra_info,
836: hr_lookups
837: where assignment_id = a.assignment_id
838: and aei_information1 is not null
839: and aei_information1 = lookup_code

Line 935: FROM per_assignment_extra_info,

931: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
932: )
933: AND NOT EXISTS
934: ( SELECT aei_information1
935: FROM per_assignment_extra_info,
936: hr_lookups
937: WHERE assignment_id = a.assignment_id
938: AND aei_information1 IS NOT NULL
939: AND aei_information1 = lookup_code