APPS.IGF_AW_MANAGE_AWD dependencies on IGF_AW_FUND_MAST_ALL

Line 43: igf_aw_fund_mast_all fmast

39: SELECT
40: awd.ROWID row_id,awd.*,fmast.fund_code
41: FROM
42: igf_aw_award_all awd,
43: igf_aw_fund_mast_all fmast
44: WHERE
45: awd.award_id = c_award_id AND
46: awd.base_id = c_base_id AND
47: fmast.fund_id = awd.fund_id AND

Line 70: igf_aw_fund_mast_all fmast

66: SELECT
67: awd.ROWID row_id,awd.*,fmast.fund_code
68: FROM
69: igf_aw_award_all awd,
70: igf_aw_fund_mast_all fmast
71: WHERE
72: awd.award_id = c_award_id AND
73: awd.base_id = c_base_id AND
74: fmast.fund_id = awd.fund_id

Line 449: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE

445: p_pid_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
446: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
447: p_run_mode IN VARCHAR2,
448: p_awd_proc_status IN VARCHAR2,
449: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE
450: ) IS
451: --------------------------------------------------------------------------------
452: -- this procedure is called from concurrent manager.
453: -- if the parameters passed are not correct then procedure exits

Line 509: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE

505:
506:
507: --Curson below retrieves the fund code for the given fund id
508: CURSOR c_fund_code(
509: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
510: ) IS
511: SELECT fund_code
512: FROM igf_aw_fund_mast_all
513: WHERE fund_id = c_fund_id;

Line 512: FROM igf_aw_fund_mast_all

508: CURSOR c_fund_code(
509: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
510: ) IS
511: SELECT fund_code
512: FROM igf_aw_fund_mast_all
513: WHERE fund_id = c_fund_id;
514:
515: l_fund_code c_fund_code%ROWTYPE;
516:

Line 524: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE

520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,
521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,
522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
523: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
524: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
525: ) IS
526: SELECT awd.award_id
527: FROM igf_aw_award_all awd
528: WHERE awd.base_id = c_base_id AND

Line 558: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE

554:
555: --Cursor to retrieve all awards for the award year
556: CURSOR c_award_yr(
557: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
558: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
559: ) IS
560: SELECT awd.award_id
561: FROM igf_aw_award_all awd
562: WHERE awd.base_id = c_base_id AND