APPS.IGF_AW_GEN_004 dependencies on IGF_AW_AWARD_ALL

Line 102: igf_aw_award_all awd,

98: count(distinct awd.award_id) award_count,
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

Line 154: igf_aw_award_all awd,

150: cai.alternate_code,
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

Line 338: cp_base_id igf_aw_award_all.base_id%TYPE

334: -------------------------------------------------------------------
335:
336: -- Get the details of EFC
337: CURSOR c_im_efc(
338: cp_base_id igf_aw_award_all.base_id%TYPE
339: ) IS
340: SELECT coa_duration_num,
341: coa_duration_efc_amt
342: FROM igf_ap_css_profile_all

Line 1153: igf_aw_award_all awd,

1149: p_flag
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

Line 1418: igf_aw_award_all awd,

1414: OPEN l_query_desc FOR
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

Line 1894: FROM igf_aw_award_all aw,

1890: SELECT disb.rowid row_id,disb.*
1891: FROM
1892: igf_db_awd_disb_dtl_all disb
1893: WHERE award_id IN (SELECT award_id
1894: FROM igf_aw_award_all aw,
1895: igf_ap_fa_base_rec_all fbase
1896: WHERE fbase.base_id = aw.base_id AND
1897: fbase.person_id = p_person_id AND
1898: fbase.ci_cal_type = RTRIM(SUBSTR(p_award_year,1,10)) AND