APPS.IGS_EN_VAL_CIC dependencies on IGS_ST_CITIZENSHP_CD

Line 16: cp_govt_ctznshp_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE) IS

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
19: WHERE IGS_PE_GOVCITIZEN_CD.govt_citizenship_cd =
20: cp_govt_ctznshp_cd;