APPS.IGS_EN_VAL_CIC dependencies on IGS_PE_GOVCITIZEN_CD

Line 14: gv_closed_ind IGS_PE_GOVCITIZEN_CD.closed_ind%TYPE;

10: RETURN BOOLEAN AS
11: BEGIN
12: DECLARE
13: gv_other_detail VARCHAR(255);
14: gv_closed_ind IGS_PE_GOVCITIZEN_CD.closed_ind%TYPE;
15: CURSOR gc_govt_ctznshp_cd(
16: cp_govt_ctznshp_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE) IS
17: SELECT IGS_PE_GOVCITIZEN_CD.closed_ind
18: FROM IGS_PE_GOVCITIZEN_CD

Line 17: SELECT IGS_PE_GOVCITIZEN_CD.closed_ind

13: gv_other_detail VARCHAR(255);
14: gv_closed_ind IGS_PE_GOVCITIZEN_CD.closed_ind%TYPE;
15: CURSOR gc_govt_ctznshp_cd(
16: cp_govt_ctznshp_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE) IS
17: SELECT IGS_PE_GOVCITIZEN_CD.closed_ind
18: FROM IGS_PE_GOVCITIZEN_CD
19: WHERE IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd =
20: cp_govt_ctznshp_cd;
21: BEGIN

Line 18: FROM IGS_PE_GOVCITIZEN_CD

14: gv_closed_ind IGS_PE_GOVCITIZEN_CD.closed_ind%TYPE;
15: CURSOR gc_govt_ctznshp_cd(
16: cp_govt_ctznshp_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE) IS
17: SELECT IGS_PE_GOVCITIZEN_CD.closed_ind
18: FROM IGS_PE_GOVCITIZEN_CD
19: WHERE IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd =
20: cp_govt_ctznshp_cd;
21: BEGIN
22: -- This module validates if IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd

Line 19: WHERE IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd =

15: CURSOR gc_govt_ctznshp_cd(
16: cp_govt_ctznshp_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE) IS
17: SELECT IGS_PE_GOVCITIZEN_CD.closed_ind
18: FROM IGS_PE_GOVCITIZEN_CD
19: WHERE IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd =
20: cp_govt_ctznshp_cd;
21: BEGIN
22: -- This module validates if IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd
23: -- is closed

Line 22: -- This module validates if IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd

18: FROM IGS_PE_GOVCITIZEN_CD
19: WHERE IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd =
20: cp_govt_ctznshp_cd;
21: BEGIN
22: -- This module validates if IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd
23: -- is closed
24: p_message_name := null;
25: OPEN gc_govt_ctznshp_cd(
26: p_govt_citizenship_cd);