DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on FND_LOOKUP_TYPES

Line 1026: fnd_lookup_types flt

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'
1030: and enabled_flag = 'Y'

Line 1189: fnd_lookup_types flt

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,
1193: 1 , decode(instr(flv.meaning, 'YTD'),

Line 1315: fnd_lookup_types flt

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'
1319: and enabled_flag = 'Y'