APPS.HRWSCAL_PKG dependencies on HR_PATTERN_EXCEPTIONS

Line 53: lv_exception_name hr_pattern_exceptions.exception_name%type;

49: p_NEW_EXCEPTION_INDICTOR out varchar2,
50: p_EXCEPTION_CATEGORY_MEANING out varchar2
51: ) is
52: --
53: lv_exception_name hr_pattern_exceptions.exception_name%type;
54: cursor pattern_exception_cursor is
55: select EXCEPTION_ID,
56: PATTERN_ID,
57: EXCEPTION_CATEGORY,

Line 62: from hr_pattern_exceptions_v

58: EXCEPTION_START_TIME,
59: EXCEPTION_END_TIME,
60: PATTERN_NAME,
61: EXCEPTION_CATEGORY_MEANING
62: from hr_pattern_exceptions_v
63: where upper(exception_name) = upper(p_exception_name);
64:
65:
66: BEGIN