APPS.IGS_PR_GEN_006 dependencies on DUAL

Line 1053: FROM dual;

1049: FROM IGS_PR_RU_CAT prgc
1050: WHERE prgc.progression_rule_cat = p_progression_rule_cat;
1051: CURSOR c_pra_sequence_number IS
1052: SELECT IGS_PR_PRA_SEQUENCE_NO_S.NEXTVAL
1053: FROM dual;
1054: CURSOR c_pro_sequence_number IS
1055: --gjha Changed the sequence fromPRA to PRO.
1056:
1057: SELECT IGS_PR_PRO_SEQUENCE_NO_S.NEXTVAL

Line 1058: FROM dual;

1054: CURSOR c_pro_sequence_number IS
1055: --gjha Changed the sequence fromPRA to PRO.
1056:
1057: SELECT IGS_PR_PRO_SEQUENCE_NO_S.NEXTVAL
1058: FROM dual;
1059: -- Retrieve child of old IGS_PR_RU_APPL record
1060: CURSOR c_prrc IS
1061: SELECT prrc.prg_cal_type,
1062: prrc.start_sequence_number,

Line 2611: FROM DUAL;

2607: FOR UPDATE NOWAIT;
2608:
2609: CURSOR c_pee_seq_num IS
2610: SELECT IGS_PR_PEE_SEQUEN_S.NEXTVAL
2611: FROM DUAL;
2612:
2613: CURSOR c_pce (
2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

Line 4660: NULL) FROM DUAL;

4656: CURSOR c_decode1 IS
4657: SELECT DECODE( v_etde_table(v_index1).s_encmb_effect_type,
4658: cst_rstr_ge_cp, v_spo_rec.restricted_enrolment_cp,
4659: cst_rstr_le_cp, v_spo_rec.restricted_enrolment_cp,
4660: NULL) FROM DUAL;
4661:
4662: CURSOR c_decode2 IS
4663: SELECT DECODE( v_etde_table(v_index1).s_encmb_effect_type,
4664: cst_rstr_at_ty, v_spo_rec.restricted_attendance_type,

Line 4665: NULL) FROM DUAL;

4661:
4662: CURSOR c_decode2 IS
4663: SELECT DECODE( v_etde_table(v_index1).s_encmb_effect_type,
4664: cst_rstr_at_ty, v_spo_rec.restricted_attendance_type,
4665: NULL) FROM DUAL;
4666: lv_rowid VARCHAR2(25);
4667: BEGIN
4668:
4669: OPEN c_decode1;