APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_INSTANCE_ORGS

Line 1894: MSC_INSTANCE_ORGS ins_org,

1890:
1891: CURSOR c1 IS
1892: SELECT tp.Organization_ID
1893: FROM MSC_PARAMETERS tp,
1894: MSC_INSTANCE_ORGS ins_org,
1895: MSC_TRADING_PARTNERS mtp
1896: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1897: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1898: AND ins_org.Organization_ID=tp.ORGANIZATION_ID

Line 2267: from msc_instance_orgs mio,

2263: and msnria.organization_id=org_id;
2264:
2265: CURSOR c_org_list IS
2266: select organization_id
2267: from msc_instance_orgs mio,
2268: msc_trading_partners mtp
2269: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2270: mio.enabled_flag= 1 and
2271: ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (mio.org_group = MSC_CL_COLLECTION.v_coll_prec.org_group_flag)) and