APPS.IGS_PR_VAL_POUS dependencies on IGS_PR_RU_OU

Line 53: FROM IGS_PR_RU_OU pro,

49:
50: SELECT 'X'
51:
52:
53: FROM IGS_PR_RU_OU pro,
54:
55: IGS_PR_OU_TYPE pot,
56:
57: IGS_FI_ENC_DFLT_EFT etde

Line 166: -- is related to a IGS_PR_RU_OU with a progression_outcome_type

162:
163:
164:
165:
166: -- is related to a IGS_PR_RU_OU with a progression_outcome_type
167:
168: -- that relates to a s_encmb_effect_type of EXC_CRS_US and the
169:
170: -- apply_automatically_ind is set to 'Y' that at least one

Line 183: FROM igs_pr_ru_ou pro

179: v_dummy VARCHAR2(1);
180:
181: CURSOR c_pro_pous_pot_etde IS
182: SELECT 'X'
183: FROM igs_pr_ru_ou pro
184: WHERE pro.progression_rule_cat = p_progression_rule_cat
185: AND pro.pra_sequence_number = p_pra_sequence_number
186: AND pro.sequence_number = p_pro_sequence_number
187: AND pro.apply_automatically_ind = 'N'

Line 190: FROM igs_pr_ru_ou pro,

186: AND pro.sequence_number = p_pro_sequence_number
187: AND pro.apply_automatically_ind = 'N'
188: UNION ALL
189: SELECT 'X'
190: FROM igs_pr_ru_ou pro,
191: igs_pr_ou_unit_set pous,
192: igs_pr_ou_type_all pot,
193: igs_fi_enc_dflt_eft etde
194: WHERE pro.progression_rule_cat = p_progression_rule_cat