APPS.BIX_CALL_LOAD_PKG dependencies on BIX_DM_DNIS

Line 137: INSERT /*+ APPEND */ INTO BIX_DM_DNIS

133: IS
134:
135: BEGIN
136:
137: INSERT /*+ APPEND */ INTO BIX_DM_DNIS
138: (
139: dnis_id, dnis, last_update_date, last_updated_by, creation_date
140: )
141: SELECT BIX_DM_DNIS_S.NEXTVAL, DNIS, g_sysdate, g_user_id, g_sysdate

Line 141: SELECT BIX_DM_DNIS_S.NEXTVAL, DNIS, g_sysdate, g_user_id, g_sysdate

137: INSERT /*+ APPEND */ INTO BIX_DM_DNIS
138: (
139: dnis_id, dnis, last_update_date, last_updated_by, creation_date
140: )
141: SELECT BIX_DM_DNIS_S.NEXTVAL, DNIS, g_sysdate, g_user_id, g_sysdate
142: FROM
143: (
144: SELECT DISTINCT decode(DIRECTION, 'OUTBOUND', 'OUTBOUND', DNIS) DNIS
145: FROM BIX_MEDIAS_FOR_WORKER WORK

Line 148: FROM BIX_DM_DNIS DNIS

144: SELECT DISTINCT decode(DIRECTION, 'OUTBOUND', 'OUTBOUND', DNIS) DNIS
145: FROM BIX_MEDIAS_FOR_WORKER WORK
146: WHERE NOT EXISTS
147: (SELECT 1
148: FROM BIX_DM_DNIS DNIS
149: WHERE WORK.DNIS = DNIS.DNIS
150: )
151: AND DNIS IS NOT NULL
152: );