DBA Data[Home] [Help]

APPS.OTA_CTT_BUS dependencies on OTA_CATEGORY_USAGES_TL

Line 240: ota_category_usages_tl ctt,

236: cursor csr_cat_name is
237: select
238: distinct ctu.type
239: from
240: ota_category_usages_tl ctt,
241: ota_category_usages ctu
242: where
243: ctt.category_usage_id = ctu.category_usage_id
244: and (p_category_usage_id is null or ctt.category_usage_id <> p_category_usage_id)

Line 254: ota_category_usages_tl ctt

250: /*
251: select
252: distinct ctu.type
253: from
254: ota_category_usages_tl ctt
255: , ota_category_usages ctu
256: where
257: ctt.category_usage_id = ctu.category_usage_id
258: and (p_category_usage_id is null or ctt.category_usage_id <> p_category_usage_id)