APPS.IGS_PR_GEN_003 dependencies on IGS_EN_STDNT_PS_ATT

Line 473: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

469: cst_credit CONSTANT VARCHAR2(10) := 'CREDIT';
470: cst_granted CONSTANT VARCHAR2(10) := 'GRANTED';
471: cst_todo CONSTANT VARCHAR2(10) := 'TODO';
472: cst_prg_check CONSTANT VARCHAR2(10) := 'PRG_CHECK';
473: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
474: v_sequence_number NUMBER;
475: v_insert_todo BOOLEAN DEFAULT FALSE;
476: v_start_dt DATE;
477: v_cutoff_dt DATE;

Line 480: FROM IGS_EN_STDNT_PS_ATT sca

476: v_start_dt DATE;
477: v_cutoff_dt DATE;
478: CURSOR c_sca IS
479: SELECT sca.version_number
480: FROM IGS_EN_STDNT_PS_ATT sca
481: WHERE sca.person_id = p_person_id AND
482: sca.course_cd = p_course_cd;
483: CURSOR c_spc IS
484: SELECT spc.prg_cal_type,

Line 503: -- If version number not passed then load it from IGS_EN_STDNT_PS_ATT

499: (NVL(p_old_adv_stnd_type, ' ') = cst_credit OR
500: NVL(p_new_adv_stnd_type, ' ') = cst_credit)) OR
501: (NVL(p_old_credit_points, 0) <> NVL(p_new_credit_points, 0)
502: )) THEN
503: -- If version number not passed then load it from IGS_EN_STDNT_PS_ATT
504: -- record
505:
506: IF p_version_number IS NULL THEN
507: OPEN c_sca;