APPS.IGF_AW_PACKAGING dependencies on IGF_AW_AWARD_PRD

Line 712: p_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,

708: END get_plan_desc;
709:
710: PROCEDURE setAPProcStat(
711: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
712: p_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
713: p_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE
714: ) AS
715: ------------------------------------------------------------------
716: --Created by : veramach, Oracle India

Line 13065: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,

13061: l_persid_grp_name c_person_group%ROWTYPE;
13062:
13063: -- Get AP descripton
13064: CURSOR c_ap(
13065: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
13066: cp_award_year VARCHAR2
13067: ) IS
13068: SELECT award_prd_desc
13069: FROM igf_aw_award_prd

Line 13069: FROM igf_aw_award_prd

13065: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
13066: cp_award_year VARCHAR2
13067: ) IS
13068: SELECT award_prd_desc
13069: FROM igf_aw_award_prd
13070: WHERE award_prd_cd = cp_awd_prd_code
13071: AND ci_cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13072: AND ci_sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13073: l_ap igf_aw_award_prd.award_prd_desc%TYPE;

Line 13073: l_ap igf_aw_award_prd.award_prd_desc%TYPE;

13069: FROM igf_aw_award_prd
13070: WHERE award_prd_cd = cp_awd_prd_code
13071: AND ci_cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13072: AND ci_sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13073: l_ap igf_aw_award_prd.award_prd_desc%TYPE;
13074:
13075: -- Get fund code
13076: CURSOR c_fund(
13077: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE