DBA Data[Home] [Help]

APPS.IGS_PR_VAL_POPU dependencies on IGS_PR_OU_TYPE

Line 57: IGS_PR_OU_TYPE pot,

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
60:
61: WHERE pro.progression_rule_cat = p_progression_rule_cat AND

Line 81: IGS_PR_OU_TYPE pot,

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
84:
85: WHERE pro.progression_rule_cat = p_progression_rule_cat AND

Line 259: igs_pr_ou_type pot,

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
262: AND pro.pra_sequence_number = p_pra_sequence_number
263: AND pro.sequence_number = p_pro_sequence_number

Line 283: IGS_PR_OU_TYPE pot,

279:
280: IGS_PR_OU_UNIT popu,
281:
282:
283: IGS_PR_OU_TYPE pot,
284:
285: IGS_FI_ENC_DFLT_EFT etde
286:
287: WHERE pro.progression_rule_cat = p_progression_rule_cat AND