DBA Data[Home] [Help]

APPS.MSC_X_CP_FLOW dependencies on MSC_TRADING_PARTNERS

Line 555: l_calendar_code msc_trading_partners.calendar_code%type;

551: l_result BOOLEAN;
552: l_request_id NUMBER;
553:
554: l_aps_supplier_id NUMBER;
555: l_calendar_code msc_trading_partners.calendar_code%type;
556:
557: CURSOR c_aps_supplier_id (p_supplier_id IN NUMBER) IS
558: SELECT map.tp_key
559: FROM msc_trading_partner_maps map

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