APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on FND_LOOKUP_VALUES

Line 1286: FROM fnd_lookup_values

1282: lv_prod_short_name varchar2(30);
1283:
1284: CURSOR c_tab_list IS
1285: SELECT attribute1 application_id, attribute2 table_name
1286: FROM fnd_lookup_values
1287: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1288: enabled_flag = 'Y' AND
1289: view_application_id = 700 AND
1290: language = userenv('lang') AND

Line 1349: FROM fnd_lookup_values flv

1345: CURSOR c_tab_list IS
1346: SELECT flv.attribute1 application_id,
1347: flv.attribute2 table_name,
1348: substr(flv.attribute2, 8) || '_' || p_instance_id partition_name
1349: FROM fnd_lookup_values flv
1350: WHERE flv.lookup_type = 'MSC_STAGING_TABLE' AND
1351: flv.enabled_flag = 'Y' AND
1352: flv.view_application_id = 700 AND
1353: flv.language = userenv('lang') AND

Line 1401: FROM fnd_lookup_values

1397: lv_prod_short_name varchar2(30);
1398:
1399: CURSOR c_tab_list IS
1400: SELECT attribute1 application_id, attribute2 table_name
1401: FROM fnd_lookup_values
1402: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1403: enabled_flag = 'Y' AND
1404: view_application_id = 700 AND
1405: language = userenv('lang') AND

Line 1458: FROM fnd_lookup_values

1454: lv_prod_short_name varchar2(30);
1455:
1456: CURSOR c_tab_list IS
1457: SELECT attribute1 application_id, attribute2 table_name
1458: FROM fnd_lookup_values
1459: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1460: enabled_flag = 'Y' AND
1461: view_application_id = 700 AND
1462: language = userenv('lang') AND