APPS.IGF_AW_GEN_004 dependencies on IGF_AW_FUND_MAST

Line 89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,

85: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
90: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
91: ) IS
92: SELECT
93: cai.start_dt,

Line 103: igf_aw_fund_mast fmast,

99: fmast.fund_id fund_id,
100: fmast.description fund_name
101: FROM
102: igf_aw_award_all awd,
103: igf_aw_fund_mast fmast,
104: igs_ca_inst_all cai,
105: igf_aw_awd_disb disb
106: WHERE
107: fmast.ci_cal_type = cp_fa_cal_type AND

Line 155: igf_aw_fund_mast fmast,

151: cai.cal_type,
152: cai.sequence_number
153: FROM
154: igf_aw_award_all awd,
155: igf_aw_fund_mast fmast,
156: igs_ca_inst_all cai,
157: igf_aw_awd_disb disb
158: WHERE
159: fmast.ci_cal_type = cp_fa_cal_type AND

Line 1154: igf_aw_fund_mast fmast,

1150: ) data2,
1151: 2 seq
1152: FROM
1153: igf_aw_award_all awd,
1154: igf_aw_fund_mast fmast,
1155: igs_ca_inst_all cai,
1156: igf_aw_awd_disb disb
1157: WHERE
1158: fmast.ci_cal_type = RTRIM (SUBSTR (p_param1, 1, 10))

Line 1419: igf_aw_fund_mast fmast,

1415: SELECT
1416: DISTINCT base.person_id
1417: FROM
1418: igf_aw_award_all awd,
1419: igf_aw_fund_mast fmast,
1420: igs_ca_inst_all cai,
1421: igf_aw_awd_disb disb,
1422: igf_ap_fa_base_rec_all base
1423: WHERE

Line 2089: igf_aw_fund_mast_all fmast

2085: 'Award Type', '',
2086: '-', '

' || lt.fund_description || '

Award Message

',
2087: '' || NVL (lt.fund_description, '-') || '' || NVL (fmast.awd_notice_txt, '-') || '') award_description
2088: FROM igf_aw_awd_ltr_tmp lt,
2089: igf_aw_fund_mast_all fmast
2090: WHERE lt.fund_code = fmast.fund_code(+)
2091: AND lt.ci_cal_type = fmast.ci_cal_type(+)
2092: AND lt.ci_sequence_number = fmast.ci_sequence_number(+)
2093: AND lt.person_id = p_person_id