APPS.HR_PAE_BUS dependencies on HR_LOOKUPS

Line 68: -- HR_LOOKUPS where lookup type = 'EXCEPTION_CATEGORY'

64: --
65: -- PUBLIC
66: -- Description:
67: -- Ensure that the exception category is valid, must exist in
68: -- HR_LOOKUPS where lookup type = 'EXCEPTION_CATEGORY'
69: --
70: Procedure Check_Exception_Category ( p_exception_category in varchar2) is
71: --
72: l_proc varchar2(72) := g_package||'Check_Exception_Category';

Line 76: from hr_lookups h

72: l_proc varchar2(72) := g_package||'Check_Exception_Category';
73:
74: cursor c1 is
75: select h.rowid
76: from hr_lookups h
77: where h.lookup_type = 'EXCEPTION_CATEGORY'
78: and h.lookup_code = p_exception_category;
79:
80: c1_rec c1%ROWTYPE;