APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_INSTANCE_ORGS

Line 2466: ' select 1 from MSC_INSTANCE_ORGS '

2462:
2463: lv_exist := 0;
2464:
2465: OPEN c_org_exist FOR
2466: ' select 1 from MSC_INSTANCE_ORGS '
2467: ||' where ORGANIZATION_ID = :sr_tp_id '
2468: ||' and SR_INSTANCE_ID = :instance_id ' USING c_rec.SR_TP_ID, c_rec.SR_INSTANCE_ID;
2469:
2470: FETCH c_org_exist into lv_exist ;

Line 2474: INSERT INTO MSC_INSTANCE_ORGS(

2470: FETCH c_org_exist into lv_exist ;
2471: CLOSE c_org_exist;
2472:
2473: IF lv_exist = 0 THEN
2474: INSERT INTO MSC_INSTANCE_ORGS(
2475: SR_INSTANCE_ID,
2476: ORGANIZATION_ID,
2477: LAST_UPDATE_DATE,
2478: LAST_UPDATED_BY,