APPS.IGS_PR_VAL_POPU dependencies on IGS_PR_RU_OU

Line 55: FROM IGS_PR_RU_OU pro,

51: CURSOR c1_pro_pot_etde IS
52:
53: SELECT 'X'
54:
55: FROM IGS_PR_RU_OU pro,
56:
57: IGS_PR_OU_TYPE pot,
58:
59: IGS_FI_ENC_DFLT_EFT etde

Line 79: FROM IGS_PR_RU_OU pro,

75:
76:
77: SELECT 'X'
78:
79: FROM IGS_PR_RU_OU pro,
80:
81: IGS_PR_OU_TYPE pot,
82:
83: IGS_FI_ENC_DFLT_EFT etde

Line 224: -- the record is related to a IGS_PR_RU_OU with the

220: BEGIN -- prgp_val_popu_auto
221:
222: -- When updating or deleting a Progression Outcome Unit record validate that
223:
224: -- the record is related to a IGS_PR_RU_OU with the
225:
226:
227: -- apply_automatically_ind set to 'Y' and a progression_outcome_type
228:

Line 250: FROM igs_pr_ru_ou pro

246: v_dummy VARCHAR2(1);
247:
248: CURSOR c_pro_popu_pot_etde_1 IS
249: SELECT 'X'
250: FROM igs_pr_ru_ou pro
251: WHERE pro.progression_rule_cat = p_progression_rule_cat
252: AND pro.pra_sequence_number = p_pra_sequence_number
253: AND pro.sequence_number = p_pro_sequence_number
254: AND pro.apply_automatically_ind = 'N'

Line 257: FROM igs_pr_ru_ou pro,

253: AND pro.sequence_number = p_pro_sequence_number
254: AND pro.apply_automatically_ind = 'N'
255: UNION ALL
256: SELECT 'X'
257: FROM igs_pr_ru_ou pro,
258: igs_pr_ou_unit popu,
259: igs_pr_ou_type pot,
260: igs_fi_enc_dflt_eft etde
261: WHERE pro.progression_rule_cat = p_progression_rule_cat

Line 278: FROM IGS_PR_RU_OU pro,

274: CURSOR c_pro_popu_pot_etde_2 IS
275:
276: SELECT 'X'
277:
278: FROM IGS_PR_RU_OU pro,
279:
280: IGS_PR_OU_UNIT popu,
281:
282: