APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_AWD_DISB_ALL

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