APPS.IGS_EN_VAL_GHPO dependencies on IGS_FI_HECS_PAY_OPTN

Line 13: v_hpo_rec IGS_FI_HECS_PAY_OPTN%ROWTYPE;

9: RETURN BOOLEAN AS
10: BEGIN
11: DECLARE
12:
13: v_hpo_rec IGS_FI_HECS_PAY_OPTN%ROWTYPE;
14: CURSOR c_hpo_rec IS
15: SELECT *
16: FROM IGS_FI_HECS_PAY_OPTN
17: WHERE govt_hecs_payment_option = p_govt_hecs_payment_option AND

Line 16: FROM IGS_FI_HECS_PAY_OPTN

12:
13: v_hpo_rec IGS_FI_HECS_PAY_OPTN%ROWTYPE;
14: CURSOR c_hpo_rec IS
15: SELECT *
16: FROM IGS_FI_HECS_PAY_OPTN
17: WHERE govt_hecs_payment_option = p_govt_hecs_payment_option AND
18: closed_ind = 'N';
19: BEGIN
20: -- This module validates that there are no

Line 21: -- IGS_FI_HECS_PAY_OPTN records open when

17: WHERE govt_hecs_payment_option = p_govt_hecs_payment_option AND
18: closed_ind = 'N';
19: BEGIN
20: -- This module validates that there are no
21: -- IGS_FI_HECS_PAY_OPTN records open when
22: -- closing a IGS_FI_GOV_HEC_PA_OP record
23: IF (p_closed_ind = 'Y') THEN
24: OPEN c_hpo_rec;
25: FETCH c_hpo_rec INTO v_hpo_rec;

Line 27: -- if there are IGS_FI_HECS_PAY_OPTN records

23: IF (p_closed_ind = 'Y') THEN
24: OPEN c_hpo_rec;
25: FETCH c_hpo_rec INTO v_hpo_rec;
26: IF (c_hpo_rec%FOUND) THEN
27: -- if there are IGS_FI_HECS_PAY_OPTN records
28: -- that have been found and which aren't yet
29: -- closed (ie. closed_ind = 'N')
30: CLOSE c_hpo_rec;
31: p_message_name := 'IGS_EN_CANT_CLOS_GOVT_HECS';