APPS.IGF_AP_MK_ISIR_ACT_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

Line 165: FROM igf_ap_fa_base_rec_all FA

161: isir_locked_by,
162: adnl_unsub_loan_elig_flag,
163: lock_awd_flag,
164: lock_coa_flag
165: FROM igf_ap_fa_base_rec_all FA
166: WHERE FA.base_id = cp_base_id;
167:
168: g_baseid_exists c_baseid_exists%ROWTYPE;
169:

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

192: l_error_flag BOOLEAN := FALSE;
193: l_error VARCHAR2(80);
194: lv_row_id VARCHAR2(80) := NULL;
195: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
196: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
197: l_person_skip_flag BOOLEAN := FALSE;
198: l_success_record_cnt NUMBER := 0;
199: l_error_record_cnt NUMBER := 0;
200: l_todo_flag BOOLEAN := FALSE;

Line 208: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

204: l_total_record_cnt NUMBER := 0;
205: l_process_flag BOOLEAN := FALSE;
206: l_debug_str VARCHAR2(800) := NULL;
207:
208: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
209: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
210:
211:
212:

Line 209: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

205: l_process_flag BOOLEAN := FALSE;
206: l_debug_str VARCHAR2(800) := NULL;
207:
208: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
209: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
210:
211:
212:
213: -- Cursor for getting the context award year details