DBA Data[Home] [Help]

APPS.IGC_CBC_PA_BC_PKG dependencies on IGC_CC_RESULT_CODE_RANKS

Line 598: FROM igc_cc_result_code_ranks

594:
595: FOR l_result_code IN c_result_code LOOP
596:
597: SELECT distinct severity_rank INTO l_sev_rank
598: FROM igc_cc_result_code_ranks
599: WHERE funds_checker_code = l_result_code.cbc_result_code;
600:
601: IF (l_min_sev_rank > l_sev_rank) THEN
602: l_min_sev_rank := l_sev_rank;

Line 612: FROM igc_cc_result_code_ranks

608: Put_Debug_Msg(l_full_path, 'Minimum Severity Rank: ' || l_min_sev_rank);
609: END IF;
610:
611: SELECT distinct popup_messg_code INTO l_h_code
612: FROM igc_cc_result_code_ranks
613: WHERE severity_rank = l_min_sev_rank
614: AND action = decode(p_mode,'F','R',p_mode);
615:
616: IF ( g_unexp_level >= g_debug_level ) THEN