VIEW: APPS.HRI_CL_PER_HN_V

Source

View Text - Preformatted

SELECT per.person_id ID , per.full_name VALUE , per.effective_start_date START_DATE , per.effective_end_date END_DATE , per.effective_start_date EFFECTIVE_START_DATE , per.effective_end_date EFFECTIVE_END_DATE , per.business_group_id BUSINESS_GROUP_ID , NVL(per.current_applicant_flag,'N') APL_FLAG_CODE , NVL(per.current_employee_flag,'N') EMP_FLAG_CODE , NVL(per.current_npw_flag,'N') CWK_FLAG_CODE , NVL(per.current_emp_or_apl_flag,'N') EMP_OR_APL_FLAG_CODE , DECODE(per.current_employee_flag ,'N',NVL(per.current_npw_flag,'N') ,NVL(per.current_employee_flag,'N')) WORKER_FLAG_CODE , per.full_name FULL_NAME , per.last_name LAST_NAME , per.first_name FIRST_NAME , per.middle_names MIDDLE_NAMES , per.title TITLE , per.pre_name_adjunct PRE_NAME_ADJUNCT , per.suffix SUFFIX , per.honors HONORS , per.known_as KNOWN_AS , per.applicant_number APPLICANT_NUMBER , per.employee_number EMPLOYEE_NUMBER , per.npw_number NPW_NUMBER , per.national_identifier NATIONAL_IDENTIFIER FROM per_people_f per WHERE per.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, per.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT PER.PERSON_ID ID
, PER.FULL_NAME VALUE
, PER.EFFECTIVE_START_DATE START_DATE
, PER.EFFECTIVE_END_DATE END_DATE
, PER.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NVL(PER.CURRENT_APPLICANT_FLAG
, 'N') APL_FLAG_CODE
, NVL(PER.CURRENT_EMPLOYEE_FLAG
, 'N') EMP_FLAG_CODE
, NVL(PER.CURRENT_NPW_FLAG
, 'N') CWK_FLAG_CODE
, NVL(PER.CURRENT_EMP_OR_APL_FLAG
, 'N') EMP_OR_APL_FLAG_CODE
, DECODE(PER.CURRENT_EMPLOYEE_FLAG
, 'N'
, NVL(PER.CURRENT_NPW_FLAG
, 'N')
, NVL(PER.CURRENT_EMPLOYEE_FLAG
, 'N')) WORKER_FLAG_CODE
, PER.FULL_NAME FULL_NAME
, PER.LAST_NAME LAST_NAME
, PER.FIRST_NAME FIRST_NAME
, PER.MIDDLE_NAMES MIDDLE_NAMES
, PER.TITLE TITLE
, PER.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, PER.SUFFIX SUFFIX
, PER.HONORS HONORS
, PER.KNOWN_AS KNOWN_AS
, PER.APPLICANT_NUMBER APPLICANT_NUMBER
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PER.NPW_NUMBER NPW_NUMBER
, PER.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
FROM PER_PEOPLE_F PER
WHERE PER.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PER.BUSINESS_GROUP_ID) WITH READ ONLY