[Home] [Help]
79: -- Cursor to get the enroll_deposit_amount for the application type
80: CURSOR c_en_deposit_amt IS
81: SELECT sat.enroll_deposit_amount enroll_deposit_amount
82: FROM igs_ad_ss_appl_typ sat,
83: igs_ad_appl aa
84: WHERE aa.person_id = p_person_id
85: AND aa.admission_appl_number = p_admission_appl_number
86: AND sat.admission_application_type = aa.application_type;
87: