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 502: , (SELECT MEANING FROM hr_leg_lookups WHERE LOOKUP_TYPE='CONTACT'

498: WHERE PERSON_ID = CONTACT_PERSON_ID
499: AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
500: AND P_EFF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) CONTACT_FULL_NAME
501: , CONTACT_TYPE
502: , (SELECT MEANING FROM hr_leg_lookups WHERE LOOKUP_TYPE='CONTACT'
503: AND LOOKUP_CODE= CONTACT_TYPE ) CONTACT_TYPE_DESC
504: , PRIMARY_CONTACT_FLAG
505: , to_char(DATE_START,'YYYY-MM-DD')
506: , START_LIFE_REASON_ID

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

845: , EMPLOYER_COUNTRY
846: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = EMPLOYER_COUNTRY) EMPLOYER_COUNTRY_DESC
847: , EMPLOYER_ADDRESS
848: , EMPLOYER_TYPE
849: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE
850: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
851: AND ENABLED_FLAG = 'Y') EMPLOYER_TYPE_DESC
852: , EMPLOYER_SUBTYPE
853: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_SUBTYPE' AND LOOKUP_CODE = EMPLOYER_SUBTYPE

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

849: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE
850: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
851: AND ENABLED_FLAG = 'Y') EMPLOYER_TYPE_DESC
852: , EMPLOYER_SUBTYPE
853: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_SUBTYPE' AND LOOKUP_CODE = EMPLOYER_SUBTYPE
854: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
855: AND ENABLED_FLAG = 'Y') EMPLOYER_SUBTYPE_DESC
856: , DESCRIPTION
857: , PEM_ATTRIBUTE_CATEGORY

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

927: CURSOR CSR_WORK_INC_INFO_RECORD(p_person_id number,p_business_group_id number,p_eff_date date) IS
928: SELECT INCIDENT_ID
929: , INCIDENT_REFERENCE
930: , INCIDENT_TYPE
931: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INCIDENT_TYPE' AND LOOKUP_CODE = INCIDENT_TYPE
932: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
933: AND ENABLED_FLAG = 'Y') INCIDENT_TYPE_DESC
934: , to_char(INCIDENT_DATE,'YYYY-MM-DD')
935: , INCIDENT_TIME

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

935: , INCIDENT_TIME
936: , ASSIGNMENT_ID
937: , LOCATION
938: , AT_WORK_FLAG
939: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'AT_WORK_FLAG' AND LOOKUP_CODE = AT_WORK_FLAG
940: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
941: AND ENABLED_FLAG = 'Y') AT_WORK_FLAG_DESC
942: --, to_char(LAST_WORK_DATE,'YYYY-MM-DD') -- comented for bug 8905622
943: --, LAST_WORK_TIME -- comented for bug 8905622

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

951: , PERSON_REPORTED_TO
952: , WITNESS_DETAILS
953: , DESCRIPTION
954: , INJURY_TYPE
955: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INJURY_TYPE' AND LOOKUP_CODE = INJURY_TYPE
956: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
957: AND ENABLED_FLAG = 'Y') INJURY_TYPE_DESC
958: , DISEASE_TYPE
959: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE

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

955: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'INJURY_TYPE' AND LOOKUP_CODE = INJURY_TYPE
956: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
957: AND ENABLED_FLAG = 'Y') INJURY_TYPE_DESC
958: , DISEASE_TYPE
959: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE
960: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
961: AND ENABLED_FLAG = 'Y') DISEASE_TYPE_DESC
962: , HAZARD_TYPE
963: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'HAZARD_TYPE' AND LOOKUP_CODE = HAZARD_TYPE

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

959: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'DISEASE_TYPE' AND LOOKUP_CODE = DISEASE_TYPE
960: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
961: AND ENABLED_FLAG = 'Y') DISEASE_TYPE_DESC
962: , HAZARD_TYPE
963: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'HAZARD_TYPE' AND LOOKUP_CODE = HAZARD_TYPE
964: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
965: AND ENABLED_FLAG = 'Y') HAZARD_TYPE_DESC
966: , BODY_PART
967: , TREATMENT_RECEIVED_FLAG