APPS.IGS_PR_GEN_004 dependencies on IGS_PR_RULE

Line 4127: FROM IGS_PR_RULE_OUT_V praov

4123: praov.encmb_course_group_cd,
4124: praov.restricted_enrolment_cp,
4125: praov.restricted_attendance_type,
4126: praov.original_pra_sequence_number
4127: FROM IGS_PR_RULE_OUT_V praov
4128: WHERE praov.progression_rule_cat = p_progression_rule_cat AND
4129: praov.pra_sequence_number = p_pra_sequence_number AND
4130: -- anilk, bug#2784198
4131: praov.logical_delete_dt IS NULL AND

Line 5127: v_rul_sequence_number IGS_PR_RULE.rul_sequence_number%TYPE;

5123: RETURN BOOLEAN
5124: IS
5125: BEGIN -- prgpl_sca_apply_rules
5126: DECLARE
5127: v_rul_sequence_number IGS_PR_RULE.rul_sequence_number%TYPE;
5128: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
5129: v_passed_ind VARCHAR2(1);
5130: v_sprc_passed_ind VARCHAR2(1);
5131: CURSOR c_pr (

Line 5132: cp_progression_rule_cat IGS_PR_RULE.progression_rule_cat%TYPE,

5128: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
5129: v_passed_ind VARCHAR2(1);
5130: v_sprc_passed_ind VARCHAR2(1);
5131: CURSOR c_pr (
5132: cp_progression_rule_cat IGS_PR_RULE.progression_rule_cat%TYPE,
5133: cp_progression_rule_cd IGS_PR_RULE.progression_rule_cd%TYPE) IS
5134: SELECT pr.rul_sequence_number
5135: FROM IGS_PR_RULE pr
5136: WHERE pr.progression_rule_cat = cp_progression_rule_cat AND

Line 5133: cp_progression_rule_cd IGS_PR_RULE.progression_rule_cd%TYPE) IS

5129: v_passed_ind VARCHAR2(1);
5130: v_sprc_passed_ind VARCHAR2(1);
5131: CURSOR c_pr (
5132: cp_progression_rule_cat IGS_PR_RULE.progression_rule_cat%TYPE,
5133: cp_progression_rule_cd IGS_PR_RULE.progression_rule_cd%TYPE) IS
5134: SELECT pr.rul_sequence_number
5135: FROM IGS_PR_RULE pr
5136: WHERE pr.progression_rule_cat = cp_progression_rule_cat AND
5137: pr.progression_rule_cd = cp_progression_rule_cd;

Line 5135: FROM IGS_PR_RULE pr

5131: CURSOR c_pr (
5132: cp_progression_rule_cat IGS_PR_RULE.progression_rule_cat%TYPE,
5133: cp_progression_rule_cd IGS_PR_RULE.progression_rule_cd%TYPE) IS
5134: SELECT pr.rul_sequence_number
5135: FROM IGS_PR_RULE pr
5136: WHERE pr.progression_rule_cat = cp_progression_rule_cat AND
5137: pr.progression_rule_cd = cp_progression_rule_cd;
5138: CURSOR c_sprc (
5139: cp_progression_rule_cat IGS_PR_SDT_PR_RU_CK.progression_rule_cat%TYPE,