APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_INSTANCE_ORGS

Line 2476: ' select 1 from MSC_INSTANCE_ORGS '

2472:
2473: lv_exist := 0;
2474:
2475: OPEN c_org_exist FOR
2476: ' select 1 from MSC_INSTANCE_ORGS '
2477: ||' where ORGANIZATION_ID = :sr_tp_id '
2478: ||' and SR_INSTANCE_ID = :instance_id ' USING c_rec.SR_TP_ID, c_rec.SR_INSTANCE_ID;
2479:
2480: FETCH c_org_exist into lv_exist ;

Line 2484: INSERT INTO MSC_INSTANCE_ORGS(

2480: FETCH c_org_exist into lv_exist ;
2481: CLOSE c_org_exist;
2482:
2483: IF lv_exist = 0 THEN
2484: INSERT INTO MSC_INSTANCE_ORGS(
2485: SR_INSTANCE_ID,
2486: ORGANIZATION_ID,
2487: LAST_UPDATE_DATE,
2488: LAST_UPDATED_BY,