DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PWB dependencies on MSC_PLANS

Line 416: msc_plans p,

412: FUNCTION check_supplier_plans (p_supplier_id number) return boolean IS
413: CURSOR c_supp (l_supplier_id in number) IS
414: SELECT count(*)
415: FROM msc_designators d,
416: msc_plans p,
417: msc_item_suppliers mis
418: WHERE p.organization_id = d.organization_id
419: AND p.sr_instance_id = d.sr_instance_id
420: AND p.compile_designator = d.designator