[Home] [Help]
11902: teach_periods.date_offset_cd tp_offset_da,
11903: teach_periods.credit_points_num min_credit_points,
11904: teach_periods.attendance_type_code
11905: FROM igf_aw_dp_terms terms,
11906: igf_aw_dp_teach_prds_v teach_periods,
11907: (SELECT base_id,
11908: ld_cal_type,
11909: ld_sequence_number
11910: FROM igf_aw_coa_itm_terms
11934: teach_periods.date_offset_cd tp_offset_da,
11935: teach_periods.credit_points_num min_credit_points,
11936: teach_periods.attendance_type_code attendance_type_code
11937: FROM igf_aw_dp_terms terms,
11938: igf_aw_dp_teach_prds_v teach_periods
11939: WHERE terms.adplans_id = cp_adplans_id
11940: AND terms.adterms_id = teach_periods.adterms_id
11941: ORDER BY 1;
11942:
11956: teach_periods.date_offset_cd tp_offset_da,
11957: teach_periods.credit_points_num min_credit_points,
11958: teach_periods.attendance_type_code
11959: FROM igf_aw_dp_terms terms,
11960: igf_aw_dp_teach_prds_v teach_periods,
11961: (SELECT base_id,
11962: ld_cal_type,
11963: ld_sequence_number
11964: FROM igf_aw_coa_itm_terms
11987: teach_periods.date_offset_cd tp_offset_da,
11988: teach_periods.credit_points_num min_credit_points,
11989: teach_periods.attendance_type_code attendance_type_code
11990: FROM igf_aw_dp_terms terms,
11991: igf_aw_dp_teach_prds_v teach_periods
11992: WHERE terms.adplans_id = cp_adplans_id
11993: AND terms.adterms_id = teach_periods.adterms_id
11994: ORDER BY 1;
11995:
12036: teach_periods.date_offset_cd tp_offset_da,
12037: teach_periods.credit_points_num min_credit_points,
12038: teach_periods.attendance_type_code
12039: FROM igf_aw_dp_terms terms,
12040: igf_aw_dp_teach_prds_v teach_periods,
12041: (SELECT base_id,
12042: ld_cal_type,
12043: ld_sequence_number,
12044: amount coa_term_amount