APPS.IGS_ST_GEN_004 dependencies on IGS_ST_CITIZENSHP_CD

Line 880: FROM IGS_ST_CITIZENSHP_CD ccd

876: ps.end_dt >= p_effective_dt)
877: ORDER BY ps.end_dt ASC;
878: CURSOR c_citz IS
879: SELECT ccd.govt_citizenship_cd
880: FROM IGS_ST_CITIZENSHP_CD ccd
881: WHERE ccd.citizenship_cd = p_citizenship_cd;
882: CURSOR c_perm_res (
883: cp_perm_res_cd IGS_PE_PERM_RES_CD.perm_resident_cd%TYPE) IS
884: SELECT prcd.govt_perm_resident_cd