APPS.IGF_GR_LI_IMPORT dependencies on IGF_AW_AWD_DISB_ALL

Line 751: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE,

747:
748: FUNCTION create_pell_disb(
749: p_pell_disb_int c_pell_disb_int%ROWTYPE,
750: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE,
751: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE,
752: p_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE
753: ) RETURN BOOLEAN AS
754: /*
755: || Created By : brajendr

Line 752: p_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE

748: FUNCTION create_pell_disb(
749: p_pell_disb_int c_pell_disb_int%ROWTYPE,
750: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE,
751: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE,
752: p_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE
753: ) RETURN BOOLEAN AS
754: /*
755: || Created By : brajendr
756: || Created On : 19-Jun-2003

Line 845: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

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
849: WHERE disb.award_id = cp_award_id

Line 848: FROM igf_aw_awd_disb_all 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
849: WHERE disb.award_id = cp_award_id
850: AND disb.disb_num = cp_disb_num
851: AND disb.trans_type = 'A';
852:

Line 1468: FROM igf_aw_awd_disb_all ad

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
1470: AND NOT EXISTS ( SELECT pdisb.disb_ref_num
1471: FROM igf_gr_rfms_all porig, igf_gr_rfms_disb_all pdisb
1472: WHERE porig.origination_id = pdisb.origination_id

Line 1502: FROM igf_aw_awd_disb_all

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;
1505:
1506: rec_get_attendance_type_code cur_get_attendance_type_code%ROWTYPE;