DBA Data[Home] [Help]

APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_REF_KEYWORDS

Line 2128: -- validate keyword value exists in IGS_UC_REF_KEYWORDS

2124: AND ucrdet.ucas_campus = p_campus
2125: AND ucrdet.system_code = p_system;
2126:
2127:
2128: -- validate keyword value exists in IGS_UC_REF_KEYWORDS
2129: CURSOR validate_keyword_cur (p_keyword igs_uc_ucrskwd_ints.keyword%TYPE) IS
2130: SELECT rowid
2131: FROM igs_uc_ref_keywords
2132: WHERE keyword = p_keyword;

Line 2131: FROM igs_uc_ref_keywords

2127:
2128: -- validate keyword value exists in IGS_UC_REF_KEYWORDS
2129: CURSOR validate_keyword_cur (p_keyword igs_uc_ucrskwd_ints.keyword%TYPE) IS
2130: SELECT rowid
2131: FROM igs_uc_ref_keywords
2132: WHERE keyword = p_keyword;
2133:
2134:
2135: old_crsekwd_rec old_crskwd_cur%ROWTYPE;