APPS.IGF_AW_CANCEL_AWD dependencies on IGF_AP_FA_CON_V

Line 184: cp_base_id igf_ap_fa_con_v.base_id%TYPE)

180:
181: CURSOR c_award (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
182: cp_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
183: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
184: cp_base_id igf_ap_fa_con_v.base_id%TYPE)
185: IS
186: SELECT
187: awd.award_id,
188: awd.base_id,

Line 432: p_base_id IN igf_ap_fa_con_v.base_id%TYPE,

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
436: /*

Line 476: igf_ap_fa_con_v

472:
473: --Cursor to get the person number for the base id
474: CURSOR cur_get_person IS
475: SELECT person_number FROM
476: igf_ap_fa_con_v
477: WHERE base_id=p_base_id;
478:
479: -- Cursor to get pig description
480: CURSOR cur_get_pig_desc (cp_pig_id igs_pe_persid_group_all.group_id%TYPE)