APPS.MSC_RELEASE_PK dependencies on MSC_TRADING_PARTNER_SITES
Line 944: FROM msc_trading_partner_sites tps
940:
941: BEGIN
942: SELECT DECODE(tps.sr_tp_site_id, -1, NULL,tps.sr_tp_site_id)
943: INTO var_location_id 944: FROM msc_trading_partner_sites tps 945: WHERE tps.sr_tp_id = var_org_id
946: AND tps.sr_instance_id= lv_arg_instance_id_new
947: AND tps.partner_type= 3;
948: