APPS.MSC_ATP_FUNC dependencies on MSC_TP_SITE_ID_LID
Line 235: FROM msc_tp_site_id_lid tpsid,
231: -- krajan:
232: -- Location ID from msc_location_associations
233: SELECT loc.location_id
234: INTO l_location_id 235: FROM msc_tp_site_id_lid tpsid, 236: msc_location_associations loc
237: -- Modified for Sony Bug 2793404
238: -- Remove customer_id filter and corresponding join to msc_tp_id Bug 2816887
239: WHERE tpsid.sr_tp_site_id = p_customer_site_id