APPS.IGF_AW_CANCEL_AWD dependencies on IGF_LOOKUPS_VIEW

Line 18: p_run_mode IN igf_lookups_view.lookup_code%TYPE

14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
18: p_run_mode IN igf_lookups_view.lookup_code%TYPE
19: )
20: RETURN BOOLEAN
21: IS
22: /*

Line 167: p_run_mode IN igf_lookups_view.lookup_code%TYPE

163: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
164: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
165: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_run_mode IN igf_lookups_view.lookup_code%TYPE
168: )
169: IS
170: /*
171: || Created By : museshad

Line 431: p_run_mode IN igf_lookups_view.lookup_code%TYPE,

427: ERRBUF OUT NOCOPY VARCHAR2,
428: RETCODE OUT NOCOPY NUMBER,
429: p_award_year IN VARCHAR2,
430: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
431: p_run_mode IN igf_lookups_view.lookup_code%TYPE,
432: p_base_id IN igf_ap_fa_con_v.base_id%TYPE,
433: p_org_id IN igf_aw_award_all.org_id%TYPE,
434: p_pig IN igs_pe_all_persid_group_v.group_id%TYPE
435: ) AS

Line 462: SELECT meaning FROM igf_lookups_view

458:
459:
460: --Get the Descriptions for the Parameters Passed:
461: CURSOR cur_get_parameters IS
462: SELECT meaning FROM igf_lookups_view
463: WHERE lookup_type='IGF_GE_PARAMETERS'
464: AND lookup_code IN ('AWARD_ID', 'FUND_CODE', 'PARAMETER_PASS', 'PERSON_NUMBER', 'RUN_MODE', 'PERSON_ID_GROUP');
465:
466: --Cursor to fetch the alternate code for award year instance