[Home] [Help]
APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_PARAMETERS
Line 1881: FROM MSC_PARAMETERS tp,
1877: lv_res_avail_before_sysdate NUMBER; -- Days
1878:
1879: CURSOR c1 IS
1880: SELECT tp.Organization_ID
1881: FROM MSC_PARAMETERS tp,
1882: MSC_INSTANCE_ORGS ins_org,
1883: MSC_TRADING_PARTNERS mtp
1884: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1885: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID