APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGS_CA_INST

Line 852: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

848: */
849:
850: -- Cursor that fetches the key program from fa base h
851:
852: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
853: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
854: l_message VARCHAR2(4000);
855:
856: -- Cursor that fetched the current enrolled term for

Line 853: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;

849:
850: -- Cursor that fetches the key program from fa base h
851:
852: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
853: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
854: l_message VARCHAR2(4000);
855:
856: -- Cursor that fetched the current enrolled term for
857: -- student

Line 865: igs_ca_inst ci,

861: ci.alternate_code enrolled_term ,
862: TRUNC(ci.start_dt) enrolled_start_dt,
863: TRUNC(ci.end_dt) enrolled_end_dt
864: FROM
865: igs_ca_inst ci,
866: igs_ca_type cty
867: WHERE cty.s_cal_cat = 'LOAD'
868: AND cty.cal_type = ci.cal_type
869: AND (ci.cal_type, ci.sequence_number)

Line 874: FROM igs_ca_inst_rel

870: IN
871: (
872: SELECT sup_cal_type,
873: sup_ci_sequence_number
874: FROM igs_ca_inst_rel
875: WHERE sub_cal_type = l_acad_cal_type
876: AND sub_ci_sequence_number = l_acad_seq_num
877: UNION
878: SELECT sub_cal_type,

Line 880: FROM igs_ca_inst_rel

876: AND sub_ci_sequence_number = l_acad_seq_num
877: UNION
878: SELECT sub_cal_type,
879: sub_ci_sequence_number
880: FROM igs_ca_inst_rel
881: WHERE sup_cal_type = l_acad_cal_type
882: AND sup_ci_sequence_number = l_acad_seq_num
883: )
884: AND

Line 974: igs_ca_inst_all cal_inst,

970: ant_data.ld_cal_type load_cal_type,
971: ant_data.ld_sequence_number load_seq_num
972: FROM
973: igf_aw_awd_prd_term awd_per,
974: igs_ca_inst_all cal_inst,
975: igf_ap_fa_ant_data ant_data,
976: igf_ap_fa_base_rec_all fabase
977: WHERE
978: awd_per.ld_cal_type = cal_inst.cal_type AND

Line 1007: igs_ca_inst_all cal_inst,

1003: ant_data.ld_cal_type load_cal_type,
1004: ant_data.ld_sequence_number load_seq_num
1005: FROM
1006: igf_aw_awd_prd_term awd_per,
1007: igs_ca_inst_all cal_inst,
1008: igf_ap_fa_ant_data ant_data,
1009: igf_ap_fa_base_rec_all fabase
1010: WHERE
1011: awd_per.ld_cal_type = cal_inst.cal_type AND

Line 1033: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

1029: FROM igf_ap_fa_base_rec
1030: WHERE base_id = cp_base_id;
1031:
1032: l_get_cal_det_rec c_get_cal_det%ROWTYPE;
1033: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
1034: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
1035:
1036: BEGIN
1037:

Line 1034: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;

1030: WHERE base_id = cp_base_id;
1031:
1032: l_get_cal_det_rec c_get_cal_det%ROWTYPE;
1033: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
1034: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
1035:
1036: BEGIN
1037:
1038: -- Call generic API get_key_program to get the cource code