APPS.IGF_AW_GEN_004 dependencies on IGF_AW_AWD_DISB

Line 105: igf_aw_awd_disb disb

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
108: fmast.ci_sequence_number = cp_fa_sequence_number AND
109: awd.base_id = igf_aw_gen_004.get_base_id_for_person (cp_person_id, cp_fa_cal_type, cp_fa_sequence_number) AND

Line 122: FROM igf_aw_awd_disb disb

118: fmast.fund_id = NVL(cp_fund_id, fmast.fund_id)
119: AND
120: NOT EXISTS
121: (SELECT disb.ld_cal_type, disb.ld_sequence_number
122: FROM igf_aw_awd_disb disb
123: WHERE
124: disb.award_id = awd.award_id
125: MINUS
126: SELECT ld_cal_type, ld_sequence_number

Line 157: igf_aw_awd_disb disb

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
160: fmast.ci_sequence_number = cp_fa_sequence_number AND
161: awd.base_id = igf_aw_gen_004.get_base_id_for_person (cp_person_id, cp_fa_cal_type, cp_fa_sequence_number) AND

Line 171: FROM igf_aw_awd_disb disb

167: cai.sequence_number = disb.ld_sequence_number
168: AND
169: NOT EXISTS
170: (SELECT disb.ld_cal_type, disb.ld_sequence_number
171: FROM igf_aw_awd_disb disb
172: WHERE
173: disb.award_id = awd.award_id
174: MINUS
175: SELECT ld_cal_type, ld_sequence_number

Line 1156: igf_aw_awd_disb disb

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))
1159: AND fmast.ci_sequence_number = TO_NUMBER (RTRIM (SUBSTR (p_param1, 11)))
1160: AND awd.base_id = igf_aw_gen_004.get_base_id_for_person (p_person_id, RTRIM (SUBSTR (p_param1, 1, 10)), TO_NUMBER (RTRIM (SUBSTR (p_param1, 11))))

Line 1171: FROM igf_aw_awd_disb disb

1167: AND NVL (awd.offered_amt, 0) > 0
1168: AND
1169: NOT EXISTS
1170: (SELECT disb.ld_cal_type, disb.ld_sequence_number
1171: FROM igf_aw_awd_disb disb
1172: WHERE
1173: disb.award_id = awd.award_id
1174: MINUS
1175: SELECT ld_cal_type, ld_sequence_number

Line 1421: igf_aw_awd_disb disb,

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
1424: fmast.ci_cal_type = LTRIM(RTRIM(SUBSTR(p_parameter_1, 1, 10))) AND
1425: fmast.ci_sequence_number = TO_NUMBER(LTRIM(RTRIM(SUBSTR(p_parameter_1, 11)))) AND

Line 1436: FROM igf_aw_awd_disb disb

1432: cai.sequence_number = disb.ld_sequence_number
1433: AND
1434: NOT EXISTS
1435: (SELECT disb.ld_cal_type, disb.ld_sequence_number
1436: FROM igf_aw_awd_disb disb
1437: WHERE
1438: disb.award_id = awd.award_id
1439: MINUS
1440: SELECT ld_cal_type, ld_sequence_number