DBA Data[Home] [Help]

APPS.MSC_X_CP_FLOW dependencies on MSC_PLANS

Line 572: from msc_designators des, msc_plans p, msc_trading_partners mtp

568: BEGIN
569: begin
570: select distinct mtp.calendar_code
571: into l_calendar_code
572: from msc_designators des, msc_plans p, msc_trading_partners mtp
573: where des.designator = p.compile_designator and
574: des.sr_instance_id = p.sr_instance_id and
575: des.organization_id = p.organization_id and
576: des.production = 1 and

Line 712: FROM msc_plans

708: l_request_id NUMBER;
709:
710: CURSOR c_plan_id (p_default_plan_name IN VARCHAR2) IS
711: SELECT plan_id
712: FROM msc_plans
713: WHERE compile_designator = p_default_plan_name
714: ;
715:
716: BEGIN