APPS.CSC_PROF_COLOR_CODE_PVT dependencies on CSC_LOOKUPS

Line 581: from csc_lookups

577: l_dummy varchar2(1);
578: p_Api_Name varchar2(30) := 'Validate_Rating_Code';
579: cursor c is
580: select null
581: from csc_lookups
582: where lookup_type = 'CSC_PROF_RATINGS'
583: and lookup_code = p_rating_code
584: and enabled_flag = 'Y'
585: and trunc(sysdate) between trunc(nvl(start_date_Active,sysdate))

Line 616: -- Check whethere code is defined in CSC_LOOKUPS

612: -- IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
613: --THEN
614: -- Hint: Validate data
615: IF p_RATING_CODE is not NULL and p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
616: -- Check whethere code is defined in CSC_LOOKUPS
617: -- for CSC_PROF_RATINGS
618: l_lookup_code := p_rating_code;
619: open c;
620: fetch c into l_dummy;