APPS.IGF_GR_PELL_CALC dependencies on IGF_AW_DP_TEACH_PRDS

Line 1391: igf_aw_dp_teach_prds teach_periods

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)
1395: AND terms.ld_sequence_number = NVL(cp_ld_sequence_number,terms.ld_sequence_number);

Line 2023: igf_aw_dp_teach_prds_v teach

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 (
2027: SELECT coa.ld_cal_type,

Line 2166: igf_aw_dp_teach_prds_v teach,

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
2170: terms.adplans_id = cp_plan_id AND

Line 2211: igf_aw_dp_teach_prds teach_periods

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
2215: (terms.ld_cal_type,