APPS.IGS_FI_GEN_005 dependencies on IGS_FI_FEE_TYPE

Line 101: IGS_FI_FEE_TYPE ft

97: ftci.fee_ci_sequence_number,
98: ft.s_fee_trigger_cat
99: FROM IGS_FI_F_TYP_CA_INST ftci,
100: IGS_FI_FEE_STR_STAT fss,
101: IGS_FI_FEE_TYPE ft
102: WHERE (p_fee_type IS NULL OR
103: ftci.FEE_TYPE = p_fee_type) AND
104: fss.FEE_STRUCTURE_STATUS = ftci.fee_type_ci_status AND
105: fss.s_fee_structure_status = cst_active AND

Line 317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

313: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
314: p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
315: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
316: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

Line 342: FROM IGS_FI_FEE_TYPE ft

338: DECLARE
339: CURSOR c_ft IS
340:
341: SELECT ft.s_fee_trigger_cat
342: FROM IGS_FI_FEE_TYPE ft
343: WHERE ft.FEE_TYPE = p_fee_type;
344:
345: CURSOR c_ctft IS
346:

Line 469: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

465: (susa.end_dt IS NULL OR
466: TRUNC(p_effective_dt) <= TRUNC(susa.end_dt)) AND
467: (susa.rqrmnts_complete_dt IS NULL OR
468: TRUNC(p_effective_dt) <= TRUNC(susa.rqrmnts_complete_dt));
469: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
470: v_check VARCHAR2(1);
471:
472: -- Cursor to find out if the Student has atleast one auditable unit
473: CURSOR c_sua_audit_one (cp_person_id NUMBER,

Line 860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

856: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
857: p_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
858: p_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
859: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

Line 901: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

897: errbuf out NOCOPY varchar2,
898: retcode out NOCOPY number,
899: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
900: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
901: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
902: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
903: p_grace_days IN NUMBER ,
904: p_effective_dt_c IN VARCHAR2 ,
905: p_notification_dt_c IN VARCHAR2 ,