APPS.HR_KI_UCX_LOAD_API dependencies on HR_KI_USER_INTERFACES

Line 106: from HR_KI_USER_INTERFACES

102: l_proc VARCHAR2(35) := 'HR_KI_UCX_LOAD_API.VALIDATE_KEYS';
103:
104: CURSOR C_VAL_INT IS
105: select user_interface_id
106: from HR_KI_USER_INTERFACES
107: where upper(user_interface_key) = upper(X_USER_INTERFACE_KEY);
108:
109: begin
110:

Line 145: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;

141: l_last_update_date HR_KI_UI_CONTEXTS.last_update_date%TYPE := SYSDATE;
142: l_last_updated_by HR_KI_UI_CONTEXTS.last_updated_by%TYPE := 0;
143: l_last_update_login HR_KI_UI_CONTEXTS.last_update_login%TYPE := 0;
144: l_ui_context_id HR_KI_UI_CONTEXTS.ui_context_id%TYPE;
145: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
146: l_object_version_number HR_KI_OPTION_TYPES.object_version_number%TYPE;
147:
148:
149: db_luby number; -- entity owner in db

Line 155: hr_ki_user_interfaces uit

151:
152: CURSOR C_APPL IS
153: select uic.ui_context_id,uic.object_version_number
154: from HR_KI_UI_CONTEXTS uic,
155: hr_ki_user_interfaces uit
156: where uic.user_interface_id = uit.user_interface_id
157: and upper(uic.ui_context_key)=upper(x_ui_context_key)
158: and upper(uit.user_interface_key)=upper(x_user_interface_key);
159: