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 1252: from per_assignment_extra_info,

1248: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1249: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1250: )
1251: and not exists ( select aei_information1
1252: from per_assignment_extra_info,
1253: hr_lookups
1254: where assignment_id = a.assignment_id
1255: and aei_information_category = 'HR_PS_ISSUE_DATE_AU' --Bug 12744254
1256: and aei_information1 is not null

Line 1346: from per_assignment_extra_info,

1342: and paat.payroll_action_id = paas.payroll_action_id
1343: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1344: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp) --2610141
1345: and not exists ( select aei_information1
1346: from per_assignment_extra_info,
1347: hr_lookups
1348: where assignment_id = a.assignment_id
1349: and aei_information_category = 'HR_PS_ISSUE_DATE_AU' --Bug 12744254
1350: and aei_information1 is not null

Line 1456: FROM per_assignment_extra_info,

1452: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1453: )
1454: AND NOT EXISTS
1455: ( SELECT aei_information1
1456: FROM per_assignment_extra_info,
1457: hr_lookups
1458: WHERE assignment_id = a.assignment_id
1459: AND aei_information_category = 'HR_PS_ISSUE_DATE_AU' --Bug 12744254
1460: AND aei_information1 IS NOT NULL

Line 1595: FROM per_assignment_extra_info,

1591: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1592: )
1593: AND NOT EXISTS
1594: ( SELECT aei_information1
1595: FROM per_assignment_extra_info,
1596: hr_lookups
1597: WHERE assignment_id = a.assignment_id
1598: AND aei_information_category = 'HR_PS_ISSUE_DATE_AU'
1599: AND aei_information1 IS NOT NULL

Line 1691: from per_assignment_extra_info,

1687: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1688: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1689: )
1690: and not exists ( select aei_information1
1691: from per_assignment_extra_info,
1692: hr_lookups
1693: where assignment_id = a.assignment_id
1694: and aei_information_category = 'HR_PS_ISSUE_DATE_AU' --Bug 12744254
1695: and aei_information1 is not null