APPS.AMS_TCOP_SUMMARIZATION_PKG dependencies on DUAL

Line 184: FROM DUAL;

180:
181: CURSOR C_GET_CONTACT_SUM_NEXT_SEQ
182: IS
183: SELECT AMS_TCOP_CONTACT_SUM_S.nextval
184: FROM DUAL;
185:
186: --CURSOR C_GET_CONTACT_SUM_DTL_NEXT_SEQ
187: --IS
188: --SELECT AMS_TCOP_CONTACT_SUM_DTL_S.nextval

Line 189: --FROM DUAL;

185:
186: --CURSOR C_GET_CONTACT_SUM_DTL_NEXT_SEQ
187: --IS
188: --SELECT AMS_TCOP_CONTACT_SUM_DTL_S.nextval
189: --FROM DUAL;
190:
191: CURSOR C_GET_CHNL_SUM_NEXT_SEQ
192: IS
193: SELECT AMS_TCOP_CHNL_SUM_S.nextval

Line 194: FROM DUAL;

190:
191: CURSOR C_GET_CHNL_SUM_NEXT_SEQ
192: IS
193: SELECT AMS_TCOP_CHNL_SUM_S.nextval
194: FROM DUAL;
195:
196: CURSOR C_GET_CHNL_SUM_DTL_NEXT_SEQ
197: IS
198: SELECT AMS_TCOP_CHNL_SUM_DTL_S.nextval

Line 199: FROM DUAL;

195:
196: CURSOR C_GET_CHNL_SUM_DTL_NEXT_SEQ
197: IS
198: SELECT AMS_TCOP_CHNL_SUM_DTL_S.nextval
199: FROM DUAL;
200:
201: TYPE NUMBER_ARRAY IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
202:
203: -- Get the list of schedules which fatigued the parties

Line 644: FROM DUAL;

640:
641: CURSOR C_GET_SUM_DTL_SEQ
642: IS
643: SELECT AMS_TCOP_CONTACT_SUM_DTL_S.NEXTVAL
644: FROM DUAL;
645:
646: CURSOR C_GET_CONTACT_SUM_SEQ
647: IS
648: SELECT AMS_TCOP_CONTACT_SUM_S.NEXTVAL

Line 649: FROM DUAL;

645:
646: CURSOR C_GET_CONTACT_SUM_SEQ
647: IS
648: SELECT AMS_TCOP_CONTACT_SUM_S.NEXTVAL
649: FROM DUAL;
650:
651: CURSOR C_GET_CHNL_SUM_DTL_SEQ
652: IS
653: SELECT AMS_TCOP_CHNL_SUM_DTL_S.NEXTVAL

Line 654: FROM DUAL;

650:
651: CURSOR C_GET_CHNL_SUM_DTL_SEQ
652: IS
653: SELECT AMS_TCOP_CHNL_SUM_DTL_S.NEXTVAL
654: FROM DUAL;
655:
656: CURSOR C_GET_CHNL_SUM_SEQ
657: IS
658: SELECT AMS_TCOP_CHNL_SUM_S.NEXTVAL

Line 659: FROM DUAL;

655:
656: CURSOR C_GET_CHNL_SUM_SEQ
657: IS
658: SELECT AMS_TCOP_CHNL_SUM_S.NEXTVAL
659: FROM DUAL;
660:
661: -- Get existing entries from AMS_TCOP_CHANNEL_SUMMARY
662: CURSOR C_GET_EXISTING_PARTY_CHNL (p_party_id_list JTF_NUMBER_TABLE
663: ,p_activity_id NUMBER