APPS.IEU_UWQ_UTIL_PUB dependencies on IEU_UWQ_MACTION_DEFS_B

Line 35: FROM IEU_UWQ_MACTION_DEFS_B c

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

Line 49: FROM IEU_UWQ_MACTION_DEFS_B c

45: -- 2) look for matching Resp ID and Media Type:
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

Line 63: FROM IEU_UWQ_MACTION_DEFS_B c

59: -- 3) look for just matching Resp ID:
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;

Line 74: FROM IEU_UWQ_MACTION_DEFS_B c

70: -- 4) look for (Any) Responsibility (-1) w/ classification
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 )

Line 89: FROM IEU_UWQ_MACTION_DEFS_B c

85: BEGIN
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 )

Line 103: FROM IEU_UWQ_MACTION_DEFS_B c

99: --BEGIN
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 )