APPS.MSC_RESOURCE_AVAILABILITY dependencies on ALL_TABLES

Line 2725: lv_TABLE_NAME all_tables.TABLE_NAME%TYPE;

2721: v_dblink MSC_APPS_INSTANCES.M2A_DBLINK%TYPE;
2722: LV_SOURCE_APPLICATION VARCHAR2 (3);
2723: v_current_date MSC_NET_RESOURCE_AVAIL.LAST_UPDATE_DATE%TYPE;
2724: v_current_user MSC_NET_RESOURCE_AVAIL.LAST_UPDATED_BY%TYPE;
2725: lv_TABLE_NAME all_tables.TABLE_NAME%TYPE;
2726: NULL_DBLINK CONSTANT VARCHAR2 (1) := ' ';
2727: lv_ahl_schema VARCHAR2(32);
2728:
2729: BEGIN

Line 2764: l_sql_stmt_tab := 'SELECT TABLE_NAME from all_tables'|| v_dblink

2760:
2761:
2762: BEGIN
2763:
2764: l_sql_stmt_tab := 'SELECT TABLE_NAME from all_tables'|| v_dblink
2765: || ' where TABLE_NAME =''AHL_DEPT_RESOURCE_CAPACITY'''
2766: || ' AND owner= ''AHL''';
2767:
2768: EXECUTE IMMEDIATE l_sql_stmt_tab INTO lv_TABLE_NAME;