APPS.IGF_AW_PACKAGING dependencies on IGF_AW_DP_TEACH_PRDS

Line 366: FROM igf_aw_dp_teach_prds tp,

362: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
363: ) IS
364: SELECT COUNT(tp.adteach_id) tp,
365: COUNT(DISTINCT terms.adterms_id) terms
366: FROM igf_aw_dp_teach_prds tp,
367: igf_aw_dp_terms terms,
368: igf_aw_awd_dist_plans dp,
369: igf_aw_awd_prd_term aprd
370: WHERE terms.adterms_id = tp.adterms_id

Line 386: FROM igf_aw_dp_teach_prds tp,

382: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
383: ) IS
384: SELECT COUNT(tp.adteach_id) tp,
385: COUNT(DISTINCT terms.adterms_id) terms
386: FROM igf_aw_dp_teach_prds tp,
387: igf_aw_dp_terms terms,
388: (SELECT base_id,
389: ld_cal_type,
390: ld_sequence_number

Line 11906: igf_aw_dp_teach_prds_v teach_periods,

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

Line 11938: igf_aw_dp_teach_prds_v teach_periods

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:

Line 11960: igf_aw_dp_teach_prds_v teach_periods,

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

Line 11991: igf_aw_dp_teach_prds_v teach_periods

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:

Line 12040: igf_aw_dp_teach_prds_v teach_periods,

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