eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_GEN_006 dependencies on IGS_FI_FEE_AS

Line 128: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.

124: || Change History :
125: || Who When What
126: || (reverse chronological order - newest change first)
127: uudayapr 12-12-2003 bug#3080983 made the modification to Cursor c_fadv to point to the table
128: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
129: || vvutukur 19-Dec-2002 Bug#2680885.Commented out cursor c_fpv which selects from igs_fi_fee_pay_v, which
130: || is to be dropped.Instead, cursor c_fpv is redefined selecting 0 from dual. This
131: || function will be obsoleted as part of HECS functionality obsoletion. As this got
132: || deferred for Jan'03 scope,commented out this portion.

Line 172: -- Modified the Cursor c_fadv to fetch the Data from the table IGS_FI_FEE_AS

168: FROM IGS_FI_HECS_PAY_OPTN hpo,
169: IGS_FI_GOV_HEC_PA_OP ghpo
170: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND
171: hpo.GOVT_HECS_PAYMENT_OPTION = ghpo.GOVT_HECS_PAYMENT_OPTION;
172: -- Modified the Cursor c_fadv to fetch the Data from the table IGS_FI_FEE_AS
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,

Line 173: -- Instead of the the View IGS_FI_FEE_ASS_DEBT_V

169: IGS_FI_GOV_HEC_PA_OP ghpo
170: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND
171: hpo.GOVT_HECS_PAYMENT_OPTION = ghpo.GOVT_HECS_PAYMENT_OPTION;
172: -- Modified the Cursor c_fadv to fetch the Data from the table IGS_FI_FEE_AS
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

Line 176: FROM IGS_FI_FEE_AS fadv,

172: -- Modified the Cursor c_fadv to fetch the Data from the table IGS_FI_FEE_AS
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