APPS.IGF_AW_MANAGE_AWD dependencies on IGF_AW_AWARD_PRD

Line 443: p_award_period IN igf_aw_award_prd.award_prd_cd%TYPE,

439: PROCEDURE run(
440: errbuf OUT NOCOPY VARCHAR2,
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,

Line 520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,

516:
517:
518: --Cursor to filter out those awards that fall within the awarding period
519: CURSOR c_awards(
520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,
521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,
522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
523: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
524: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE

Line 521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,

517:
518: --Cursor to filter out those awards that fall within the awarding period
519: CURSOR c_awards(
520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,
521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,
522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
523: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
524: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
525: ) IS

Line 522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,

518: --Cursor to filter out those awards that fall within the awarding period
519: CURSOR c_awards(
520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,
521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,
522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
523: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
524: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
525: ) IS
526: SELECT awd.award_id