APPS.IGF_AW_LI_IMPORT dependencies on IGF_AW_LI_HOLD_INTS

Line 455: FROM igf_aw_li_hold_ints

451: c_1_more_pell_fws_rec c_1_more_pell_fws%ROWTYPE;
452:
453: CURSOR c_get_fa_hold_spnsr IS
454: SELECT 'X' exist_hold
455: FROM igf_aw_li_hold_ints
456: WHERE person_number = li_awd_rec.person_number
457: AND award_number_txt = li_awd_rec.award_number_txt
458: AND ci_alternate_code = li_awd_rec.ci_alternate_code;
459: c_get_fa_hold_spnsr_rec c_get_fa_hold_spnsr%ROWTYPE;

Line 3153: FROM igf_aw_li_hold_ints disbhold

3149: disbhold.creation_date,
3150: disbhold.last_updated_by,
3151: disbhold.last_update_date,
3152: disbhold.last_update_login
3153: FROM igf_aw_li_hold_ints disbhold
3154: WHERE ci_alternate_code = li_awd_disb_rec.ci_alternate_code
3155: AND person_number = li_awd_disb_rec.person_number
3156: AND award_number_txt = li_awd_disb_rec.award_number_txt
3157: AND disbursement_num = li_awd_disb_rec.disbursement_num;

Line 3306: DELETE FROM igf_aw_li_hold_ints

3302: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3303: AND person_number = ctx_li_awd_rec.person_number
3304: AND award_number_txt = ctx_li_awd_rec.award_number_txt;
3305:
3306: DELETE FROM igf_aw_li_hold_ints
3307: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3308: AND person_number = ctx_li_awd_rec.person_number
3309: AND award_number_txt = ctx_li_awd_rec.award_number_txt;
3310: