APPS.IGS_FI_GEN_006 dependencies on IGS_FI_FEE_TYPE

Line 26: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

22: retcode out NOCOPY number,
23: p_correspondence_type IN VARCHAR2 ,
24: P_FIN_PERD IN VARCHAR2,
25: P_FEE_PERD IN VARCHAR2,
26: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
27: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
28: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
29: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
30: p_person_group_id IN NUMBER ,

Line 70: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

66: errbuf out NOCOPY varchar2,
67: retcode out NOCOPY number,
68: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
69: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
70: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
71: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
72: p_notification_dt_c IN VARCHAR2,
73: p_num_days_to_notification NUMBER ,
74: p_next_bus_day_ind IN VARCHAR,

Line 177: IGS_FI_FEE_TYPE ft

173: -- Instead of the the View IGS_FI_FEE_ASS_DEBT_V
174: CURSOR c_fadv IS
175: SELECT SUM(fadv.transaction_amount)
176: FROM IGS_FI_FEE_AS fadv,
177: IGS_FI_FEE_TYPE ft
178: WHERE fadv.person_id = p_person_id
179: AND fadv.fee_cal_type = p_fee_cal_type
180: AND fadv.fee_ci_sequence_number = p_fee_ci_sequence_number
181: AND ((fadv.FEE_CAT = p_fee_cat) OR (fadv.FEE_CAT IS NULL AND p_fee_cat IS NULL))

Line 196: IGS_FI_FEE_TYPE ft

192:
193: /* CURSOR c_fpv IS
194: SELECT SUM(fpv.payment_amount)
195: FROM IGS_FI_FEE_PAY_V fpv,
196: IGS_FI_FEE_TYPE ft
197: WHERE fpv.person_id = p_person_id AND
198: fpv.fee_cal_type = p_fee_cal_type AND
199: fpv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
200: fpv.FEE_CAT = p_fee_cat AND