APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_APPS_INSTANCES

Line 2218: FOR inst IN (select instance_id,instance_type from MSC_APPS_INSTANCES )

2214: --
2215: -- Generate List of Instances passed --
2216: lv_inst_str := ',';
2217: lv_leg_inst_str := ', ';
2218: FOR inst IN (select instance_id,instance_type from MSC_APPS_INSTANCES )
2219: LOOP
2220: if inst.instance_type <> 3 then
2221: lv_inst_str := lv_inst_str || inst.instance_id || ',' ;
2222: else

Line 2243: for inst in (select instance_id from msc_apps_instances where instance_type = 3 ) loop

2239: ELSE -- check the High Value
2240: IF tab.partition_name = substr(tab.table_name,5)||'_DEF' THEN
2241: NULL; -- DO nothing
2242: ELSIF tab.partition_name = substr(tab.table_name,5)||'_LEG' THEN
2243: for inst in (select instance_id from msc_apps_instances where instance_type = 3 ) loop
2244: if instr(', '||substr(tab.high_value,1,tab.high_value_length)||',' , ', '||inst.instance_id||',') < 1 then
2245: IS_BAD_PARTITION := TRUE;
2246: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,'Leg part marked as wrong1:-'||tab.table_name||'.'||tab.partition_name);
2247: end if;

Line 2459: msc_apps_instances mai

2455: mst.table_name,
2456: mai.instance_id instance_id,
2457: mai.instance_type instance_type
2458: FROM msc_staging_table_v mst,
2459: msc_apps_instances mai
2460: WHERE mst.table_name = cp_table AND
2461: mst.PARTITION_TYPE = 'L' AND
2462: (
2463: mai.instance_type = 3 OR