APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_CHECK_RATINGS

Line 404: From csc_prof_check_ratings

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

Line 410: FROM csc_prof_check_ratings

406: and check_rating_grade = thd_grade;
407:
408: CURSOR rating_crs IS
409: SELECT rating_code, check_rating_grade, color_code, range_low_value, range_high_value
410: FROM csc_prof_check_ratings
411: WHERE check_id = chk_id;
412:
413: BEGIN
414: COMMIT;

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

598: Range_High_Value := NULL;
599: END IF;
600: CLOSE val_csr3;
601:
602: SELECT COUNT(*) INTO v_count FROM csc_prof_check_ratings
603: WHERE check_id = chk_id;
604:
605: rating_tbl.delete;
606:

Line 2584: From csc_prof_check_ratings

2580: WHERE a.block_id = sel_blk_id;
2581:
2582: Cursor val_csr3 IS
2583: Select Range_Low_Value, Range_High_Value
2584: From csc_prof_check_ratings
2585: Where check_id = chk_id
2586: and check_rating_grade = thd_grade;
2587:
2588: CURSOR rating_crs IS

Line 2590: FROM csc_prof_check_ratings

2586: and check_rating_grade = thd_grade;
2587:
2588: CURSOR rating_crs IS
2589: SELECT rating_code, check_rating_grade, color_code, range_low_value, range_high_value
2590: FROM csc_prof_check_ratings
2591: WHERE check_id = chk_id;
2592:
2593: BEGIN
2594: COMMIT;

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

2781: Range_High_Value := NULL;
2782: END IF;
2783: CLOSE val_csr3;
2784:
2785: SELECT COUNT(*) INTO v_count FROM csc_prof_check_ratings
2786: WHERE check_id = chk_id;
2787:
2788: rating_tbl.delete;
2789:

Line 3711: From csc_prof_check_ratings

3707: v_format_date DATE;
3708:
3709: Cursor val_crs1 IS
3710: Select check_rating_grade,rating_code,color_code
3711: From csc_prof_check_ratings
3712: Where check_id = p_chk_id
3713: And ( nvl(Range_Low_Value,val) <= v_val AND
3714: nvl(Range_High_Value,val) >= v_val );
3715:

Line 3718: From csc_prof_check_ratings

3714: nvl(Range_High_Value,val) >= v_val );
3715:
3716: Cursor val_crs2 IS
3717: Select check_rating_grade,rating_code,color_code
3718: From csc_prof_check_ratings
3719: Where check_id = p_chk_id
3720: And ( nvl(Range_Low_Value,val) <= val AND
3721: nvl(Range_High_Value,val) >= val );
3722:

Line 3726: From csc_prof_check_ratings

3722:
3723: /* This Cursor added for BUG 1534103 - VIS115P: THRESHOLD FUNCTIONALITY IS NOT WORKING. */
3724: Cursor val_crs3 IS
3725: Select Range_Low_Value,Range_High_Value
3726: From csc_prof_check_ratings
3727: Where check_id = p_chk_id
3728: and check_rating_grade=p_thd_grade;
3729:
3730: /*