DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_EXCEPTION_DETAILS

Line 1480: from msc_exception_details med,

1476:
1477: CURSOR excp_exist(p_plan_id number,
1478: p_demand_id number) IS
1479: select 1
1480: from msc_exception_details med,
1481: msc_demands md
1482: where med.plan_id = md.plan_id
1483: and med.organization_id = md.organization_id
1484: and med.sr_instance_id = md.sr_instance_id

Line 1497: from msc_exception_details med,

1493:
1494: CURSOR subs_excp_exist(p_plan_id number,
1495: p_supply_id number) IS
1496: select 1
1497: from msc_exception_details med,
1498: msc_supplies ms
1499: where med.plan_id = ms.plan_id
1500: and med.organization_id = ms.organization_id
1501: and med.sr_instance_id = ms.sr_instance_id

Line 5859: from msc_exception_details med,

5855:
5856: CURSOR excp_exist(p_plan_id number,
5857: p_demand_id number) IS
5858: select 1
5859: from msc_exception_details med,
5860: msc_demands md
5861: where med.plan_id = md.plan_id
5862: and med.organization_id = md.organization_id
5863: and med.sr_instance_id = md.sr_instance_id