APPS.IGS_PR_VAL_PRO dependencies on IGS_PR_OU_UNIT

Line 153: FROM IGS_PR_OU_UNIT_SET

149: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
150: pot.encumbrance_type = etde.encumbrance_type;
151: CURSOR c_pous IS
152: SELECT 'X'
153: FROM IGS_PR_OU_UNIT_SET
154: WHERE progression_rule_cat = p_progression_rule_cat AND
155: pra_sequence_number = p_pra_sequence_number AND
156: pro_sequence_number = p_sequence_number;
157: CURSOR c_pou_1 IS

Line 159: FROM IGS_PR_OU_UNIT

155: pra_sequence_number = p_pra_sequence_number AND
156: pro_sequence_number = p_sequence_number;
157: CURSOR c_pou_1 IS
158: SELECT 'X'
159: FROM IGS_PR_OU_UNIT
160: WHERE progression_rule_cat = p_progression_rule_cat AND
161: pra_sequence_number = p_pra_sequence_number AND
162: pro_sequence_number = p_sequence_number AND
163: s_unit_type = cst_excluded;

Line 166: FROM IGS_PR_OU_UNIT

162: pro_sequence_number = p_sequence_number AND
163: s_unit_type = cst_excluded;
164: CURSOR c_pou_2 IS
165: SELECT 'X'
166: FROM IGS_PR_OU_UNIT
167: WHERE progression_rule_cat = p_progression_rule_cat AND
168: pra_sequence_number = p_pra_sequence_number AND
169: pro_sequence_number = p_sequence_number AND
170: s_unit_type = cst_required;

Line 447: FROM IGS_PR_OU_UNIT_SET pous

443: cst_exc_course,
444: cst_sus_course);
445: CURSOR c_pous IS
446: SELECT 'X'
447: FROM IGS_PR_OU_UNIT_SET pous
448: WHERE pous.progression_rule_cat = p_progression_rule_cat AND
449: pous.pra_sequence_number = p_pra_sequence_number AND
450: pous.pro_sequence_number = p_sequence_number;
451: CURSOR c_pot_etde2 IS

Line 460: FROM IGS_PR_OU_UNIT popu

456: pot.encumbrance_type = etde.encumbrance_type AND
457: etde.s_encmb_effect_type = cst_exc_crs_us;
458: CURSOR c_popu IS
459: SELECT DISTINCT s_unit_type
460: FROM IGS_PR_OU_UNIT popu
461: WHERE popu.progression_rule_cat = p_progression_rule_cat AND
462: popu.pra_sequence_number = p_pra_sequence_number AND
463: popu.pro_sequence_number = p_sequence_number;
464: CURSOR c_pot_etde3 IS