APPS.HR_NAVIGATION_NODES_PKG dependencies on HR_NAVIGATION_UNITS

Line 24: p_ref_entity => 'HR_NAVIGATION_UNITS',

20: BEGIN
21:
22: PER_RIC_PKG.chk_integrity (
23: p_entity_name => 'HR_NAVIGATION_NODES',
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 164: from HR_NAVIGATION_UNITS

160:
161: if X_NAV_FORM_NAME is not null then
162: select NAV_UNIT_ID
163: into X_NAV_UNIT_ID
164: from HR_NAVIGATION_UNITS
165: where FORM_NAME = X_NAV_FORM_NAME
166: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);
167: else
168: X_NAV_UNIT_ID := null;