APPS.MSC_RELEASE_PK dependencies on MSC_TRADING_PARTNER_SITES

Line 748: FROM msc_trading_partner_sites tps

744:
745: BEGIN
746: SELECT DECODE(tps.sr_tp_site_id, -1, NULL,tps.sr_tp_site_id)
747: INTO var_location_id
748: FROM msc_trading_partner_sites tps
749: WHERE tps.sr_tp_id = var_org_id
750: AND tps.sr_instance_id= arg_instance_id
751: AND tps.partner_type= 3;
752: