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_EN_VAL_SCHO dependencies on IGS_FI_GOV_HEC_PA_OP

Line 785: IGS_FI_GOV_HEC_PA_OP ghpo

781: DECLARE
782: CURSOR c_ghpo_details IS
783: SELECT ghpo.s_hecs_payment_type
784: FROM IGS_FI_HECS_PAY_OPTN hpo,
785: IGS_FI_GOV_HEC_PA_OP ghpo
786: WHERE hpo.hecs_payment_option = p_hecs_payment_option AND
787: ghpo.govt_hecs_payment_option = hpo.govt_hecs_payment_option;
788: v_ghpo_rec c_ghpo_details%ROWTYPE;
789: BEGIN

Line 1143: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12

1139: DECLARE
1140: v_other_detail VARCHAR2(255);
1141: BEGIN
1142: -- this module performs the validation that is
1143: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12
1144: -- then the govt. value for the IGS_ST_CITIZENSHP_CD must be
1145: -- 3 and the govt. value for the IGS_PE_PERM_RES_CD must
1146: -- be 2
1147: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12

Line 1147: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12

1143: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12
1144: -- then the govt. value for the IGS_ST_CITIZENSHP_CD must be
1145: -- 3 and the govt. value for the IGS_PE_PERM_RES_CD must
1146: -- be 2
1147: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12
1148: IF p_govt_hecs_payment_option = cst_hecs_upfront AND
1149: -- checking if the indicator is set
1150: p_outside_aus_res_ind = 'Y' THEN
1151: -- checking if the IGS_PE_GOVCITIZEN_CD = '3'

Line 1911: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12

1907: DECLARE
1908: v_test_year NUMBER(6);
1909: BEGIN
1910: -- this module performs the validation that is
1911: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12
1912: -- and if a New Zealand indicator is set, then the
1913: -- government value must be '2'
1914: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12
1915: IF p_govt_hecs_payment_option = cst_hecs_upfront AND

Line 1914: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12

1910: -- this module performs the validation that is
1911: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12
1912: -- and if a New Zealand indicator is set, then the
1913: -- government value must be '2'
1914: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12
1915: IF p_govt_hecs_payment_option = cst_hecs_upfront AND
1916: -- checking if any New Zealand indicators are set
1917: (p_nz_citizen_ind = 'Y' OR
1918: p_nz_citizen_less2yr_ind = 'Y' OR

Line 2216: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 10 or 11

2212: -- 11, 19, 20, 25, 26, 27, 32, or 40, then the govt. value for
2213: -- the IGS_ST_CITIZENSHP_CD must be 1, 2, or 3, and if it is
2214: -- 3, then the govt. value for the IGS_PE_PERM_RES_CD must
2215: -- be 1 or 3
2216: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 10 or 11
2217: -- DETYA validation 1772. Allow for values being NULL
2218: IF p_govt_perm_resident_cd IN (
2219: cst_perm_out_aust_not_crs,
2220: cst_perm) AND

Line 2227: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 10, 11, 19, 20, 25, 26,

2223: p_message_name := 'IGS_EN_PERM_RES_STAT_VAL_2_3';
2224: p_return_type := cst_error;
2225: RETURN FALSE;
2226: END IF;
2227: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 10, 11, 19, 20, 25, 26,
2228: -- 27, 32 or 40
2229: -- DETYA validation 1774. Allow for values being NULL
2230: IF (p_govt_hecs_payment_option IS NOT NULL AND
2231: p_govt_hecs_payment_option NOT IN (