DBA Data[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on IGF_AW_FUND_TP_ALL

Line 1703: CURSOR c_match_disb_term (p_cal_type igf_aw_fund_tp_all.tp_cal_type%TYPE,

1699: AND award_number_txt = li_awd_rec.award_number_txt;
1700:
1701: cur_legacy_disb_total_rec cur_legacy_disb_total%ROWTYPE;
1702:
1703: CURSOR c_match_disb_term (p_cal_type igf_aw_fund_tp_all.tp_cal_type%TYPE,
1704: p_sequence_number igf_aw_fund_tp_all.tp_sequence_number%TYPE) IS
1705: SELECT fund_id, tp_cal_type, tp_sequence_number
1706: FROM igf_aw_fund_tp_all
1707: WHERE fund_id = g_fund_id

Line 1704: p_sequence_number igf_aw_fund_tp_all.tp_sequence_number%TYPE) IS

1700:
1701: cur_legacy_disb_total_rec cur_legacy_disb_total%ROWTYPE;
1702:
1703: CURSOR c_match_disb_term (p_cal_type igf_aw_fund_tp_all.tp_cal_type%TYPE,
1704: p_sequence_number igf_aw_fund_tp_all.tp_sequence_number%TYPE) IS
1705: SELECT fund_id, tp_cal_type, tp_sequence_number
1706: FROM igf_aw_fund_tp_all
1707: WHERE fund_id = g_fund_id
1708: AND tp_cal_type = p_cal_type

Line 1706: FROM igf_aw_fund_tp_all

1702:
1703: CURSOR c_match_disb_term (p_cal_type igf_aw_fund_tp_all.tp_cal_type%TYPE,
1704: p_sequence_number igf_aw_fund_tp_all.tp_sequence_number%TYPE) IS
1705: SELECT fund_id, tp_cal_type, tp_sequence_number
1706: FROM igf_aw_fund_tp_all
1707: WHERE fund_id = g_fund_id
1708: AND tp_cal_type = p_cal_type
1709: AND tp_sequence_number = p_sequence_number;
1710: c_match_disb_term_rec c_match_disb_term%ROWTYPE;