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.

APPS.HR_PERSON_RECORD dependencies on HR_LEG_LOOKUPS

Line 483: , (SELECT MEANING FROM hr_leg_lookups WHERE LOOKUP_TYPE='CONTACT'

479: WHERE PERSON_ID = CONTACT_PERSON_ID
480: AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
481: AND P_EFF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) CONTACT_FULL_NAME
482: , CONTACT_TYPE
483: , (SELECT MEANING FROM hr_leg_lookups WHERE LOOKUP_TYPE='CONTACT'
484: AND LOOKUP_CODE= CONTACT_TYPE ) CONTACT_TYPE_DESC
485: , PRIMARY_CONTACT_FLAG
486: , to_char(DATE_START,'YYYY-MM-DD')
487: , START_LIFE_REASON_ID

Line 830: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE

826: , EMPLOYER_COUNTRY
827: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = EMPLOYER_COUNTRY) EMPLOYER_COUNTRY_DESC
828: , EMPLOYER_ADDRESS
829: , EMPLOYER_TYPE
830: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE
831: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
832: AND ENABLED_FLAG = 'Y') EMPLOYER_TYPE_DESC
833: , EMPLOYER_SUBTYPE
834: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_SUBTYPE' AND LOOKUP_CODE = EMPLOYER_SUBTYPE

Line 834: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_SUBTYPE' AND LOOKUP_CODE = EMPLOYER_SUBTYPE

830: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE
831: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
832: AND ENABLED_FLAG = 'Y') EMPLOYER_TYPE_DESC
833: , EMPLOYER_SUBTYPE
834: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_SUBTYPE' AND LOOKUP_CODE = EMPLOYER_SUBTYPE
835: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
836: AND ENABLED_FLAG = 'Y') EMPLOYER_SUBTYPE_DESC
837: , DESCRIPTION
838: , PEM_ATTRIBUTE_CATEGORY

Line 912: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INCIDENT_TYPE' AND LOOKUP_CODE = INCIDENT_TYPE

908: CURSOR CSR_WORK_INC_INFO_RECORD(p_person_id number,p_business_group_id number,p_eff_date date) IS
909: SELECT INCIDENT_ID
910: , INCIDENT_REFERENCE
911: , INCIDENT_TYPE
912: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INCIDENT_TYPE' AND LOOKUP_CODE = INCIDENT_TYPE
913: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
914: AND ENABLED_FLAG = 'Y') INCIDENT_TYPE_DESC
915: , to_char(INCIDENT_DATE,'YYYY-MM-DD')
916: , INCIDENT_TIME

Line 920: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'AT_WORK_FLAG' AND LOOKUP_CODE = AT_WORK_FLAG

916: , INCIDENT_TIME
917: , ASSIGNMENT_ID
918: , LOCATION
919: , AT_WORK_FLAG
920: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'AT_WORK_FLAG' AND LOOKUP_CODE = AT_WORK_FLAG
921: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
922: AND ENABLED_FLAG = 'Y') AT_WORK_FLAG_DESC
923: , to_char(LAST_WORK_DATE,'YYYY-MM-DD')
924: , LAST_WORK_TIME

Line 936: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INJURY_TYPE' AND LOOKUP_CODE = INJURY_TYPE

932: , PERSON_REPORTED_TO
933: , WITNESS_DETAILS
934: , DESCRIPTION
935: , INJURY_TYPE
936: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INJURY_TYPE' AND LOOKUP_CODE = INJURY_TYPE
937: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
938: AND ENABLED_FLAG = 'Y') INJURY_TYPE_DESC
939: , DISEASE_TYPE
940: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE

Line 940: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE

936: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INJURY_TYPE' AND LOOKUP_CODE = INJURY_TYPE
937: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
938: AND ENABLED_FLAG = 'Y') INJURY_TYPE_DESC
939: , DISEASE_TYPE
940: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE
941: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
942: AND ENABLED_FLAG = 'Y') DISEASE_TYPE_DESC
943: , HAZARD_TYPE
944: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'HAZARD_TYPE' AND LOOKUP_CODE = HAZARD_TYPE

Line 944: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'HAZARD_TYPE' AND LOOKUP_CODE = HAZARD_TYPE

940: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE
941: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
942: AND ENABLED_FLAG = 'Y') DISEASE_TYPE_DESC
943: , HAZARD_TYPE
944: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'HAZARD_TYPE' AND LOOKUP_CODE = HAZARD_TYPE
945: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
946: AND ENABLED_FLAG = 'Y') HAZARD_TYPE_DESC
947: , BODY_PART
948: , TREATMENT_RECEIVED_FLAG