APPS.MSC_X_CUST_FACING_RELEASE dependencies on MSC_TP_SITE_ID_LID

Line 689: from msc_tp_site_id_lid mtsil,

685: log_debug('Source Customer Id: '|| lv_sr_cust_id );
686:
687: select mtsil.sr_tp_site_id
688: into lv_sr_cust_site_id
689: from msc_tp_site_id_lid mtsil,
690: msc_trading_partner_sites mtps,
691: msc_trading_partners mtp
692: where mtp.partner_type = 3
693: and mtp.sr_tp_id = l_cust_organization_id