APPS.IGS_AD_GEN_011 dependencies on DUAL

Line 774: FROM dual;

770: gv_first_cori BOOLEAN DEFAULT TRUE;
771: gv_reference_number NUMBER DEFAULT NULL;
772: CURSOR c_igsco_itm_rf_num_s IS
773: SELECT igs_co_itm_rf_num_s.NEXTVAL
774: FROM dual;
775: CURSOR c_igs_co_ou_co_ref_seq_num_s IS
776: SELECT igs_co_ou_co_ref_seq_num_s.NEXTVAL
777: FROM dual;
778: FUNCTION Admpl_Process_Person (

Line 777: FROM dual;

773: SELECT igs_co_itm_rf_num_s.NEXTVAL
774: FROM dual;
775: CURSOR c_igs_co_ou_co_ref_seq_num_s IS
776: SELECT igs_co_ou_co_ref_seq_num_s.NEXTVAL
777: FROM dual;
778: FUNCTION Admpl_Process_Person (
779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,
780: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
781: p_correspondence_type IN igs_ad_appl_ltr.correspondence_type%TYPE,

Line 1631: FROM DUAL;

1627: FROM IGS_CO_LTR_PHR ltp
1628: WHERE ltp.phrase_cd = cp_phrase_cd;
1629: CURSOR c_get_nxt_seq IS
1630: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;
1632:
1633: lv_rowid VARCHAR2(25);
1634:
1635: BEGIN