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 HR_LOOKUPS

Line 1253: hr_lookups

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
1257: and aei_information1 = lookup_code

Line 1347: hr_lookups

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
1351: and aei_information1 = lookup_code

Line 1457: hr_lookups

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
1461: AND aei_information1 = lookup_code

Line 1596: hr_lookups

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
1600: AND aei_information1 = lookup_code

Line 1692: hr_lookups

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
1696: and aei_information1 = lookup_code

Line 9432: FROM HR_LOOKUPS

9428:
9429: CURSOR csr_lookup_code (c_financial_year varchar2)
9430: IS
9431: SELECT LOOKUP_CODE
9432: FROM HR_LOOKUPS
9433: WHERE lookup_type = 'AU_PS_FINANCIAL_YEAR'
9434: AND enabled_flag = 'Y'
9435: AND meaning =c_financial_year;
9436: