DBA Data[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGF_LOOKUPS_VIEW

Line 162: g_process_log igf_lookups_view.meaning%TYPE;

158: gn_award_id igf_aw_awd_disb_all.award_id%TYPE;
159:
160: g_accepted_amt award_rec.accepted_amt%TYPE;
161:
162: g_process_log igf_lookups_view.meaning%TYPE;
163: g_award_log igf_lookups_view.meaning%TYPE;
164: g_person_log igf_lookups_view.meaning%TYPE;
165: g_year VARCHAR2(80);
166: g_start_date DATE;

Line 163: g_award_log igf_lookups_view.meaning%TYPE;

159:
160: g_accepted_amt award_rec.accepted_amt%TYPE;
161:
162: g_process_log igf_lookups_view.meaning%TYPE;
163: g_award_log igf_lookups_view.meaning%TYPE;
164: g_person_log igf_lookups_view.meaning%TYPE;
165: g_year VARCHAR2(80);
166: g_start_date DATE;
167: g_end_date DATE;

Line 164: g_person_log igf_lookups_view.meaning%TYPE;

160: g_accepted_amt award_rec.accepted_amt%TYPE;
161:
162: g_process_log igf_lookups_view.meaning%TYPE;
163: g_award_log igf_lookups_view.meaning%TYPE;
164: g_person_log igf_lookups_view.meaning%TYPE;
165: g_year VARCHAR2(80);
166: g_start_date DATE;
167: g_end_date DATE;
168: g_alternate_code igs_ca_inst_all.alternate_code%TYPE;

Line 3226: FROM igf_lookups_view

3222: --Get the Descriptions for the Parameters Passed:
3223: -- Get the details of
3224: CURSOR cur_get_parameters IS
3225: SELECT meaning
3226: FROM igf_lookups_view
3227: WHERE lookup_type = 'IGF_GE_PARAMETERS'
3228: AND lookup_code IN ('AWARD_ID',
3229: 'AWARD_YEAR',
3230: 'FUND_CODE',