APPS.IGS_PS_UNITREQREF_CD_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

Line 115: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS

111: || Change History :
112: || Who When What
113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
116: SELECT 'X'
117: FROM igs_ge_ref_cd_type_all
118: WHERE restricted_flag='Y'
119: AND reference_cd_type=cp_reference_cd_type;

Line 117: FROM igs_ge_ref_cd_type_all

113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
116: SELECT 'X'
117: FROM igs_ge_ref_cd_type_all
118: WHERE restricted_flag='Y'
119: AND reference_cd_type=cp_reference_cd_type;
120: l_var VARCHAR2(1);
121: BEGIN