APPS.HR_KI_OPT_LOAD_API dependencies on HR_KI_OPTION_TYPES

Line 160: hr_ki_option_types

156:
157: CURSOR CUR_VALIDATE_OTY IS
158: select option_type_id
159: from
160: hr_ki_option_types
161: where
162: upper(option_type_key) = upper(X_OPTION_TYPE_KEY);
163:
164: CURSOR CUR_VALIDATE_LEVEL_APP IS

Line 260: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;

256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
257: l_last_update_login HR_KI_OPTIONS.last_update_login%TYPE := 0;
258: l_option_id HR_KI_OPTIONS.option_id%TYPE;
259: l_option_level_id HR_KI_OPTIONS.option_level_id%TYPE;
260: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
261: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
262: l_object_version_number HR_KI_OPTIONS.object_version_number%TYPE;
263:
264: db_luby number; -- entity owner in db

Line 270: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

266:
267: CURSOR CUR_VALIDATE_SITE IS
268: select
269: distinct opt.option_id,opt.object_version_number
270: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
271: hr_ki_integrations int
272: where
273: opt.option_type_id=oty.option_type_id
274: and int.integration_id=opt.integration_id

Line 283: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

279:
280: CURSOR CUR_VALIDATE_ROLE IS
281: select
282: distinct opt.option_id,opt.object_version_number
283: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
284: hr_ki_integrations int
285: where
286: opt.option_type_id=oty.option_type_id
287: and int.integration_id=opt.integration_id

Line 296: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

292:
293: CURSOR CUR_VALIDATE_USER IS
294: select
295: distinct opt.option_id,opt.object_version_number
296: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
297: hr_ki_integrations int,
298: fnd_user usr
299: where
300: opt.option_type_id=oty.option_type_id

Line 311: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

307:
308: CURSOR CUR_VALIDATE_RESP IS
309: select
310: distinct opt.option_id,opt.object_version_number
311: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
312: hr_ki_integrations int,
313: fnd_responsibility resp
314: where
315: opt.option_type_id=oty.option_type_id

Line 329: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

325:
326: CURSOR CUR_VALIDATE_APP IS
327: select
328: distinct opt.option_id,opt.object_version_number
329: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
330: hr_ki_integrations int,
331: fnd_application app
332: where
333: opt.option_type_id=oty.option_type_id