APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_RU_OU

Line 1585: IGS_PR_RU_OU.apply_automatically_ind%TYPE;

1581: cst_approved CONSTANT VARCHAR(10) := 'APPROVED';
1582: cst_expired CONSTANT VARCHAR(10) := 'EXPIRED';
1583: v_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;
1584: v_apply_automatically_ind
1585: IGS_PR_RU_OU.apply_automatically_ind%TYPE;
1586: CURSOR c_spo_pro IS
1587: SELECT pro.apply_automatically_ind
1588: FROM IGS_PR_STDNT_PR_OU spo,
1589: IGS_PR_RU_OU pro

Line 1589: IGS_PR_RU_OU pro

1585: IGS_PR_RU_OU.apply_automatically_ind%TYPE;
1586: CURSOR c_spo_pro IS
1587: SELECT pro.apply_automatically_ind
1588: FROM IGS_PR_STDNT_PR_OU spo,
1589: IGS_PR_RU_OU pro
1590: WHERE spo.person_id = p_person_id AND
1591: spo.course_cd = p_course_cd AND
1592: spo.sequence_number = p_sequence_number AND
1593: pro.progression_rule_cat (+) = spo.progression_rule_cat AND

Line 1789: IGS_PR_RU_OU pro

1785: s_unit_type = cst_required;
1786: CURSOR c_spo_pro IS
1787: SELECT pro.apply_automatically_ind
1788: FROM IGS_PR_STDNT_PR_OU spo,
1789: IGS_PR_RU_OU pro
1790: WHERE spo.person_id = p_person_id AND
1791: spo.course_cd = p_course_cd AND
1792: spo.sequence_number = p_sequence_number AND
1793: pro.progression_rule_cat (+) = spo.progression_rule_cat AND