APPS.MSC_CL_PURGE_STAGING dependencies on FND_LOOKUP_VALUES

Line 31: lv_tablename FND_LOOKUP_VALUES.attribute1%Type;

27: lv_instance_code VARCHAR2(5);
28: lv_p_del_rej_rec NUMBER;
29:
30:
31: lv_tablename FND_LOOKUP_VALUES.attribute1%Type;
32: lv_errtxt VARCHAR2(300);
33:
34: lv_total number :=0; -- total number of rows deleted
35:

Line 38: FROM FND_LOOKUP_VALUES LV

34: lv_total number :=0; -- total number of rows deleted
35:
36: CURSOR table_names IS
37: SELECT DISTINCT (LV.ATTRIBUTE1) TABLE_NAME
38: FROM FND_LOOKUP_VALUES LV
39: WHERE LV.ENABLED_FLAG = 'Y'
40: AND LV.VIEW_APPLICATION_ID = 700
41: AND SUBSTR (LV.ATTRIBUTE1, 1, 3) = 'MSC'
42: AND nvl(LV.ATTRIBUTE4,2) = 2

Line 248: FROM FND_LOOKUP_VALUES LV

244: AS
245:
246: CURSOR table_names IS
247: SELECT DISTINCT (LV.ATTRIBUTE1) TABLE_NAME
248: FROM FND_LOOKUP_VALUES LV
249: WHERE LV.ENABLED_FLAG = 'Y'
250: AND LV.VIEW_APPLICATION_ID = 700
251: AND SUBSTR (LV.ATTRIBUTE1, 1, 3) = 'MSC'
252: AND LV.LOOKUP_TYPE = 'MSC_X_SETUP_ENTITY_CODE';

Line 282: lv_table_name FND_LOOKUP_VALUES.attribute1%Type;

278: lv_p_del_rej_rec NUMBER;
279: lv_p_instance_id NUMBER ;
280:
281: -- variable for cursor table_names
282: lv_table_name FND_LOOKUP_VALUES.attribute1%Type;
283:
284: -- variable for cursor instance_codes
285: lv_p_instance_code VARCHAR2(5);
286: lv_st_status NUMBER;

Line 1943: FROM fnd_lookup_values

1939:
1940: CURSOR c_tab_list IS
1941:
1942: SELECT attribute1 application_id, attribute2 table_name, attribute5 part_type
1943: FROM fnd_lookup_values
1944: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1945: enabled_flag = 'Y' AND
1946: view_application_id = 700 AND
1947: language = userenv('lang');