APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_AWD_DISB

Line 106: FROM IGF_AW_AWD_DISB_ALL disb

102:
103: CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE) IS
104: SELECT disb.rowid row_id,
105: disb.*
106: FROM IGF_AW_AWD_DISB_ALL disb
107: WHERE award_id = cp_award_id
108: AND trans_type IN ('A', 'P');
109:
110: CURSOR cur_fund_details (cp_award_id NUMBER) IS

Line 178: igf_aw_awd_disb_pkg.update_row(

174: l_trans_type := 'P';
175: END IF;
176: END IF;
177:
178: igf_aw_awd_disb_pkg.update_row(
179: x_rowid => disb_rec.row_id,
180: x_award_id => disb_rec.award_id,
181: x_disb_num => disb_rec.disb_num,
182: x_tp_cal_type => disb_rec.tp_cal_type,

Line 452: IGF_AW_AWD_DISB_ALL disb,

448: -- Cursor to return award status for all awards in an award period
449: CURSOR c_ap_award (cp_ci_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_award_prd_cd VARCHAR2, cp_base_id NUMBER) IS
450: SELECT awd.*
451: FROM IGF_AW_AWARD_ALL awd,
452: IGF_AW_AWD_DISB_ALL disb,
453: IGF_AW_AWD_PRD_TERM ap
454: WHERE awd.base_id = cp_base_id
455: AND awd.publish_in_ss_flag = 'Y'
456: AND awd.award_id = disb.award_id

Line 676: FROM IGF_AW_AWD_DISB

672: fund_mast_rec cur_fund_details%ROWTYPE;
673:
674: CURSOR cur_min_disb_date ( cp_award_id NUMBER) IS
675: SELECT MIN(disb_date)
676: FROM IGF_AW_AWD_DISB
677: WHERE award_id = cp_award_id;
678:
679: sch_disb_date DATE;
680:

Line 816: FROM IGF_AW_AWD_DISB

812: fund_mast_rec cur_fund_details%ROWTYPE;
813:
814: CURSOR cur_min_disb_date (cp_award_id NUMBER) IS
815: SELECT MIN(disb_date)
816: FROM IGF_AW_AWD_DISB
817: WHERE award_id = cp_award_id;
818:
819: sch_disb_date DATE;
820:

Line 956: FROM IGF_AW_AWD_DISB

952: fund_mast_rec cur_fund_details%ROWTYPE;
953:
954: CURSOR cur_min_disb_date (cp_award_id NUMBER) IS
955: SELECT MIN(disb_date)
956: FROM IGF_AW_AWD_DISB
957: WHERE award_id = cp_award_id;
958:
959: sch_disb_date DATE;
960:

Line 1218: FROM IGF_AW_AWD_DISB_ALL disb

1214: cp_ld_cal_type VARCHAR2,
1215: cp_ld_seq_num NUMBER) IS
1216: SELECT disb.rowid row_id,
1217: disb.*
1218: FROM IGF_AW_AWD_DISB_ALL disb
1219: WHERE award_id = cp_award_id
1220: AND ld_cal_type = cp_ld_cal_type
1221: AND ld_sequence_number = cp_ld_seq_num
1222: AND trans_type IN ('A', 'P');

Line 1276: igf_aw_awd_disb_pkg.update_row(

1272: l_dis_amt := TRUNC(l_dis_amt,2);
1273: END IF;
1274: END IF;
1275:
1276: igf_aw_awd_disb_pkg.update_row(
1277: x_rowid => disb_rec.row_id,
1278: x_award_id => disb_rec.award_id,
1279: x_disb_num => disb_rec.disb_num,
1280: x_tp_cal_type => disb_rec.tp_cal_type,

Line 1418: FROM IGF_AW_AWD_DISB

1414: fund_mast_rec cur_fund_details%ROWTYPE;
1415:
1416: CURSOR cur_min_disb_date ( cp_award_id NUMBER) IS
1417: SELECT MIN(disb_date)
1418: FROM IGF_AW_AWD_DISB
1419: WHERE award_id = cp_award_id;
1420:
1421: sch_disb_date DATE;
1422:

Line 1596: FROM IGF_AW_AWD_DISB

1592: fund_mast_rec cur_fund_details%ROWTYPE;
1593:
1594: CURSOR cur_min_disb_date (cp_award_id NUMBER) IS
1595: SELECT MIN(disb_date)
1596: FROM IGF_AW_AWD_DISB
1597: WHERE award_id = cp_award_id;
1598:
1599: sch_disb_date DATE;
1600:

Line 1775: FROM IGF_AW_AWD_DISB

1771: fund_mast_rec cur_fund_details%ROWTYPE;
1772:
1773: CURSOR cur_min_disb_date (cp_award_id NUMBER) IS
1774: SELECT MIN(disb_date)
1775: FROM IGF_AW_AWD_DISB
1776: WHERE award_id = cp_award_id;
1777:
1778: sch_disb_date DATE;
1779:

Line 1959: FROM igf_aw_awd_disb_all

1955: CURSOR c_get_disb_award_status (cp_award_id NUMBER,
1956: cp_ld_cal_type VARCHAR2,
1957: cp_ld_seq_num NUMBER) IS
1958: SELECT award_id, disb_num, trans_type, disb_accepted_amt
1959: FROM igf_aw_awd_disb_all
1960: WHERE award_id = cp_award_id
1961: AND ld_cal_type = cp_ld_cal_type
1962: AND ld_sequence_number = cp_ld_seq_num;
1963: