SELECT seeded_person_type_key, default_flag, system_person_type, user_person_type, current_applicant_flag, current_emp_or_apl_flag, current_employee_flag, last_updated_by, last_update_date, last_update_login, created_by, creation_date from per_startup_person_types_tl where LANGUAGE = USERENV('LANG')
SELECT SEEDED_PERSON_TYPE_KEY
, DEFAULT_FLAG
, SYSTEM_PERSON_TYPE
, USER_PERSON_TYPE
, CURRENT_APPLICANT_FLAG
, CURRENT_EMP_OR_APL_FLAG
, CURRENT_EMPLOYEE_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PER_STARTUP_PERSON_TYPES_TL
WHERE LANGUAGE = USERENV('LANG')
|
|
|