APPS.OTA_CTT_BUS dependencies on OTA_CATEGORY_USAGES

Line 32: , ota_category_usages ctu

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , ota_category_usages ctu
33: where ctu.category_usage_id = p_category_usage_id
34: and pbg.business_group_id = ctu.business_group_id;
35: -- Declare local variables
36: --

Line 103: , ota_category_usages ctu

99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , ota_category_usages ctu
104: where ctu.category_usage_id = p_category_usage_id
105: and pbg.business_group_id = ctu.business_group_id;
106: --
107: -- Declare local variables

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 241: ota_category_usages ctu

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)
245: and ( ctu.parent_cat_usage_id = p_parent_cat_usage_id or ctu.type <> 'C')

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)

Line 255: , ota_category_usages ctu

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)
259: and ctu.business_group_id = p_business_group_id

Line 319: ota_category_usages ctu

315: cursor csr_cat_bg_type is
316: select
317: distinct ctu.type, ctu.business_group_id, ctu.parent_cat_usage_id
318: from
319: ota_category_usages ctu
320: where
321: ctu.category_usage_id = p_category_usage_id;
322:
323: