APPS.IGS_EN_VAL_GCC dependencies on IGS_ST_CITIZENSHP_CD

Line 13: v_citizenship_cd IGS_ST_CITIZENSHP_CD%ROWTYPE;

9: RETURN BOOLEAN AS
10: BEGIN
11: DECLARE
12:
13: v_citizenship_cd IGS_ST_CITIZENSHP_CD%ROWTYPE;
14: CURSOR c_citizenship_cd IS
15: SELECT *
16: FROM IGS_ST_CITIZENSHP_CD
17: WHERE govt_citizenship_cd = p_govt_citizenship_cd and

Line 16: FROM IGS_ST_CITIZENSHP_CD

12:
13: v_citizenship_cd IGS_ST_CITIZENSHP_CD%ROWTYPE;
14: CURSOR c_citizenship_cd IS
15: SELECT *
16: FROM IGS_ST_CITIZENSHP_CD
17: WHERE govt_citizenship_cd = p_govt_citizenship_cd and
18: closed_ind = 'N';
19: BEGIN
20: -- Validate the update on a govt_citizenshhip_record.

Line 22: -- there are IGS_ST_CITIZENSHP_CD records mapped to it that

18: closed_ind = 'N';
19: BEGIN
20: -- Validate the update on a govt_citizenshhip_record.
21: -- A IGS_PE_GOVCITIZEN_CD record cannot be closed if
22: -- there are IGS_ST_CITIZENSHP_CD records mapped to it that
23: -- are still open
24: IF (p_closed_ind = 'Y') THEN
25: -- check if open IGS_ST_CITIZENSHP_CD records exist
26: OPEN c_citizenship_cd;

Line 25: -- check if open IGS_ST_CITIZENSHP_CD records exist

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