APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AW_AWD_DISB_ALL

Line 944: FROM igf_aw_awd_disb_all disb,

940: CURSOR c_get_ear_term_st_date_awd(
941: cp_award_id igf_aw_award_all.award_id%TYPE
942: ) IS
943: SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ear_term_start_date
944: FROM igf_aw_awd_disb_all disb,
945: igf_aw_award_all awd
946: WHERE awd.award_id = cp_award_id
947: AND awd.award_id = disb.award_id
948: ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ASC;