APPS.IGS_EN_HESA_PKG dependencies on DUAL

Line 188: FROM dual;

184: v_stat_seq_num igs_he_st_spa.hesa_st_spa_id%TYPE;
185:
186: CURSOR c_stat_seq_num IS
187: SELECT igs_he_st_spa_all_s.NEXTVAL
188: FROM dual;
189:
190: x_rowid VARCHAR2(250);
191: l_org_id NUMBER(15);
192:

Line 531: FROM dual;

527: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;
528:
529: CURSOR c_susa_seq_num IS
530: SELECT igs_he_en_susa_s.NEXTVAL
531: FROM dual;
532:
533: v_rowid VARCHAR2(250);
534:
535: BEGIN

Line 629: FROM dual;

625: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;
626:
627: CURSOR c_susa_seq_num IS
628: SELECT igs_he_en_susa_s.NEXTVAL
629: FROM dual;
630:
631: x_rowid VARCHAR2(250);
632:
633: v_old_franchising igs_he_poous.franchising_activity%TYPE;