APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_BIS_PERIODS

Line 3163: FROM MSC_ST_BIS_PERIODS

3159: DESCRIPTION,
3160: CONTEXT,
3161: YEAR_START_DATE,
3162: QUARTER_START_DATE
3163: FROM MSC_ST_BIS_PERIODS
3164: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
3165:
3166: c_count NUMBER:= 0;
3167:

Line 3182: FROM msc_st_bis_periods

3178: SELECT 1
3179: INTO lv_rec_count
3180: FROM dual
3181: WHERE EXISTS(SELECT 1
3182: FROM msc_st_bis_periods
3183: WHERE sr_instance_id = MSC_CL_COLLECTION.v_instance_id);
3184: EXCEPTION
3185: WHEN NO_DATA_FOUND THEN
3186: lv_rec_count := 0;