APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_LI_DLDB_INTS

Line 96: FROM igf_sl_li_dldb_ints dlint

92: TRUNC(disbursement_activity_date) disbursement_activity_date
93:
94:
95:
96: FROM igf_sl_li_dldb_ints dlint
97: WHERE dlint.ci_alternate_code = cp_alternate_code
98: AND dlint.person_number = cp_person_number
99: AND dlint.award_number_txt = cp_award_number_txt
100: AND dlint.loan_number_txt = cp_loan_number

Line 3305: FROM igf_sl_li_dldb_ints dlint

3301: WHERE adisb.award_id = cp_award_id
3302: AND (disb_num,disb_seq_num) NOT IN
3303: (
3304: SELECT disbursement_num,disbursement_seq_num
3305: FROM igf_sl_li_dldb_ints dlint
3306: WHERE dlint.ci_alternate_code = cp_alternate_code
3307: AND dlint.person_number = cp_person_number
3308: AND dlint.award_number_txt = cp_award_number_txt
3309: AND dlint.loan_number_txt = cp_loan_number

Line 3858: FROM igf_sl_li_dldb_ints

3854: WHERE slchg.loan_number_txt = l_interface.loan_number_txt;
3855:
3856: l_debug_str := l_debug_str || ' Before deleting disb interface table record ';
3857: DELETE
3858: FROM igf_sl_li_dldb_ints
3859: WHERE ci_alternate_code = l_disb_interface.ci_alternate_code
3860: AND person_number = l_disb_interface.person_number
3861: AND award_number_txt = l_disb_interface.award_number_txt
3862: AND loan_number_txt = l_disb_interface.loan_number_txt;