APPS.IGF_AW_COA_GEN dependencies on IGF_AW_AWARD_ALL

Line 115: p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL

111:
112: FUNCTION award_amount(
113: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
114: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
115: p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL
116: ) RETURN NUMBER AS
117: ------------------------------------------------------------------
118: --Created by : veramach, Oracle India
119: --Date created: 07-OCT-2004

Line 133: cp_award_id igf_aw_award_all.award_id%TYPE

129:
130: CURSOR c_award_amount(
131: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
132: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
133: cp_award_id igf_aw_award_all.award_id%TYPE
134: ) IS
135: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
136: FROM igf_aw_award_all awd,
137: igf_aw_awd_disb_all disb,

Line 136: FROM igf_aw_award_all awd,

132: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
133: cp_award_id igf_aw_award_all.award_id%TYPE
134: ) IS
135: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
136: FROM igf_aw_award_all awd,
137: igf_aw_awd_disb_all disb,
138: igf_aw_awd_prd_term aprd,
139: igf_ap_fa_base_rec_all fa
140: WHERE disb.award_id = awd.award_id

Line 156: cp_award_id igf_aw_award_all.award_id%TYPE

152: ln_award NUMBER;
153:
154: CURSOR c_award_amount_awd(
155: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
156: cp_award_id igf_aw_award_all.award_id%TYPE
157: ) IS
158: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
159: FROM igf_aw_award_all awd,
160: igf_aw_awd_disb_all disb

Line 159: FROM igf_aw_award_all awd,

155: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
156: cp_award_id igf_aw_award_all.award_id%TYPE
157: ) IS
158: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
159: FROM igf_aw_award_all awd,
160: igf_aw_awd_disb_all disb
161: WHERE disb.award_id = awd.award_id
162: AND awd.base_id = cp_base_id
163: AND awd.award_status IN ('OFFERED', 'ACCEPTED')

Line 1974: FROM igf_aw_award_all awd

1970: c_award_prd_code igf_aw_award_prd.award_prd_cd%TYPE
1971: ) IS
1972: SELECT awd.rowid row_id,
1973: awd.*
1974: FROM igf_aw_award_all awd
1975: WHERE awd.base_id = c_base_id
1976: AND (awd.awd_proc_status_code = 'AWARDED' OR awd.awd_proc_status_code IS NULL)
1977: AND NOT EXISTS
1978: (SELECT disb.ld_cal_type,

Line 2000: FROM igf_aw_award_all awd

1996: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1997: ) IS
1998: SELECT awd.rowid row_id,
1999: awd.*
2000: FROM igf_aw_award_all awd
2001: WHERE awd.base_id = c_base_id
2002: AND (awd.awd_proc_status_code = 'AWARDED' OR awd.awd_proc_status_code IS NULL);
2003:
2004: lv_profile_value VARCHAR2(10);