DBA Data[Home] [Help]

APPS.HR_KI_OPT_LOAD_API dependencies on FND_APPLICATION

Line 165: select application_id from fnd_application

161: where
162: upper(option_type_key) = upper(X_OPTION_TYPE_KEY);
163:
164: CURSOR CUR_VALIDATE_LEVEL_APP IS
165: select application_id from fnd_application
166: where
167: application_short_name = X_OPTION_LEVEL_KEY;
168:
169: CURSOR CUR_VALIDATE_LEVEL_RESP IS

Line 331: fnd_application app

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