[Home] [Help]
31: Modified the reference of payment_isir_id
32: */
33: ----------------------------------------------------------------------------------
34: -- veramach July 2004 FA 151 HR Integration (bug#3709292)
35: -- Impacts of obsoleting columns from igf_aw_awd_disb_all
36: ---------------------------------------------------------------------------------
37: -- veramach 04-May-2004 bug 3603289
38: -- Modified cursor cur_student_licence to select
39: -- dependency_status from ISIR. other details are
45: ----------------------------------------------------------------------------------
46: -- veramach 11-Dec-2003 Bug # 3184891 Removed calls to igf_ap_gen.write_log
47: -- and added common logging
48: ----------------------------------------------------------------------------------
49: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
50: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE
51: ----------------------------------------------------------------------------------
52: -- ugummall 04-NOV-2003 Bug 3102439. FA 126 - Multiple FA Offices.
53: -- Renamed cursor c_ope_id to c_source_or_branch_id with one extra
2946: CURSOR c_gross_amt(cp_award_id NUMBER,
2947: cp_disb_num NUMBER)
2948: IS
2949: SELECT disb_accepted_amt disb_gross_amt
2950: FROM igf_aw_awd_disb_all
2951: WHERE award_id = cp_award_id
2952: AND disb_num = cp_disb_num;
2953:
2954: l_gross_amt c_gross_amt%ROWTYPE;
3683: SELECT
3684: ROWID,
3685: adisb.*
3686: FROM
3687: igf_aw_awd_disb_all adisb
3688: WHERE
3689: adisb.award_id = p_award_id AND
3690: adisb.disb_num = cp_disb_num;
3691:
5166: CURSOR c_disb_det(cp_award_id NUMBER,
5167: cp_disb_num NUMBER)
5168: IS
5169: SELECT 1
5170: FROM igf_aw_awd_disb_all adisb
5171: WHERE adisb.award_id = cp_award_id
5172: AND adisb.disb_num = cp_disb_num;
5173:
5174: l_disb_det c_disb_det%ROWTYPE;