APPS.IGS_EN_VAL_GATC dependencies on IGS_PE_ABORG_TORESCD

Line 13: v_aborig_torres_cd IGS_PE_ABORG_TORESCD%ROWTYPE;

9: RETURN BOOLEAN AS
10: BEGIN
11: DECLARE
12:
13: v_aborig_torres_cd IGS_PE_ABORG_TORESCD%ROWTYPE;
14: CURSOR c_aborig_torres_cd IS
15: SELECT *
16: FROM IGS_PE_ABORG_TORESCD
17: WHERE govt_aborig_torres_cd = p_govt_aborig_torres_cd and

Line 16: FROM IGS_PE_ABORG_TORESCD

12:
13: v_aborig_torres_cd IGS_PE_ABORG_TORESCD%ROWTYPE;
14: CURSOR c_aborig_torres_cd IS
15: SELECT *
16: FROM IGS_PE_ABORG_TORESCD
17: WHERE govt_aborig_torres_cd = p_govt_aborig_torres_cd and
18: closed_ind = 'N';
19: BEGIN
20: -- Validate the update on a govt_aborig_torres_cd record.

Line 25: -- check if open IGS_PE_ABORG_TORESCD records exist

21: -- A IGS_PE_GOV_ABRGRESCD record cannot be closed if
22: -- there are IGS_PE_LANGUAGE_CD records mapped to it that
23: -- are still open
24: IF (p_closed_ind = 'Y') THEN
25: -- check if open IGS_PE_ABORG_TORESCD records exist
26: OPEN c_aborig_torres_cd;
27: FETCH c_aborig_torres_cd INTO v_aborig_torres_cd;
28: IF (c_aborig_torres_cd%FOUND) THEN
29: CLOSE c_aborig_torres_cd;