APPS.IGS_EN_VAL_GPRC dependencies on IGS_PE_PERM_RES_CD

Line 13: v_perm_resident_cd IGS_PE_PERM_RES_CD%ROWTYPE;

9: RETURN BOOLEAN AS
10: BEGIN
11: DECLARE
12:
13: v_perm_resident_cd IGS_PE_PERM_RES_CD%ROWTYPE;
14: CURSOR c_perm_resident_cd IS
15: SELECT *
16: FROM IGS_PE_PERM_RES_CD
17: WHERE govt_perm_resident_cd = p_govt_perm_resident_cd and

Line 16: FROM IGS_PE_PERM_RES_CD

12:
13: v_perm_resident_cd IGS_PE_PERM_RES_CD%ROWTYPE;
14: CURSOR c_perm_resident_cd IS
15: SELECT *
16: FROM IGS_PE_PERM_RES_CD
17: WHERE govt_perm_resident_cd = p_govt_perm_resident_cd and
18: closed_ind = 'N';
19: BEGIN
20: -- Validate the update on a IGS_PE_GOV_PER_RESCD record.

Line 25: -- check if open IGS_PE_PERM_RES_CD records exist

21: -- A IGS_PE_GOV_PER_RESCD 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_PERM_RES_CD records exist
26: OPEN c_perm_resident_cd;
27: FETCH c_perm_resident_cd INTO v_perm_resident_cd;
28: IF (c_perm_resident_cd%FOUND) THEN
29: CLOSE c_perm_resident_cd;