APPS.IGS_PS_GEN_001 dependencies on IGS_CA_TYPE

Line 2335: igs_ca_type ct,

2331: SELECT ci.cal_type,ci.sequence_number
2332: FROM igs_fi_fee_type ft,
2333: igs_fi_f_typ_ca_inst ftci,
2334: igs_ca_inst ci,
2335: igs_ca_type ct,
2336: igs_ca_stat cs
2337: WHERE ft.s_fee_type IN ('TUTNFEE', 'OTHER', 'SPECIAL', 'AUDIT')
2338: AND ft.closed_ind = 'N'
2339: AND ft.fee_type = ftci.fee_type

Line 3983: igs_ca_type ct,

3979: SELECT ci.cal_type,ci.sequence_number
3980: FROM igs_fi_fee_type ft,
3981: igs_fi_f_typ_ca_inst ftci,
3982: igs_ca_inst ci,
3983: igs_ca_type ct,
3984: igs_ca_stat cs
3985: WHERE ft.s_fee_type = 'SPECIAL'
3986: AND ft.closed_ind = 'N'
3987: AND ft.fee_type = ftci.fee_type

Line 4465: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;

4461: opt.unit_section_status NOT IN ('CANCELLED','NOT_OFFERED');
4462:
4463: l_n_wl NUMBER:=0;
4464: l_n_tch_resp_wl NUMBER:=0;
4465: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4466: l_c_tch_cal_type igs_ca_inst.cal_type%TYPE;
4467: l_n_tch_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4468:
4469: TYPE ref_cur_get_teach_cal IS REF CURSOR;

Line 4513: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||

4509:
4510: /* Cursor to get teaching calendars for respective Academic calendars */
4511:
4512: OPEN c_get_tch_cal FOR 'SELECT cir.sub_cal_type,cir.sub_ci_sequence_number'||
4513: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||
4514: ' WHERE cir.sub_cal_type = ct.cal_type AND'||
4515: ' ct.s_cal_cat = :1 AND'||
4516: ' sup_cal_type = :2 AND'||
4517: ' sup_ci_sequence_number = :3 ' USING l_c_s_cal_cat,p_c_cal_type,p_n_cal_seq_num;

Line 4586: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;

4582: SELECT calendar_cat
4583: FROM igs_ps_exp_wl;
4584:
4585: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;
4586: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4587: l_c_cal_type igs_ca_inst.cal_type%TYPE;
4588: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4589:
4590:

Line 4617: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||

4613:
4614: /* Cursor for to get Academic calendar when Teach cal is passed */
4615:
4616: OPEN c_get_cal FOR 'SELECT cir.sup_cal_type,cir.sup_ci_sequence_number'||
4617: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||
4618: ' WHERE cir.sup_cal_type = ct.cal_type AND'||
4619: ' ct.s_cal_cat = :1 AND'||
4620: ' sub_cal_type = :2 AND'||
4621: ' sub_ci_sequence_number = :3 ' USING l_c_s_cal_cat,p_c_cal_type,p_n_cal_seq_num;