APPS.IGF_AW_COA_GEN dependencies on IGF_AW_AWD_PRD_TERM

Line 48: igf_aw_awd_prd_term trms,

44: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
45: ) IS
46: SELECT SUM(coa.amount)
47: FROM igf_aw_coa_itm_terms coa,
48: igf_aw_awd_prd_term trms,
49: igf_ap_fa_base_rec_all fa,
50: igf_aw_coa_items item
51: WHERE fa.base_id = coa.base_id
52: AND fa.ci_cal_type = trms.ci_cal_type

Line 138: igf_aw_awd_prd_term aprd,

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
141: AND awd.base_id = cp_base_id
142: AND awd.base_id = fa.base_id

Line 1046: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,

1042: END doUnlock;
1043:
1044: PROCEDURE get_coa_months(
1045: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1046: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
1047: p_start_dt OUT NOCOPY DATE,
1048: p_end_dt OUT NOCOPY DATE,
1049: p_coa_months OUT NOCOPY NUMBER
1050: ) IS

Line 1065: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1061: --Who When What
1062: -------------------------------------------------------------------
1063: CURSOR c_terms(
1064: cp_base_id igf_ap_fa_base_rec.base_id%TYPE,
1065: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1066: ) IS
1067: SELECT coa.ld_cal_type,
1068: coa.ld_sequence_number
1069: FROM igf_aw_awd_prd_term ap,

Line 1069: FROM igf_aw_awd_prd_term ap,

1065: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1066: ) IS
1067: SELECT coa.ld_cal_type,
1068: coa.ld_sequence_number
1069: FROM igf_aw_awd_prd_term ap,
1070: igf_ap_fa_base_rec_all fa,
1071: igf_aw_coa_itm_terms coa
1072: WHERE fa.base_id = cp_base_id
1073: AND fa.ci_cal_type = ap.ci_cal_type

Line 1166: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

1162: END get_coa_months;
1163:
1164: FUNCTION coa_duration(
1165: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1166: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
1167: ) RETURN NUMBER AS
1168: ------------------------------------------------------------------
1169: --Created by : veramach, Oracle India
1170: --Date created:

Line 1986: igf_aw_awd_prd_term apt

1982: MINUS
1983: SELECT apt.ld_cal_type,
1984: apt.ld_sequence_number
1985: FROM igf_ap_fa_base_rec_all fab,
1986: igf_aw_awd_prd_term apt
1987: WHERE fab.base_id = c_base_id AND
1988: apt.ci_cal_type = fab.ci_cal_type AND
1989: apt.ci_sequence_number = fab.ci_sequence_number AND
1990: apt.award_prd_cd = c_award_prd_code

Line 2142: p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,

2138:
2139: PROCEDURE get_award_period_dates(
2140: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
2141: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2142: p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
2143: p_start_date OUT NOCOPY DATE,
2144: p_end_date OUT NOCOPY DATE
2145: ) AS
2146: ------------------------------------------------------------------

Line 2163: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

2159: -- Get all terms attached to the awarding period
2160: CURSOR c_load_cal(
2161: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2162: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2163: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
2164: ) IS
2165: SELECT MIN(cal.start_dt) start_date,
2166: MAX(cal.end_dt) end_date
2167: FROM igf_aw_awd_prd_term aprd,

Line 2167: FROM igf_aw_awd_prd_term aprd,

2163: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
2164: ) IS
2165: SELECT MIN(cal.start_dt) start_date,
2166: MAX(cal.end_dt) end_date
2167: FROM igf_aw_awd_prd_term aprd,
2168: igs_ca_inst cal
2169: WHERE aprd.ci_cal_type = cp_ci_cal_type
2170: AND aprd.ci_sequence_number = cp_ci_sequence_number
2171: AND aprd.award_prd_cd = cp_award_prd_code