292: l_aps_customer_id NUMBER;
293:
294: CURSOR c_aps_customer_id (p_customer_id IN NUMBER) IS
295: SELECT map.tp_key
296: FROM msc_trading_partner_maps map
297: , msc_company_relationships cr
298: WHERE map.map_type = 1 -- company level mapping
299: AND cr.object_id = p_customer_id
300: AND map.company_key = cr.relationship_id
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
560: , msc_company_relationships cr
561: WHERE map.map_type = 1 -- company level mapping
562: AND cr.object_id = p_supplier_id
563: AND map.company_key = cr.relationship_id