APPS.MSC_EXP_WF dependencies on MSC_PARTNER_CONTACTS

Line 2468: FROM msc_partner_contacts cont, msc_system_items sys

2464: p_plan_id in number,
2465: p_org_id in number,
2466: p_instance in number) IS
2467: SELECT cont.name
2468: FROM msc_partner_contacts cont, msc_system_items sys
2469: WHERE sys.inventory_item_id = p_inventory_item_id
2470: AND sys.organization_id = p_org_id
2471: AND sys.sr_instance_id = p_instance
2472: AND sys.plan_id = p_plan_id

Line 2479: FROM msc_partner_contacts cont,

2475: AND cont.partner_type = 4;
2476:
2477: CURSOR SUPCNT_C(p_exception_id in number,p_plan_id in number) IS
2478: SELECT name
2479: FROM msc_partner_contacts cont,
2480: msc_exception_details exp,
2481: msc_supplies ms
2482: WHERE exp.exception_detail_id = p_exception_id
2483: AND exp.plan_id = p_plan_id

Line 2515: FROM msc_partner_contacts cont, msc_demands mgr,

2511: AND mgr.demand_id = p_demand_id;
2512:
2513: CURSOR CUSTCNT_C(p_exception_id in number, p_plan_id in number) IS
2514: SELECT name
2515: FROM msc_partner_contacts cont, msc_demands mgr,
2516: msc_exception_details exp
2517: WHERE exp.exception_detail_id = p_exception_id
2518: AND exp.plan_id = p_plan_id
2519: AND cont.partner_id = mgr.customer_id

Line 2528: FROM msc_partner_contacts cont, msc_demands mgr

2524: AND mgr.plan_id = exp.plan_id;
2525:
2526: CURSOR CUSTCNT_C2(p_demand_id in number, p_plan_id in number) IS
2527: SELECT name
2528: FROM msc_partner_contacts cont, msc_demands mgr
2529: where cont.partner_id = mgr.customer_id
2530: AND cont.partner_site_id = mgr.customer_site_id
2531: AND cont.partner_type = 2
2532: and cont.sr_instance_id = mgr.sr_instance_id