eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EDW_HR_PRSN_TYP_FKV

Source

View Text - Preformatted


SELECT /* $Header: hrisvpt.odf 120.0 2005/05/29 06:44:21 appldev noship $ */ ptc.person_type_pk || inst.instance_code person_type_pk ,ptc.employee pw_employee_type ,ptc.permanent dh_permenant_type ,ptc.intern dh_intern_type ,ptc.fixed_term_lower dh_fxd_trm_lower_type ,ptc.fixed_term_upper dh_fxd_trm_upper_type ,ptc.employee_student dh_emp_student_flag ,ptc.agency cw_agncy_cntrctr_type ,ptc.self_employed cw_self_employed_type ,ptc.consultant cw_consultant_type ,ptc.ex_employee pw_ex_employee_type ,ptc.applicant pw_applicant_type ,ptc.contact nw_contact_flag ,ptc.dependent nw_dependent_type ,ptc.retiree nw_retiree_type ,ptc.beneficiary nw_beneficiary_type ,ptc.surviving_family_member srvivng_fmly_mbr_type ,ptc.surviving_spouse srvivng_spouse_type ,ptc.ex_applicant ex_applicant_type ,ptc.other other_type ,ptc.participant participant_type ,ptc.former_spouse former_spouse_type ,ptc.former_family_member former_fmly_mbr_type FROM hri_person_type_cmbns ptc ,edw_local_instance inst

View Text - HTML Formatted

SELECT /* $HEADER: HRISVPT.ODF 120.0 2005/05/29 06:44:21 APPLDEV NOSHIP $ */ PTC.PERSON_TYPE_PK || INST.INSTANCE_CODE PERSON_TYPE_PK
, PTC.EMPLOYEE PW_EMPLOYEE_TYPE
, PTC.PERMANENT DH_PERMENANT_TYPE
, PTC.INTERN DH_INTERN_TYPE
, PTC.FIXED_TERM_LOWER DH_FXD_TRM_LOWER_TYPE
, PTC.FIXED_TERM_UPPER DH_FXD_TRM_UPPER_TYPE
, PTC.EMPLOYEE_STUDENT DH_EMP_STUDENT_FLAG
, PTC.AGENCY CW_AGNCY_CNTRCTR_TYPE
, PTC.SELF_EMPLOYED CW_SELF_EMPLOYED_TYPE
, PTC.CONSULTANT CW_CONSULTANT_TYPE
, PTC.EX_EMPLOYEE PW_EX_EMPLOYEE_TYPE
, PTC.APPLICANT PW_APPLICANT_TYPE
, PTC.CONTACT NW_CONTACT_FLAG
, PTC.DEPENDENT NW_DEPENDENT_TYPE
, PTC.RETIREE NW_RETIREE_TYPE
, PTC.BENEFICIARY NW_BENEFICIARY_TYPE
, PTC.SURVIVING_FAMILY_MEMBER SRVIVNG_FMLY_MBR_TYPE
, PTC.SURVIVING_SPOUSE SRVIVNG_SPOUSE_TYPE
, PTC.EX_APPLICANT EX_APPLICANT_TYPE
, PTC.OTHER OTHER_TYPE
, PTC.PARTICIPANT PARTICIPANT_TYPE
, PTC.FORMER_SPOUSE FORMER_SPOUSE_TYPE
, PTC.FORMER_FAMILY_MEMBER FORMER_FMLY_MBR_TYPE
FROM HRI_PERSON_TYPE_CMBNS PTC
, EDW_LOCAL_INSTANCE INST