[Home] [Help]
441: retcode OUT NOCOPY NUMBER,
442: p_award_year IN VARCHAR2,
443: p_award_period IN igf_aw_award_prd.award_prd_cd%TYPE,
444: p_run_type IN VARCHAR2,
445: p_pid_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
446: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
447: p_run_mode IN VARCHAR2,
448: p_awd_proc_status IN VARCHAR2,
449: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE
494:
495:
496: --Cursor below retrieves the group code for the given group id
497: CURSOR c_group_code(
498: c_grp_id igs_pe_prsid_grp_mem_all.group_id%TYPE
499: ) IS
500: SELECT group_cd
501: FROM igs_pe_persid_group_all
502: WHERE group_id = c_grp_id;