APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_CHECK_RATINGS

Line 403: From csc_prof_check_ratings

399:
400: Cursor val_csr3 IS
401: Select Range_Low_Value,
402: Range_High_Value
403: From csc_prof_check_ratings
404: Where check_id = chk_id
405: and check_rating_grade = thd_grade;
406:
407: CURSOR rating_crs IS

Line 413: FROM csc_prof_check_ratings

409: check_rating_grade,
410: color_code,
411: range_low_value,
412: range_high_value
413: FROM csc_prof_check_ratings
414: WHERE check_id = chk_id;
415:
416: BEGIN
417: COMMIT;

Line 704: SELECT COUNT(*) INTO v_count FROM csc_prof_check_ratings

700: Range_High_Value := NULL;
701: END IF;
702: CLOSE val_csr3;
703:
704: SELECT COUNT(*) INTO v_count FROM csc_prof_check_ratings
705: WHERE check_id = chk_id;
706:
707: rating_tbl.delete;
708:

Line 3656: From csc_prof_check_ratings

3652:
3653: Cursor val_csr3 IS
3654: Select Range_Low_Value,
3655: Range_High_Value
3656: From csc_prof_check_ratings
3657: Where check_id = chk_id
3658: and check_rating_grade = thd_grade;
3659:
3660: CURSOR rating_crs IS

Line 3666: FROM csc_prof_check_ratings

3662: check_rating_grade,
3663: color_code,
3664: range_low_value,
3665: range_high_value
3666: FROM csc_prof_check_ratings
3667: WHERE check_id = chk_id;
3668:
3669: BEGIN
3670: COMMIT;

Line 3913: SELECT COUNT(*) INTO v_count FROM csc_prof_check_ratings

3909: Range_High_Value := NULL;
3910: END IF;
3911: CLOSE val_csr3;
3912:
3913: SELECT COUNT(*) INTO v_count FROM csc_prof_check_ratings
3914: WHERE check_id = chk_id;
3915: rating_tbl.delete;
3916: IF v_count > 0 THEN
3917: OPEN rating_crs;

Line 5198: From csc_prof_check_ratings

5194: Cursor val_crs1 IS
5195: Select check_rating_grade,
5196: rating_code,
5197: color_code
5198: From csc_prof_check_ratings
5199: Where check_id = p_chk_id
5200: And ( nvl(Range_Low_Value,val) <= v_val AND
5201: nvl(Range_High_Value,val) >= v_val );
5202:

Line 5207: From csc_prof_check_ratings

5203: Cursor val_crs2 IS
5204: Select check_rating_grade,
5205: rating_code,
5206: color_code
5207: From csc_prof_check_ratings
5208: Where check_id = p_chk_id
5209: And ( nvl(Range_Low_Value,val) <= val AND
5210: nvl(Range_High_Value,val) >= val );
5211:

Line 5216: From csc_prof_check_ratings

5212: /* This Cursor added for BUG 1534103 - VIS115P: THRESHOLD FUNCTIONALITY IS NOT WORKING. */
5213: Cursor val_crs3 IS
5214: Select Range_Low_Value,
5215: Range_High_Value
5216: From csc_prof_check_ratings
5217: Where check_id = p_chk_id
5218: and check_rating_grade=p_thd_grade;
5219:
5220: /*