APPS.IGS_PR_GEN_004 dependencies on IGS_PR_RU_CA_TYPE_V

Line 5457: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5453: );
5454:
5455: CURSOR c_progression_rule_cat(cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5456: SELECT pra.progression_rule_cat, pra.s_relation_type
5457: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5458: WHERE pra.s_relation_type IN (cst_sca, cst_crv, cst_ou, cst_cty)
5459: AND pra.progression_rule_cat = prctv.progression_rule_cat
5460: AND pra.sequence_number = prctv.pra_sequence_number
5461: AND prctv.prg_cal_type = cp_cal_type

Line 5484: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5480: prctv.start_effective_period, prctv.num_of_applications,
5481: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5482: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5483: pra.course_type
5484: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5485: WHERE pra.s_relation_type = cst_sca
5486: AND pra.progression_rule_cat = cp_prg_rule_cat
5487: AND pra.logical_delete_dt IS NULL
5488: AND pra.sca_person_id = cp_person_id

Line 5506: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5502: prctv.start_effective_period, prctv.num_of_applications,
5503: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5504: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5505: pra.course_type
5506: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5507: WHERE pra.s_relation_type = cst_crv
5508: AND pra.progression_rule_cat = cp_prg_rule_cat
5509: AND pra.logical_delete_dt IS NULL
5510: AND pra.crv_course_cd = cp_course_cd

Line 5528: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5524: prctv.start_effective_period, prctv.num_of_applications,
5525: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5526: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5527: pra.course_type
5528: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5529: WHERE pra.s_relation_type = cst_ou
5530: AND pra.progression_rule_cat = cp_prg_rule_cat
5531: AND pra.logical_delete_dt IS NULL
5532: AND igs_pr_gen_001.prgp_get_crv_cmt (

Line 5548: igs_pr_ru_ca_type_v prctv1

5544: AND cow.version_number = cp_version_number
5545: AND cow.percentage = 100)
5546: OR NOT EXISTS ( SELECT 'x'
5547: FROM igs_pr_ru_appl pra1,
5548: igs_pr_ru_ca_type_v prctv1
5549: WHERE pra1.s_relation_type = 'OU'
5550: AND pra1.logical_delete_dt IS NULL
5551: AND pra1.progression_rule_cat =
5552: pra.progression_rule_cat

Line 5596: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv, igs_ps_ver crv

5592: prctv.start_effective_period, prctv.num_of_applications,
5593: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5594: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5595: pra.course_type
5596: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv, igs_ps_ver crv
5597: WHERE pra.s_relation_type = cst_cty
5598: AND pra.progression_rule_cat = cp_prg_rule_cat
5599: AND pra.logical_delete_dt IS NULL
5600: AND crv.course_type = pra.course_type