APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_APPS_INSTANCES

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

1942: --
1943: -- Generate List of Instances passed --
1944: lv_inst_str := ',';
1945: lv_leg_inst_str := ', ';
1946: FOR inst IN (select instance_id,instance_type from MSC_APPS_INSTANCES )
1947: LOOP
1948: if inst.instance_type <> 3 then
1949: lv_inst_str := lv_inst_str || inst.instance_id || ',' ;
1950: else

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

1967: ELSE -- check the High Value
1968: IF tab.partition_name = substr(tab.table_name,5)||'_DEF' THEN
1969: NULL; -- DO nothing
1970: ELSIF tab.partition_name = substr(tab.table_name,5)||'_LEG' THEN
1971: for inst in (select instance_id from msc_apps_instances where instance_type = 3 ) loop
1972: if instr(', '||substr(tab.high_value,1,tab.high_value_length)||',' , ', '||inst.instance_id||',') < 1 then
1973: IS_BAD_PARTITION := TRUE;
1974: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,'Leg part marked as wrong1:-'||tab.table_name||'.'||tab.partition_name);
1975: end if;

Line 2187: msc_apps_instances mai

2183: mst.table_name,
2184: mai.instance_id instance_id,
2185: mai.instance_type instance_type
2186: FROM msc_staging_table_v mst,
2187: msc_apps_instances mai
2188: WHERE mst.table_name = cp_table AND
2189: mst.PARTITION_TYPE = 'L' AND
2190: (
2191: mai.instance_type = 3 OR