APPS.IGF_SL_DL_PRINT_PNOTE dependencies on DUAL

Line 535: SELECT igf_sl_dl_pnote_bth_s.nextval INTO l_batch_seq_num FROM dual;

531: /* Get phone details */
532: l_person_phone := igf_sl_gen.get_person_phone( r_stafford_det.student_id );
533:
534: IF l_batch_seq_num IS NULL THEN
535: SELECT igf_sl_dl_pnote_bth_s.nextval INTO l_batch_seq_num FROM dual;
536: END IF;
537:
538: --Inorder to rollback this Transaction whenever Lock Error happens
539: SAVEPOINT sp_prom_note;

Line 642: SELECT igf_sl_dl_pnote_bth_s.nextval INTO l_batch_seq_num FROM dual;

638: l_parent_phone := igf_sl_gen.get_person_phone( r_plus_det.p_person_id );
639:
640:
641: IF l_batch_seq_num IS NULL THEN
642: SELECT igf_sl_dl_pnote_bth_s.nextval INTO l_batch_seq_num FROM dual;
643: END IF;
644:
645: --Transaction to be rolled back whenever Lock Error
646: SAVEPOINT sp_prom_note;