APPS.OTA_AVT_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 38: , ota_activity_versions avt

34: cursor csr_sec_grp is
35: select pbg.security_group_id,
36: pbg.legislation_code
37: from per_business_groups_perf pbg
38: , ota_activity_versions avt
39: -- , ota_activity_definitions tad
40: where avt.activity_version_id = p_activity_version_id
41: -- and tad.activity_id = avt.activity_id
42: and pbg.business_group_id = avt.business_group_id;

Line 113: , ota_activity_versions tav

109:
110: cursor csr_leg_code is
111: select pbg.legislation_code
112: from per_business_groups_perf pbg
113: , ota_activity_versions tav
114: -- , ota_activity_definitions tad
115: where tav.activity_version_id = p_activity_version_id
116: -- and pbg.business_group_id = tad.business_group_id
117: and pbg.business_group_id = tav.business_group_id ;

Line 421: ,ota_activity_versions tav

417: --
418: cursor get_activity is
419: select tad.business_group_id, tad.activity_id
420: from ota_activity_definitions tad
421: ,ota_activity_versions tav
422: where tav.activity_version_id = p_activity_version_id
423: and tav.activity_id = tad.activity_id ;
424: --
425: cursor sel_unique_key is

Line 427: from ota_activity_versions tav

423: and tav.activity_id = tad.activity_id ;
424: --
425: cursor sel_unique_key is
426: select 'Y'
427: from ota_activity_versions tav
428: , ota_activity_versions_tl avt
429: where avt.version_name = p_version_name
430: and avt.activity_version_id = tav.activity_version_id
431: and avt.language = p_language

Line 428: , ota_activity_versions_tl avt

424: --
425: cursor sel_unique_key is
426: select 'Y'
427: from ota_activity_versions tav
428: , ota_activity_versions_tl avt
429: where avt.version_name = p_version_name
430: and avt.activity_version_id = tav.activity_version_id
431: and avt.language = p_language
432: and tav.activity_id = v_activity_id