APPS.IGF_SE_GEN_001 dependencies on IGF_AP_FA_BASE_REC

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 239: PROCEDURE send_work_auth(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

235:
236: END display_payroll_params;
237:
238:
239: PROCEDURE send_work_auth(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
240: p_person_id IN hz_parties.party_id%TYPE,
241: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
242: p_award_id IN igf_aw_award.award_id%TYPE,
243: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 273: cv_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS

269: WHERE fund_id = cv_fund_id;
270:
271: CURSOR c_awd (cv_fund_id igf_aw_fund_mast.fund_id%TYPE,
272: cv_award_id igf_aw_award.award_id%TYPE,
273: cv_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
274: SELECT pit.api_person_id ssn,
275: fmast.ci_cal_type,
276: fmast.ci_sequence_number,
277: awd.base_id,

Line 282: igf_ap_fa_base_rec farec,

278: awd.award_id
279: FROM igf_aw_award awd,
280: igf_aw_fund_cat fcat,
281: igf_aw_fund_mast fmast,
282: igf_ap_fa_base_rec farec,
283: igs_pe_alt_pers_id_v pit,
284: igs_pe_person_id_typ pit_2
285: WHERE awd.fund_id = fmast.fund_id
286: AND awd.base_id = cv_base_id

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)

Line 998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b

994:
995: CURSOR c_auth_count(cv_auth_id igf_se_auth.auth_id%TYPE,
996: cv_person_id hz_parties.party_id%TYPE) IS
997: SELECT COUNT(*) count
998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b
999: WHERE c.auth_id = cv_auth_id
1000: AND c.award_id = a.award_id
1001: AND a.base_id = b.base_id
1002: AND b.person_id = cv_person_id