APPS.IGS_EN_VAL_HPO dependencies on IGS_FI_GOV_HEC_PA_OP

Line 12: v_ghpo_ind IGS_FI_GOV_HEC_PA_OP.closed_ind%TYPE;

8: RETURN BOOLEAN AS
9: BEGIN
10: DECLARE
11:
12: v_ghpo_ind IGS_FI_GOV_HEC_PA_OP.closed_ind%TYPE;
13: CURSOR c_ghpo_ind IS
14: SELECT closed_ind
15: FROM IGS_FI_GOV_HEC_PA_OP
16: WHERE govt_hecs_payment_option = p_govt_hecs_payment_option;

Line 15: FROM IGS_FI_GOV_HEC_PA_OP

11:
12: v_ghpo_ind IGS_FI_GOV_HEC_PA_OP.closed_ind%TYPE;
13: CURSOR c_ghpo_ind IS
14: SELECT closed_ind
15: FROM IGS_FI_GOV_HEC_PA_OP
16: WHERE govt_hecs_payment_option = p_govt_hecs_payment_option;
17: BEGIN
18: -- This module validates whether a IGS_FI_HECS_PAY_OPTN
19: -- record could be mapped to a IGS_FI_GOV_HEC_PA_OP

Line 19: -- record could be mapped to a IGS_FI_GOV_HEC_PA_OP

15: FROM IGS_FI_GOV_HEC_PA_OP
16: WHERE govt_hecs_payment_option = p_govt_hecs_payment_option;
17: BEGIN
18: -- This module validates whether a IGS_FI_HECS_PAY_OPTN
19: -- record could be mapped to a IGS_FI_GOV_HEC_PA_OP
20: -- record
21: OPEN c_ghpo_ind;
22: FETCH c_ghpo_ind INTO v_ghpo_ind;
23: -- if a record doesn't exist, then it could