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_CN_AUDIT_XMLGEN dependencies on FND_LOOKUP_VALUES

Line 580: SELECT lookup_code,meaning FROM fnd_lookup_values

576:
577: /* cursor to get lookup values based on lookup_type and lookup_code */
578: CURSOR get_lookup_values(p_type IN VARCHAR2, p_code IN VARCHAR2)
579: IS
580: SELECT lookup_code,meaning FROM fnd_lookup_values
581: WHERE lookup_type = p_type
582: AND enabled_flag = 'Y'
583: AND lookup_code LIKE p_code
584: AND language = USERENV('LANG')

Line 1001: select lookup_code,meaning from fnd_lookup_values

997: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));
998:
999: CURSOR get_lookup_values(p_type IN VARCHAR2, p_code IN VARCHAR2)
1000: IS
1001: select lookup_code,meaning from fnd_lookup_values
1002: where lookup_type = p_type
1003: and enabled_flag = 'Y'
1004: and lookup_code like p_code
1005: and language = userenv('lang')