VIEW: APPS.HRI_CL_PER_V

Source

View Text - Preformatted

SELECT per.ID ID , per.VALUE VALUE , per.start_date start_date , per.end_date end_date , per.effective_start_date effective_start_date , per.effective_end_date effective_end_date ,'1'||per.order_by order_by , per.business_group_id business_group_id , per.apl_flag_code apl_flag_code , per.emp_flag_code emp_flag_code , per.cwk_flag_code cwk_flag_code , per.emp_or_apl_flag_code emp_or_apl_flag_code , per.worker_flag_code 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 , per.hr_security_flag_code hr_security_flag_code , per.bg_security_flag_code bg_security_flag_code FROM hri_cl_per_n_v per UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , hr_general.start_of_time effective_start_date , hr_general.end_of_time effective_end_date ,2||'' order_by , -1 business_group_id , '' apl_flag_code , '' emp_flag_code , '' cwk_flag_code , '' emp_or_apl_flag_code , '' worker_flag_code , '' full_name , '' last_name , '' first_name , '' middle_names , '' title , '' pre_name_adjunct , '' suffix , '' honors , '' known_as , '' applicant_number , '' employee_number , '' npw_number , '' national_identifier , 'Y' hr_security_flag_code , 'Y' bg_security_flag_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PER.ID ID
, PER.VALUE VALUE
, PER.START_DATE START_DATE
, PER.END_DATE END_DATE
, PER.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, '1'||PER.ORDER_BY ORDER_BY
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PER.APL_FLAG_CODE APL_FLAG_CODE
, PER.EMP_FLAG_CODE EMP_FLAG_CODE
, PER.CWK_FLAG_CODE CWK_FLAG_CODE
, PER.EMP_OR_APL_FLAG_CODE EMP_OR_APL_FLAG_CODE
, PER.WORKER_FLAG_CODE 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
, PER.HR_SECURITY_FLAG_CODE HR_SECURITY_FLAG_CODE
, PER.BG_SECURITY_FLAG_CODE BG_SECURITY_FLAG_CODE
FROM HRI_CL_PER_N_V PER UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, HR_GENERAL.START_OF_TIME EFFECTIVE_START_DATE
, HR_GENERAL.END_OF_TIME EFFECTIVE_END_DATE
, 2||'' ORDER_BY
, -1 BUSINESS_GROUP_ID
, '' APL_FLAG_CODE
, '' EMP_FLAG_CODE
, '' CWK_FLAG_CODE
, '' EMP_OR_APL_FLAG_CODE
, '' WORKER_FLAG_CODE
, '' FULL_NAME
, '' LAST_NAME
, '' FIRST_NAME
, '' MIDDLE_NAMES
, '' TITLE
, '' PRE_NAME_ADJUNCT
, '' SUFFIX
, '' HONORS
, '' KNOWN_AS
, '' APPLICANT_NUMBER
, '' EMPLOYEE_NUMBER
, '' NPW_NUMBER
, '' NATIONAL_IDENTIFIER
, 'Y' HR_SECURITY_FLAG_CODE
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY