DBA Data[Home] [Help]

APPS.HR_NAV_CONTEXT_RULES_PKG dependencies on HR_NAV_UNIT_GLOBAL_USAGES

Line 23: p_ref_entity => 'HR_NAV_UNIT_GLOBAL_USAGES',

19:
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_CONTEXT_RULES',
23: p_ref_entity => 'HR_NAV_UNIT_GLOBAL_USAGES',
24: p_ref_column_name => 'GLOBAL_USAGE_ID',
25: p_ref_col_value_number => X_GLOBAL_USAGE_ID,
26: p_ref_col_value_varchar => NULL,
27: p_ref_col_value_date => NULL,

Line 141: from HR_NAV_UNIT_GLOBAL_USAGES

137: end;
138:
139: select GLOBAL_USAGE_ID
140: into X_GLOBAL_USAGE_ID
141: from HR_NAV_UNIT_GLOBAL_USAGES
142: where GLOBAL_NAME = X_GLOBAL_NAME
143: and IN_OR_OUT = X_IN_OR_OUT
144: and NAV_UNIT_ID = X_NAV_UNIT_ID;
145: