APPS.IGF_GR_PELL_CALC dependencies on IGF_AW_COA_ITM_TERMS

Line 1974: igf_aw_coa_itm_terms coa

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
1978: AND terms.ld_cal_type = coa.ld_cal_type

Line 2029: FROM igf_aw_coa_itm_terms coa

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,
2028: coa.ld_sequence_number
2029: FROM igf_aw_coa_itm_terms coa
2030: WHERE coa.base_id = l_base_id)
2031: ORDER BY 1;
2032:
2033: l_terms_det_rec c_terms_det%ROWTYPE;

Line 2180: FROM igf_aw_coa_itm_terms coa

2176: prog.course_status = 'ACTIVE' AND
2177: ant_data.program_cd IS NOT NULL AND
2178: (terms.ld_cal_type,terms.ld_sequence_number) IN
2179: (SELECT coa.ld_cal_type, coa.ld_sequence_number
2180: FROM igf_aw_coa_itm_terms coa
2181: WHERE coa.base_id = cp_base_id)
2182: ORDER BY
2183: igf_aw_packaging.get_term_start_date(cp_base_id, terms.ld_cal_type, terms.ld_sequence_number) ASC,
2184: prog.version_number DESC;

Line 2219: FROM igf_aw_coa_itm_terms coa

2215: (terms.ld_cal_type,
2216: terms.ld_sequence_number) IN (
2217: SELECT coa.ld_cal_type,
2218: coa.ld_sequence_number
2219: FROM igf_aw_coa_itm_terms coa
2220: WHERE coa.base_id = cp_base_id
2221: )
2222: GROUP BY terms.ld_cal_type, terms.ld_sequence_number;
2223: -- museshad (Build# FA 157 Pell disbursement rounding)