APPS.MSC_SATP_FUNC dependencies on MSC_TRADING_PARTNER_SITES

Line 1947: FROM msc_trading_partner_sites mtps,

1943: BEGIN
1944:
1945: SELECT mtps.postal_code, mtps.city, mtps.state, mtps.country
1946: INTO l_postal_code, l_city, l_state, l_country
1947: FROM msc_trading_partner_sites mtps,
1948: msc_tp_site_id_lid tpsid
1949: WHERE tpsid.sr_tp_site_id = p_customer_site_id
1950: AND tpsid.sr_instance_id = p_instance_id
1951: AND rownum = 1