DBA Data[Home] [Help]

APPS.HR_KI_OPT_LOAD_API dependencies on FND_RESPONSIBILITY

Line 170: select responsibility_id||'#'||application_id from fnd_responsibility

166: where
167: application_short_name = X_OPTION_LEVEL_KEY;
168:
169: CURSOR CUR_VALIDATE_LEVEL_RESP IS
170: select responsibility_id||'#'||application_id from fnd_responsibility
171: where
172: responsibility_key = X_OPTION_LEVEL_KEY;
173:
174: CURSOR CUR_VALIDATE_LEVEL_USR IS

Line 313: fnd_responsibility resp

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
316: and int.integration_id=opt.integration_id
317: and upper(int.integration_key) = upper(X_INTEGRATION_KEY)