APPS.IGF_SE_GEN_001 dependencies on IGF_AW_FUND_MAST_ALL

Line 6: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

2: /* $Header: IGFSE01B.pls 120.7 2006/02/01 02:56:25 ridas ship $ */
3:
4: PROCEDURE display_auth_params(p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
5: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
6: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
7: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
8: ) IS
9: ------------------------------------------------------------------------------------
10: --Created by : brajendr

Line 44: CURSOR c_fund_dtls (c_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

40: igf_ap_fa_base_rec_all fa
41: WHERE fa.person_id = hz.party_id
42: AND fa.base_id = c_base_id;
43:
44: CURSOR c_fund_dtls (c_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
45: SELECT fund_code
46: FROM igf_aw_fund_mast
47: WHERE fund_id = c_fund_id;
48:

Line 55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;

51: l_fund_code igf_lookups_view.meaning%TYPE;
52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;
56: l_base_id igs_pe_person.person_number%TYPE := NULL;
57:
58: BEGIN
59:

Line 114: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,

110: END display_auth_params;
111:
112:
113: PROCEDURE display_auth_process_log(p_person_number IN igs_pe_person.person_number%TYPE,
114: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
115: p_award_id IN igf_aw_award_v.award_id%TYPE
116: ) IS
117: ------------------------------------------------------------------------------------
118: --Created by : brajendr

Line 788: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

784:
785: PROCEDURE send_work_auth_job(errbuf OUT NOCOPY VARCHAR2,
786: retcode OUT NOCOPY NUMBER,
787: p_awd_cal IN VARCHAR2,
788: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
789: p_dummy IN NUMBER,
790: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
791: ) IS
792: ------------------------------------------------------------------------------------

Line 819: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

815: -------------------------------------------------------------------------------------
816:
817: CURSOR c_auth(cp_awd_cal_type igs_ca_inst.cal_type%TYPE,
818: cp_awd_seq_no igs_ca_inst.sequence_number%TYPE,
819: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
820: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
821: ) IS
822: SELECT awd.award_id,
823: awd.fund_id fund_id,

Line 829: igf_aw_fund_mast_all fmast,

825: awd.base_id,
826: hz.party_number person_number,
827: fmast.fund_code
828: FROM igf_aw_award_all awd,
829: igf_aw_fund_mast_all fmast,
830: igf_aw_fund_cat_all fcat,
831: igf_ap_fa_base_rec_all fa,
832: hz_parties hz
833: WHERE fcat.fed_fund_code = 'FWS'