APPS.IGS_PS_USEC_OCUR_REF_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

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

108: smvk 31-Jan-2003 Bug # 2532094. Added the foreign key checking with igs_ge_ref_cd.
109: (reverse chronological order - newest change first)
110: ***************************************************************/
111:
112: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
113: SELECT 'X'
114: FROM igs_ge_ref_cd_type_all
115: WHERE restricted_flag='Y'
116: AND reference_cd_type=cp_reference_cd_type;

Line 114: FROM igs_ge_ref_cd_type_all

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