APPS.CCT_SERVERGROUPROUTING_PUB dependencies on IEU_UWQ_MACTION_DEFS_B

Line 82: from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def

78: --dbms_output.put_line('1:GetAPPforClass='||p_classification);
79: Select def.application_id,decode(def.application_id,511,'TELESERVICE',
80: 521,'TELESALES','OTHER')
81: into p_app_id,p_app_name
82: from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
83: where act.maction_def_id=def.maction_def_id
84: and type.media_type_uuid=p_mediaTypeUUID
85: and type.media_type_id=act.media_type_id
86: and upper(act.classification)=upper(p_classification);

Line 94: from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def

90: Begin
91: Select act.application_id,decode(act.application_id,511,'TELESERVICE',
92: 521,'TELESALES','OTHER')
93: into p_app_id,p_app_name
94: from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
95: where act.maction_def_id=def.maction_def_id
96: and type.media_type_uuid=p_mediaTypeUUID
97: and type.media_type_id=act.media_type_id
98: and upper(act.classification)=upper('unClassified');

Line 105: from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def

101: When no_data_found then
102: Select act.application_id,decode(act.application_id,511,'TELESERVICE',
103: 521,'TELESALES','OTHER')
104: into p_app_id,p_app_name
105: from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
106: where act.maction_def_id=def.maction_def_id
107: and type.media_type_uuid=p_mediaTypeUUID
108: and type.media_type_id=act.media_type_id
109: and act.classification is null;