APPS.IGF_AW_CANCEL_AWD dependencies on IGF_AW_FUND_MAST

Line 15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

11: */
12:
13: FUNCTION chk_awd_exp_date (
14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
18: p_run_mode IN igf_lookups_view.lookup_code%TYPE
19: )

Line 38: CURSOR c_fund_exp_da(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

34: ||
35: || (reverse chronological order - newest change first)
36: */
37:
38: CURSOR c_fund_exp_da(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
39: IS
40: SELECT fund_exp_da
41: FROM igf_aw_fund_mast_all
42: WHERE fund_id = cp_fund_id;

Line 41: FROM igf_aw_fund_mast_all

37:
38: CURSOR c_fund_exp_da(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
39: IS
40: SELECT fund_exp_da
41: FROM igf_aw_fund_mast_all
42: WHERE fund_id = cp_fund_id;
43:
44: l_awd_exp_date DATE := NULL;
45: l_fund_exp_da igf_aw_fund_mast_all.fund_exp_da%TYPE;

Line 45: l_fund_exp_da igf_aw_fund_mast_all.fund_exp_da%TYPE;

41: FROM igf_aw_fund_mast_all
42: WHERE fund_id = cp_fund_id;
43:
44: l_awd_exp_date DATE := NULL;
45: l_fund_exp_da igf_aw_fund_mast_all.fund_exp_da%TYPE;
46: l_result BOOLEAN;
47:
48: BEGIN
49:

Line 183: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,

179: */
180:
181: CURSOR c_award (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
182: cp_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
183: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
184: cp_base_id igf_ap_fa_con_v.base_id%TYPE)
185: IS
186: SELECT
187: awd.award_id,

Line 194: igf_aw_fund_mast fmast,

190: fmast.fund_code,
191: fcat.fed_fund_code
192: FROM
193: igf_aw_award awd,
194: igf_aw_fund_mast fmast,
195: igf_ap_fa_base_rec fbase,
196: igf_ap_person_v fapv,
197: igf_aw_fund_cat fcat
198: WHERE

Line 456: FROM igf_aw_fund_mast

452: --Bug No:-2272349 Desc :-Cancel Award Routines
453: --Cursor to fetch the Fund COde for the Fund ID
454: CURSOR cur_get_fund_code IS
455: SELECT fund_code
456: FROM igf_aw_fund_mast
457: WHERE fund_id=p_fund_id;
458:
459:
460: --Get the Descriptions for the Parameters Passed:

Line 491: l_fund_code igf_aw_fund_mast.fund_code%TYPE;

487: TYPE l_parameters IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
488: l_para_rec l_parameters;
489: l_alt_code igs_ca_inst.alternate_code%TYPE;
490: l_i NUMBER(2);
491: l_fund_code igf_aw_fund_mast.fund_code%TYPE;
492: l_person_no igf_aw_award_v.person_number%TYPE;
493: -----------------------------------------------------------------------------------------------------------
494:
495: l_ci_cal_type igf_aw_award_v.ci_cal_type%TYPE;

Line 778: igf_aw_fund_mast mst,

774: CURSOR cur_fund_cd IS
775: SELECT
776: fcat.*
777: FROM
778: igf_aw_fund_mast mst,
779: igf_aw_fund_Cat fcat
780: WHERE
781: mst.fund_id = p_fund_id AND
782: fcat.fund_code = mst.fund_code;