[Home] [Help]
1910: SELECT department_code,
1911: resource_code
1912: INTO x_department_code,
1913: x_resource_code
1914: FROM msc_department_resources
1915: WHERE sr_instance_id = p_instance_id
1916: AND organization_id = p_organization_id
1917: AND plan_id = -1
1918: AND department_id = p_department_id
4834: FROM msc_calendar_dates c2,
4835: msc_calendar_dates c1,
4836: msc_atp_rules r,
4837: msc_trading_partners tp,
4838: msc_department_resources dep_res
4839: WHERE dep_res.resource_id = p_resource_id
4840: AND dep_res.department_id = p_department_id
4841: AND dep_res.organization_id = p_organization_id
4842: AND dep_res.plan_id = p_plan_id