APPS.IEU_UWQ_UTIL_PUB dependencies on IEU_UWQ_MEDIA_ACTIONS

Line 36: ,IEU_UWQ_MEDIA_ACTIONS b

32: -- 1) look for exact match:
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

Line 50: ,IEU_UWQ_MEDIA_ACTIONS b

46: BEGIN
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

Line 64: ,IEU_UWQ_MEDIA_ACTIONS b

60: BEGIN
61: SELECT c.application_id
62: INTO l_app_id
63: FROM IEU_UWQ_MACTION_DEFS_B c
64: ,IEU_UWQ_MEDIA_ACTIONS b
65: WHERE B.RESP_ID = P_RESP_ID
66: AND C.MACTION_DEF_ID = B.MACTION_DEF_ID
67: AND B.MEDIA_TYPE_ID = -1;
68:

Line 75: ,IEU_UWQ_MEDIA_ACTIONS b

71: BEGIN
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

Line 90: ,IEU_UWQ_MEDIA_ACTIONS b

86: -- 5) look for (Any) Responsibility/default classification
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

Line 104: ,IEU_UWQ_MEDIA_ACTIONS b

100: -- 6) look for (Any) Responsibility/default media type
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