APPS.IGF_GR_LI_IMPORT dependencies on IGF_AW_AWARD_ALL

Line 167: g_award_id igf_aw_award_all.award_id%TYPE;

163: AND i.system_record_type = 'ORIGINAL'
164: AND TO_NUMBER(i.transaction_num) = TO_NUMBER(cp_transaction_num);
165:
166: -- Declaration of global paramters
167: g_award_id igf_aw_award_all.award_id%TYPE;
168: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
169: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
170: g_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
171: g_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

Line 844: cp_award_id igf_aw_award_all.award_id%TYPE,

840: */
841:
842: -- Get the Award details for the Context pell
843: CURSOR c_awd_disb(
844: cp_award_id igf_aw_award_all.award_id%TYPE,
845: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
846: ) IS
847: SELECT disb.disb_date, disb.disb_gross_amt, disb.disb_net_amt
848: FROM igf_aw_awd_disb_all disb

Line 1297: cp_award_id igf_aw_award_all.award_id%TYPE

1293: || (reverse chronological order - newest change first)
1294: */
1295:
1296: CURSOR c_pymt_prds_n_date(
1297: cp_award_id igf_aw_award_all.award_id%TYPE
1298: ) IS
1299: SELECT adisb1.disb_num, adisb2.disb_date
1300: FROM igf_aw_awd_disb adisb1, igf_aw_awd_disb adisb2
1301: WHERE adisb1.award_id = cp_award_id

Line 1442: cp_award_number igf_aw_award_all.award_number_txt%TYPE

1438:
1439: -- Get the Award details for the refference award number if present
1440: CURSOR c_awd_details(
1441: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1442: cp_award_number igf_aw_award_all.award_number_txt%TYPE
1443: ) IS
1444: SELECT awd.award_id, awd.offered_amt, awd.accepted_amt, awd.fund_id
1445: FROM igf_aw_award_all awd
1446: WHERE awd.base_id = cp_base_id

Line 1445: FROM igf_aw_award_all awd

1441: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1442: cp_award_number igf_aw_award_all.award_number_txt%TYPE
1443: ) IS
1444: SELECT awd.award_id, awd.offered_amt, awd.accepted_amt, awd.fund_id
1445: FROM igf_aw_award_all awd
1446: WHERE awd.base_id = cp_base_id
1447: AND awd.award_number_txt IS NOT NULL
1448: AND awd.award_number_txt = cp_award_number
1449: AND awd.award_status <> 'SIMULATED';

Line 1456: cp_award_id igf_aw_award_all.award_id%TYPE

1452:
1453:
1454: -- Get the details of RFMS for the context award id
1455: CURSOR c_chk_rfms_awd(
1456: cp_award_id igf_aw_award_all.award_id%TYPE
1457: ) IS
1458: SELECT rfms.origination_id
1459: FROM igf_gr_rfms_all rfms
1460: WHERE rfms.award_id = cp_award_id;

Line 1465: cp_award_id igf_aw_award_all.award_id%TYPE

1461:
1462: lc_chk_rfms_awd c_chk_rfms_awd%ROWTYPE;
1463:
1464: CURSOR c_get_remain_disb(
1465: cp_award_id igf_aw_award_all.award_id%TYPE
1466: ) IS
1467: SELECT ad.disb_num, ad.disb_date, ad.disb_accepted_amt
1468: FROM igf_aw_awd_disb_all ad
1469: WHERE ad.award_id = cp_award_id

Line 1500: CURSOR cur_get_attendance_type_code(cp_award_id igf_aw_award_all.award_id%TYPE) IS

1496: l_temp_aid NUMBER;
1497: l_row_id ROWID;
1498:
1499: -- Get the Base attendance type code for context Award Id
1500: CURSOR cur_get_attendance_type_code(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1501: SELECT base_attendance_type_code
1502: FROM igf_aw_awd_disb_all
1503: WHERE award_id = cp_award_id
1504: GROUP BY base_attendance_type_code;