APPS.IGF_AW_GEN_003 dependencies on IGF_AW_DP_TEACH_PRDS_V

Line 1077: igf_aw_dp_teach_prds_v teach_periods,

1073: teach_periods.date_offset_cd tp_offset_da,
1074: teach_periods.credit_points_num min_credit_points,
1075: teach_periods.attendance_type_code attendance_type_code
1076: FROM igf_aw_dp_terms terms,
1077: igf_aw_dp_teach_prds_v teach_periods,
1078: (SELECT base_id,
1079: ld_cal_type,
1080: ld_sequence_number
1081: FROM igf_aw_coa_itm_terms

Line 1122: igf_aw_dp_teach_prds_v teach_periods,

1118: teach_periods.date_offset_cd tp_offset_da,
1119: teach_periods.credit_points_num min_credit_points,
1120: teach_periods.attendance_type_code attendance_type_code
1121: FROM igf_aw_dp_terms terms,
1122: igf_aw_dp_teach_prds_v teach_periods,
1123: igf_aw_awd_prd_term aprd,
1124: igf_aw_awd_dist_plans dp
1125: WHERE terms.adplans_id = cp_adplans_id
1126: AND terms.adterms_id = teach_periods.adterms_id

Line 1157: igf_aw_dp_teach_prds_v teach_periods,

1153: teach_periods.date_offset_cd tp_offset_da,
1154: teach_periods.credit_points_num min_credit_points,
1155: teach_periods.attendance_type_code attendance_type_code
1156: FROM igf_aw_dp_terms terms,
1157: igf_aw_dp_teach_prds_v teach_periods,
1158: (SELECT base_id,
1159: ld_cal_type,
1160: ld_sequence_number
1161: FROM igf_aw_coa_itm_terms

Line 1199: igf_aw_dp_teach_prds_v teach_periods,

1195: teach_periods.date_offset_cd tp_offset_da,
1196: teach_periods.credit_points_num min_credit_points,
1197: teach_periods.attendance_type_code attendance_type_code
1198: FROM igf_aw_dp_terms terms,
1199: igf_aw_dp_teach_prds_v teach_periods,
1200: igf_aw_awd_dist_plans dp,
1201: igf_aw_awd_prd_term aprd
1202: WHERE terms.adplans_id = cp_adplans_id
1203: AND terms.adterms_id = teach_periods.adterms_id

Line 1231: igf_aw_dp_teach_prds_v teach_periods,

1227: teach_periods.date_offset_cd tp_offset_da,
1228: teach_periods.credit_points_num min_credit_points,
1229: teach_periods.attendance_type_code attendance_type_code
1230: FROM igf_aw_dp_terms terms,
1231: igf_aw_dp_teach_prds_v teach_periods,
1232: (SELECT base_id,
1233: ld_cal_type,
1234: ld_sequence_number,
1235: amount coa_term_amount

Line 1268: igf_aw_dp_teach_prds_v teach_periods,

1264: teach_periods.date_offset_cd tp_offset_da,
1265: teach_periods.credit_points_num min_credit_points,
1266: teach_periods.attendance_type_code attendance_type_code
1267: FROM igf_aw_dp_terms terms,
1268: igf_aw_dp_teach_prds_v teach_periods,
1269: (SELECT base_id,
1270: ld_cal_type,
1271: ld_sequence_number
1272: FROM igf_aw_coa_itm_terms

Line 1302: igf_aw_dp_teach_prds_v teach_periods

1298: teach_periods.date_offset_cd tp_offset_da,
1299: teach_periods.credit_points_num min_credit_points,
1300: teach_periods.attendance_type_code attendance_type_code
1301: FROM igf_aw_dp_terms terms,
1302: igf_aw_dp_teach_prds_v teach_periods
1303: WHERE terms.adplans_id = cp_adplans_id
1304: AND terms.adterms_id = teach_periods.adterms_id
1305: ORDER BY 1;
1306:

Line 1328: igf_aw_dp_teach_prds_v teach_periods,

1324: teach_periods.date_offset_cd tp_offset_da,
1325: teach_periods.credit_points_num min_credit_points,
1326: teach_periods.attendance_type_code attendance_type_code
1327: FROM igf_aw_dp_terms terms,
1328: igf_aw_dp_teach_prds_v teach_periods,
1329: (SELECT base_id,
1330: ld_cal_type,
1331: ld_sequence_number
1332: FROM igf_aw_coa_itm_terms

Line 1359: igf_aw_dp_teach_prds_v teach_periods

1355: teach_periods.date_offset_cd tp_offset_da,
1356: teach_periods.credit_points_num min_credit_points,
1357: teach_periods.attendance_type_code attendance_type_code
1358: FROM igf_aw_dp_terms terms,
1359: igf_aw_dp_teach_prds_v teach_periods
1360: WHERE terms.adplans_id = cp_adplans_id
1361: AND terms.adterms_id = teach_periods.adterms_id
1362: ORDER BY 1;
1363:

Line 1382: igf_aw_dp_teach_prds_v teach_periods,

1378: teach_periods.date_offset_cd tp_offset_da,
1379: teach_periods.credit_points_num min_credit_points,
1380: teach_periods.attendance_type_code attendance_type_code
1381: FROM igf_aw_dp_terms terms,
1382: igf_aw_dp_teach_prds_v teach_periods,
1383: (SELECT base_id,
1384: ld_cal_type,
1385: ld_sequence_number,
1386: amount coa_term_amount