APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_CA_INST

Line 329: FROM igs_ca_inst

325: ********************************************************************************************** */
326:
327: CURSOR cp_st_en_dt(cp_cal_type VARCHAR ,cp_seq_number NUMBER) IS
328: SELECT start_dt, end_dt
329: FROM igs_ca_inst
330: WHERE cal_type = cp_cal_type
331: AND sequence_number = cp_seq_number;
332:
333: cp_st_en_dt_rec cp_st_en_dt%ROWTYPE;

Line 903: FROM igs_ps_uso_cm_grp a, igs_ca_inst_all b

899: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
900:
901: CURSOR cur_group_id (cp_group_name VARCHAR2, cp_alternate_cd VARCHAR2) IS
902: SELECT a.class_meet_group_id
903: FROM igs_ps_uso_cm_grp a, igs_ca_inst_all b
904: WHERE a.class_meet_group_name = cp_group_name
905: AND a.cal_type = b.cal_type
906: AND a.ci_sequence_number =b.sequence_number
907: AND b.alternate_code=cp_alternate_cd;

Line 1460: FROM igs_ps_usec_x_grp a, igs_ca_inst_all b

1456: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
1457:
1458: CURSOR cur_group_id (cp_group_name VARCHAR2, cp_alternate_cd VARCHAR2) IS
1459: SELECT a.usec_x_listed_group_id
1460: FROM igs_ps_usec_x_grp a, igs_ca_inst_all b
1461: WHERE a.usec_x_listed_group_name = cp_group_name
1462: AND a.cal_type = b.cal_type
1463: AND a.ci_sequence_number =b.sequence_number
1464: AND b.alternate_code=cp_alternate_cd;

Line 1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c

1821: AND logical_delete_dt IS NULL;
1822:
1823: CURSOR cur_group (cp_rec_as_us_ai igs_ps_generic_pub.usec_ass_item_grp_rec_type) IS
1824: SELECT a.us_ass_item_group_id
1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c
1826: WHERE a.group_name = cp_rec_as_us_ai.group_name
1827: AND a.uoo_id =b.uoo_id
1828: AND b.unit_cd=cp_rec_as_us_ai.unit_cd
1829: AND b.version_number=cp_rec_as_us_ai.version_number

Line 1956: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

1952: c_tro_perc_sum_rec c_tro_perc_sum%ROWTYPE;
1953:
1954: CURSOR c_uoo_id (cp_usec_tch_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type) IS
1955: SELECT uoo_id
1956: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
1957: WHERE a.unit_cd = cp_usec_tch_resp_rec.unit_cd
1958: AND a.version_number = cp_usec_tch_resp_rec.version_number
1959: AND a.cal_type = b.cal_type
1960: AND a.ci_sequence_number = b.sequence_number

Line 2045: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

2041: l_c_usec_rsvprfc_ser c_usec_rsvprfc_ser%ROWTYPE;
2042:
2043: CURSOR c_uoo_id (cp_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type) IS
2044: SELECT uoo_id
2045: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
2046: WHERE a.unit_cd = cp_usec_rsv_rec.unit_cd
2047: AND a.version_number = cp_usec_rsv_rec.version_number
2048: AND a.cal_type = b.cal_type
2049: AND a.ci_sequence_number = b.sequence_number

Line 2219: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

2215: l_c_usec_wlstprfc_ser c_usec_wlstprfc_ser%ROWTYPE;
2216:
2217: CURSOR c_uoo_id (cp_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type) IS
2218: SELECT uoo_id
2219: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
2220: WHERE a.unit_cd = cp_usec_wlst_rec.unit_cd
2221: AND a.version_number = cp_usec_wlst_rec.version_number
2222: AND a.cal_type = b.cal_type
2223: AND a.ci_sequence_number = b.sequence_number