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_GOV_HEC_PA_OP

Line 157: cp_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE) IS

153: -- their assessed liability and any up front payment made.
154: DECLARE
155: CURSOR c_hpo (
156: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE,
157: cp_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE) IS
158: SELECT HECS_PAYMENT_OPTION
159: FROM IGS_FI_HECS_PAY_OPTN hpo,
160: IGS_FI_GOV_HEC_PA_OP ghpo
161: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND

Line 160: IGS_FI_GOV_HEC_PA_OP ghpo

156: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE,
157: cp_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE) IS
158: SELECT HECS_PAYMENT_OPTION
159: FROM IGS_FI_HECS_PAY_OPTN hpo,
160: IGS_FI_GOV_HEC_PA_OP ghpo
161: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND
162: hpo.closed_ind = 'N' AND
163: hpo.GOVT_HECS_PAYMENT_OPTION = ghpo.GOVT_HECS_PAYMENT_OPTION AND
164: ghpo.s_hecs_payment_type = cp_hecs_payment_type;

Line 169: IGS_FI_GOV_HEC_PA_OP ghpo

165: CURSOR c_ghpo(
166: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE) IS
167: SELECT ghpo.s_hecs_payment_type
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