[Home] [Help]
1386: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1387: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1388: ) IS
1389: SELECT COUNT (*) num_disb
1390: FROM igf_aw_dp_terms terms,
1391: igf_aw_dp_teach_prds teach_periods
1392: WHERE terms.adplans_id = cp_adplans_id
1393: AND terms.adterms_id = teach_periods.adterms_id
1394: AND terms.ld_cal_type = NVL(cp_ld_cal_type,terms.ld_cal_type)
1969: SELECT
1970: terms.ld_cal_type,
1971: terms.ld_sequence_number
1972: FROM
1973: igf_aw_dp_terms terms,
1974: igf_aw_coa_itm_terms coa
1975: WHERE
1976: coa.base_id = l_base_id
1977: AND terms.adplans_id = l_adplans_id
1992: SELECT
1993: terms.ld_cal_type,
1994: terms.ld_sequence_number
1995: FROM
1996: igf_aw_dp_terms terms
1997: WHERE
1998: terms.adplans_id = l_adplans_id
1999: GROUP by terms.ld_cal_type,terms.ld_sequence_number
2000: );
2018: teach.tp_perct_num,
2019: teach.attendance_type_code,
2020: teach.credit_points_num,
2021: teach.date_offset_cd
2022: FROM igf_aw_dp_terms terms,
2023: igf_aw_dp_teach_prds_v teach
2024: WHERE terms.adplans_id = l_adplans_id
2025: AND teach.adterms_id = terms.adterms_id
2026: AND (terms.ld_cal_type, terms.ld_sequence_number) IN (
2161: SELECT
2162: ant_data.program_cd key_prog,
2163: prog.version_number key_prog_ver
2164: FROM
2165: igf_aw_dp_terms terms,
2166: igf_aw_dp_teach_prds_v teach,
2167: igf_ap_fa_ant_data ant_data,
2168: igs_ps_ver prog
2169: WHERE
2206: terms.ld_cal_type,
2207: terms.ld_sequence_number,
2208: COUNT(terms.ld_cal_type) tp_count
2209: FROM
2210: igf_aw_dp_terms terms,
2211: igf_aw_dp_teach_prds teach_periods
2212: WHERE
2213: teach_periods.adterms_id = terms.adterms_id AND
2214: terms.adplans_id = cp_plan_id AND