APPS.IGF_GR_LI_IMPORT dependencies on IGF_AW_AWD_DISB

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 1300: FROM igf_aw_awd_disb adisb1, igf_aw_awd_disb adisb2

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
1302: AND adisb1.disb_num IN ( SELECT MAX(adisb11.disb_num)
1303: FROM igf_aw_awd_disb adisb11
1304: WHERE adisb11.award_id = adisb1.award_id

Line 1303: FROM igf_aw_awd_disb adisb11

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
1302: AND adisb1.disb_num IN ( SELECT MAX(adisb11.disb_num)
1303: FROM igf_aw_awd_disb adisb11
1304: WHERE adisb11.award_id = adisb1.award_id
1305: )
1306: AND adisb1.award_id = adisb2.award_id
1307: AND adisb2.disb_num IN ( SELECT MIN(adisb11.disb_num)

Line 1308: FROM igf_aw_awd_disb adisb11

1304: WHERE adisb11.award_id = adisb1.award_id
1305: )
1306: AND adisb1.award_id = adisb2.award_id
1307: AND adisb2.disb_num IN ( SELECT MIN(adisb11.disb_num)
1308: FROM igf_aw_awd_disb adisb11
1309: WHERE adisb11.award_id = adisb2.award_id
1310: );
1311:
1312: lc_pymt_prds_n_date c_pymt_prds_n_date%ROWTYPE;

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;