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

Line 1025: from fnd_lookup_values flv,

1021: and lookup_type = 'W2 BOX 12'
1022: and enabled_flag = 'Y'
1023: */
1024: select meaning
1025: from fnd_lookup_values flv,
1026: fnd_lookup_types flt
1027: where flv.lookup_type = flt.lookup_type
1028: and application_id = 801
1029: and flt.lookup_type = 'W2 BOX 12'

Line 1188: fnd_lookup_values flv,

1184: is
1185: select substr(flv.meaning, 1 , (instr(flv.meaning, 'YTD')-2)) --pbt.balance_type_id
1186: from pay_balance_types pbt,
1187: fnd_application fa,
1188: fnd_lookup_values flv,
1189: fnd_lookup_types flt
1190: where pbt.legislation_code = 'US'
1191: and (
1192: pbt.balance_name = substr(flv.meaning,

Line 1314: from fnd_lookup_values flv,

1310: ln_user_entity_id number := 0;
1311:
1312: cursor c_balance is
1313: select ATTRIBUTE2 meaning
1314: from fnd_lookup_values flv,
1315: fnd_lookup_types flt
1316: where flv.lookup_type = flt.lookup_type
1317: and application_id = 800
1318: and flt.lookup_type = 'W2 BOX 14 USER-DEFINED'