APPS.IEU_UWQ_UTIL_PUB dependencies on IEU_UWQ_MEDIA_TYPES_B

Line 37: ,IEU_UWQ_MEDIA_TYPES_B a

33: SELECT c.application_id
34: INTO l_app_id
35: FROM IEU_UWQ_MACTION_DEFS_B c
36: ,IEU_UWQ_MEDIA_ACTIONS b
37: ,IEU_UWQ_MEDIA_TYPES_B a
38: WHERE B.RESP_ID = P_RESP_ID
39: AND A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
40: AND B.MEDIA_TYPE_ID = A.MEDIA_TYPE_ID
41: AND B.CLASSIFICATION = P_CLASSIFICATION

Line 51: ,IEU_UWQ_MEDIA_TYPES_B a

47: SELECT c.application_id
48: INTO l_app_id
49: FROM IEU_UWQ_MACTION_DEFS_B c
50: ,IEU_UWQ_MEDIA_ACTIONS b
51: ,IEU_UWQ_MEDIA_TYPES_B a
52: WHERE B.RESP_ID = P_RESP_ID
53: AND A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
54: AND B.MEDIA_TYPE_ID = A.MEDIA_TYPE_ID
55: AND B.CLASSIFICATION is null

Line 76: ,IEU_UWQ_MEDIA_TYPES_B a

72: SELECT c.application_id
73: INTO l_app_id
74: FROM IEU_UWQ_MACTION_DEFS_B c
75: ,IEU_UWQ_MEDIA_ACTIONS b
76: ,IEU_UWQ_MEDIA_TYPES_B a
77: WHERE ( B.RESP_ID = -1
78: OR B.RESP_ID IS NULL )
79: AND A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
80: AND B.MEDIA_TYPE_ID = A.MEDIA_TYPE_ID

Line 91: ,IEU_UWQ_MEDIA_TYPES_B a

87: SELECT c.application_id
88: INTO l_app_id
89: FROM IEU_UWQ_MACTION_DEFS_B c
90: ,IEU_UWQ_MEDIA_ACTIONS b
91: ,IEU_UWQ_MEDIA_TYPES_B a
92: WHERE ( B.RESP_ID = -1
93: OR B.RESP_ID IS NULL )
94: AND A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
95: AND B.MEDIA_TYPE_ID = A.MEDIA_TYPE_ID

Line 105: ,IEU_UWQ_MEDIA_TYPES_B a

101: SELECT c.application_id
102: INTO l_app_id
103: FROM IEU_UWQ_MACTION_DEFS_B c
104: ,IEU_UWQ_MEDIA_ACTIONS b
105: ,IEU_UWQ_MEDIA_TYPES_B a
106: WHERE ( B.RESP_ID = -1
107: OR B.RESP_ID IS NULL )
108: AND B.MEDIA_TYPE_ID = -1
109: AND B.CLASSIFICATION is null