APPS.IGS_PS_US_REQ_REF_CD_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

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

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

Line 115: FROM igs_ge_ref_cd_type_all

111: */
112:
113: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
114: SELECT 'X'
115: FROM igs_ge_ref_cd_type_all
116: WHERE restricted_flag='Y'
117: AND reference_cd_type=cp_reference_cd_type;
118: l_var VARCHAR2(1);
119: