DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on MSC_INSTANCE_ORGS

Line 2384: FROM msc_instance_orgs

2380: WHERE sr_instance_id = p_instance_id and partner_type = 3;*/
2381:
2382: SELECT ORGANIZATION_ID ---bug3049003
2383: BULK COLLECT INTO l_org_ids
2384: FROM msc_instance_orgs
2385: WHERE sr_instance_id = p_instance_id
2386: and org_lrn=l_apps_lrn
2387: and enabled_flag=1;
2388:

Line 3265: FROM msc_instance_orgs

3261:
3262:
3263: SELECT ORGANIZATION_ID ---bug3049003
3264: BULK COLLECT INTO l_org_ids
3265: FROM msc_instance_orgs
3266: WHERE sr_instance_id = p_instance_id
3267: and org_lrn=l_apps_lrn
3268: and enabled_flag=1;
3269:

Line 8957: FROM msc_instance_orgs mio

8953: IF ( NVL(l_count,0) > 0) THEN
8954: msc_util.msc_log('atp_snapshot_hook: Updating msc_plan_organizations..');
8955: UPDATE msc_plan_organizations mpo
8956: SET so_lrn =(SELECT so_lrn
8957: FROM msc_instance_orgs mio
8958: WHERE mio.sr_instance_id=mpo.sr_instance_id
8959: AND mio.organization_id=mpo.organization_id
8960: )
8961: WHERE plan_id=p_plan_id;