DBA Data[Home] [Help]

APPS.IGS_ST_GEN_003 dependencies on IGS_FI_FEE_TYPE

Line 236: cst_tuition CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';

232: cst_no CONSTANT VARCHAR2(1) := 'N';
233: cst_warning CONSTANT VARCHAR2(1) := 'W';
234: cst_govt_report CONSTANT IGS_PS_UNIT_CATEGORY.unit_cat%TYPE := 'GOVT-RPT';
235: cst_govt_noreport CONSTANT IGS_PS_UNIT_CATEGORY.unit_cat%TYPE := 'GOVT-NORPT';
236: cst_tuition CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
237: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
238: 'ENROLLED';
239: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
240: 'DISCONTIN';

Line 306: FROM IGS_FI_FEE_TYPE ft

302: scho.hecs_payment_option = hpo.hecs_payment_option(+)
303: ORDER BY scho.end_dt;
304: CURSOR c_ft IS
305: SELECT ft.fee_type
306: FROM IGS_FI_FEE_TYPE ft
307: WHERE ft.s_fee_type = cst_tuition;
308: CURSOR c_sua IS
309: SELECT sua.unit_attempt_status
310: FROM IGS_EN_SU_ATTEMPT sua