DBA Data[Home] [Help]

APPS.OTA_SRT_BUS dependencies on OTA_SUPPLIABLE_RESOURCES_TL

Line 240: from ota_suppliable_resources tsr, ota_suppliable_resources_tl srt

236: where supplied_resource_id = p_supplied_resource_id ;
237:
238: cursor csr_tsr is
239: select tsr.supplied_resource_id
240: from ota_suppliable_resources tsr, ota_suppliable_resources_tl srt
241: where tsr.business_group_id = l_business_group_id
242: and srt.supplied_resource_id = tsr.supplied_resource_id
243: and srt.language = p_language
244: and (p_supplied_resource_id is null or p_supplied_resource_id <> srt.supplied_resource_id)