DBA Data[Home] [Help]

APPS.IGF_SL_PREF_LENDER dependencies on IGF_AP_FA_BASE_REC_ALL

Line 191: igf_ap_fa_base_rec_all fa

187: SELECT tdi.ROWID row_id,
188: tdi.*
189: FROM igf_ap_td_item_inst_all tdi,
190: igf_ap_td_item_mst_all tdm,
191: igf_ap_fa_base_rec_all fa
192: WHERE fa.person_id = cp_person_id
193: AND tdi.item_sequence_number = tdm.todo_number
194: AND fa.base_id = tdi.base_id
195: AND tdm.system_todo_type_code = 'PREFLEND'

Line 258: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;

254: l_error_flag BOOLEAN := FALSE;
255: l_error VARCHAR2(80);
256: lv_row_id VARCHAR2(80) := NULL;
257: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
258: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
259: l_success_record_cnt NUMBER := 0;
260: l_error_record_cnt NUMBER := 0;
261: l_message VARCHAR2(2000);
262: l_msg_count NUMBER;