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 LV.LOOKUP_TYPE = 'MSC_X_SETUP_ENTITY_CODE';

Line 247: FROM FND_LOOKUP_VALUES LV

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

Line 281: lv_table_name FND_LOOKUP_VALUES.attribute1%Type;

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

Line 1942: FROM fnd_lookup_values

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