DBA Data[Home] [Help]

APPS.MSC_REL_WF dependencies on MSC_PARTNER_CONTACTS

Line 395: msc_partner_contacts mpc

391: CURSOR buyer_c IS
392: select mpc.name
393: from msc_supplies ms,
394: msc_system_items msi,
395: msc_partner_contacts mpc
396: where ms.plan_id = p_plan_id
397: and ms.transaction_id = p_transaction_id
398: and msi.plan_id = ms.plan_id
399: and msi.organization_id = ms.organization_id

Line 409: msc_partner_contacts mpc

405:
406: CURSOR supplier_c IS
407: select mpc.name
408: from msc_supplies ms,
409: msc_partner_contacts mpc
410: where ms.plan_id = p_plan_id
411: and ms.transaction_id = p_transaction_id
412: and ms.sr_instance_id = mpc.sr_instance_id
413: and ms.supplier_id = mpc.partner_id