344: l_company_key NUMBER;
345:
346: CURSOR c_company_key_1 IS
347: SELECT cr.object_id
348: FROM msc_trading_partner_maps map
349: , msc_company_relationships cr
350: WHERE map.map_type = p_map_type
351: AND map.tp_key = p_tp_key
352: AND map.company_key = cr.relationship_id
354: ;
355:
356: CURSOR c_company_key_2 IS
357: SELECT map.company_key
358: FROM msc_trading_partner_maps map
359: , msc_trading_partners tp
360: WHERE map.map_type = p_map_type
361: AND tp.partner_id = map.tp_key
362: AND tp.sr_tp_id = p_tp_key
364: ;
365:
366: CURSOR c_company_key_3 IS
367: SELECT map.company_key
368: FROM msc_trading_partner_maps map
369: WHERE map.map_type = p_map_type
370: AND map.tp_key = p_tp_key
371: ;
372: BEGIN
407: l_tp_key NUMBER;
408:
409: CURSOR c_tp_key_1 IS
410: SELECT map.tp_key
411: FROM msc_trading_partner_maps map
412: , msc_company_relationships cr
413: WHERE map.map_type = p_map_type
414: AND cr.object_id = p_company_key
415: AND map.company_key = cr.relationship_id
418: ;
419:
420: CURSOR c_tp_key_2 IS
421: SELECT tp.sr_tp_id
422: FROM msc_trading_partner_maps map
423: , msc_trading_partners tp
424: WHERE map.map_type = p_map_type
425: AND tp.partner_id = map.tp_key
426: AND map.company_key= p_company_key
428: /*AND tp.partner.partner_type = 3*/
429:
430: CURSOR c_tp_key_3 IS
431: SELECT map.tp_key
432: FROM msc_trading_partner_maps map
433: WHERE map.map_type = p_map_type
434: AND map.company_key = p_company_key
435:
436: ;