eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_LI_IMPORT dependencies on IGF_AP_FA_BASE_REC_ALL

Line 146: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

142:
143: -- Get the ISIR details for the context Person(base_id)
144: -- Bug# 3089841 Removed the payment ISIR check
145: CURSOR c_isir_details(
146: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
147: cp_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE
148: ) IS
149: SELECT i.original_ssn,
150: RPAD(i.orig_name_id,2,' ') orig_name_id,

Line 160: igf_ap_fa_base_rec_all f

156: DECODE(f.award_fmly_contribution_type,
157: '2',i.secondary_efc,
158: i.primary_efc) paid_efc
159: FROM igf_ap_isir_matched_all i,
160: igf_ap_fa_base_rec_all f
161: WHERE i.base_id = cp_base_id
162: AND f.base_id = i.base_id
163: AND i.system_record_type = 'ORIGINAL'
164: AND TO_NUMBER(i.transaction_num) = TO_NUMBER(cp_transaction_num);

Line 168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;

164: AND TO_NUMBER(i.transaction_num) = TO_NUMBER(cp_transaction_num);
165:
166: -- Declaration of global paramters
167: g_award_id igf_aw_award_all.award_id%TYPE;
168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;

Line 169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

165:
166: -- Declaration of global paramters
167: g_award_id igf_aw_award_all.award_id%TYPE;
168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
173: g_awd_yr_status_cd igf_ap_batch_aw_map_all.award_year_status_code%TYPE;

Line 170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;

166: -- Declaration of global paramters
167: g_award_id igf_aw_award_all.award_id%TYPE;
168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
173: g_awd_yr_status_cd igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
174: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

167: g_award_id igf_aw_award_all.award_id%TYPE;
168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
172: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
173: g_awd_yr_status_cd igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
174: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
175: g_disb_pad_str VARCHAR2(10) := ' ';

Line 376: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

372: END derive_rep_pell_id;
373:
374:
375: FUNCTION update_fa_base_data(
376: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
377: p_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE,
378: p_pell_alt_expense igf_ap_fa_base_rec_all.pell_alt_expense%TYPE
379: ) RETURN VARCHAR2 AS
380:

Line 377: p_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE,

373:
374:
375: FUNCTION update_fa_base_data(
376: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
377: p_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE,
378: p_pell_alt_expense igf_ap_fa_base_rec_all.pell_alt_expense%TYPE
379: ) RETURN VARCHAR2 AS
380:
381: /*

Line 378: p_pell_alt_expense igf_ap_fa_base_rec_all.pell_alt_expense%TYPE

374:
375: FUNCTION update_fa_base_data(
376: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
377: p_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE,
378: p_pell_alt_expense igf_ap_fa_base_rec_all.pell_alt_expense%TYPE
379: ) RETURN VARCHAR2 AS
380:
381: /*
382: || Created By : brajendr

Line 400: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

396: */
397:
398: -- Get base record deails
399: CURSOR c_get_base_rec_dtls(
400: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
401: ) IS
402: SELECT ROWID row_id, base.*
403: FROM igf_ap_fa_base_rec_all base
404: WHERE base.base_id = cp_base_id;

Line 403: FROM igf_ap_fa_base_rec_all base

399: CURSOR c_get_base_rec_dtls(
400: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
401: ) IS
402: SELECT ROWID row_id, base.*
403: FROM igf_ap_fa_base_rec_all base
404: WHERE base.base_id = cp_base_id;
405:
406: lc_get_base_rec_dtls c_get_base_rec_dtls%ROWTYPE;
407:

Line 1441: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1437: */
1438:
1439: -- Get the Award details for the refference award number if present
1440: CURSOR c_awd_details(
1441: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1442: cp_award_number igf_aw_award_all.award_number_txt%TYPE
1443: ) IS
1444: SELECT awd.award_id, awd.offered_amt, awd.accepted_amt, awd.fund_id
1445: FROM igf_aw_award_all awd