APPS.IGS_PS_UNIT_REF_CD_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

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

237: smvk 31-Jan-2003 Bug # 2532094. Added the foreign key checking with igs_ge_ref_cd.
238: (reverse chronological order - newest change first)
239: ***************************************************************/
240:
241: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
242: SELECT 'X'
243: FROM igs_ge_ref_cd_type_all
244: WHERE restricted_flag='Y'
245: AND reference_cd_type=cp_reference_cd_type;

Line 243: FROM igs_ge_ref_cd_type_all

239: ***************************************************************/
240:
241: CURSOR cur_reference_cd_chk(cp_reference_cd_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
242: SELECT 'X'
243: FROM igs_ge_ref_cd_type_all
244: WHERE restricted_flag='Y'
245: AND reference_cd_type=cp_reference_cd_type;
246: l_var VARCHAR2(1);
247: