APPS.IGF_SE_GEN_001 dependencies on IGF_AP_FA_BASE_REC_ALL

Line 7: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

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
11: --Date created : 16-May-2002

Line 37: CURSOR c_person_dtls (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

33: FROM igf_lookups_view
34: WHERE lookup_type='IGF_GE_PARAMETERS'
35: AND lookup_code IN ('AWARD_YEAR','FUND_CODE','PERSON_NUMBER','PARAMETER_PASS');
36:
37: CURSOR c_person_dtls (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
38: SELECT party_number
39: FROM hz_parties hz,
40: igf_ap_fa_base_rec_all fa
41: WHERE fa.person_id = hz.party_id

Line 40: igf_ap_fa_base_rec_all fa

36:
37: CURSOR c_person_dtls (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
38: SELECT party_number
39: FROM hz_parties hz,
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

Line 790: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

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: ------------------------------------------------------------------------------------
793: -- Created by : ssawhney ( Oracle IDC)
794: -- Date created: 2nd jan

Line 820: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

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,
824: fa.person_id person_id,

Line 831: igf_ap_fa_base_rec_all fa,

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'
834: AND awd.award_status = 'ACCEPTED'
835: AND awd.fund_id = NVL(cp_fund_id, awd.fund_id)