APPS.HR_NAV_UNIT_GLOBAL_USAGES_PKG dependencies on HR_NAVIGATION_UNITS

Line 24: p_ref_entity => 'HR_NAVIGATION_UNITS',

20:
21: BEGIN
22: PER_RIC_PKG.chk_integrity (
23: p_entity_name => 'HR_NAV_UNIT_GLOBAL_USAGES',
24: p_ref_entity => 'HR_NAVIGATION_UNITS',
25: p_ref_column_name => 'NAV_UNIT_ID',
26: p_ref_col_value_number => X_NAV_UNIT_ID,
27: p_ref_col_value_varchar => NULL,
28: p_ref_col_value_date => NULL,

Line 159: from HR_NAVIGATION_UNITS

155:
156: if X_FORM_NAME is not null then
157: select NAV_UNIT_ID
158: into X_NAV_UNIT_ID
159: from HR_NAVIGATION_UNITS
160: where FORM_NAME = X_FORM_NAME
161: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);
162: end if;
163: