APPS.IGF_AP_PROCESS_CORRECTIONS dependencies on IGF_AP_FA_BASE_REC_ALL

Line 92: igf_ap_fa_base_rec_all far,

88: CURSOR match_isirs (p_base_id NUMBER) IS
89: SELECT isirm.isir_id, isirm.s_email_address, isirm.transaction_num, isirm.original_ssn,
90: isirm.orig_name_id, isirm.first_name, isirm.last_name, isirm.base_id, PE.party_number person_number
91: FROM igf_ap_isir_matched_all isirm,
92: igf_ap_fa_base_rec_all far,
93: hz_parties pe
94: WHERE isirm.base_id = far.base_id
95: AND far.person_id = pe.party_Id
96: AND isirm.system_record_type = 'ORIGINAL'

Line 420: igf_ap_fa_base_rec_all fabase ,

416: CURSOR cur_get_sar_name (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
417: l_sar_number igf_fc_sar_cd_mst.sar_field_number%TYPE ) IS
418: SELECT sar.sar_field_name
419: FROM igf_ap_batch_aw_map map,
420: igf_ap_fa_base_rec_all fabase ,
421: igf_fc_sar_cd_mst sar
422: WHERE fabase.base_id = cp_base_id
423: AND map.ci_cal_type = fabase.ci_cal_type
424: AND map.ci_sequence_number = fabase.ci_sequence_number