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_LOOKUPS

Line 57: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='BLOOD_TYPE'

53: APPLICANT_NUMBER,
54: BACKGROUND_CHECK_STATUS,
55: to_char(BACKGROUND_DATE_CHECK,'YYYY-MM-DD'),
56: BLOOD_TYPE,
57: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='BLOOD_TYPE'
58: AND LOOKUP_CODE=BLOOD_TYPE AND p_eff_date between nvl(start_date_active,p_eff_date)
59: AND nvl(end_date_active,p_eff_Date)
60: AND enabled_flag = 'Y')
61: BLOOD_TYPE_DESC,

Line 87: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='MAR_STATUS'

83: LAST_MEDICAL_TEST_BY,
84: to_char(LAST_MEDICAL_TEST_DATE,'YYYY-MM-DD'),
85: MAILSTOP,
86: MARITAL_STATUS,
87: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='MAR_STATUS'
88: AND LOOKUP_CODE=MARITAL_STATUS AND p_eff_date between nvl(start_date_active,p_eff_date)
89: AND nvl(end_date_active,p_eff_Date)
90: AND enabled_flag = 'Y')
91: MARITAL_STATUS_DESC,

Line 94: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='NATIONALITY'

90: AND enabled_flag = 'Y')
91: MARITAL_STATUS_DESC,
92: MIDDLE_NAMES,
93: NATIONALITY,
94: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='NATIONALITY'
95: AND LOOKUP_CODE=NATIONALITY AND p_eff_date between nvl(start_date_active,p_eff_date)
96: AND nvl(end_date_active,p_eff_Date)
97: AND enabled_flag = 'Y')
98: NATIONALITY_DESC,

Line 118: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='SEX'

114: to_char(RESUME_LAST_UPDATED,'YYYY-MM-DD'),
115: REGISTERED_DISABLED_FLAG,
116: SECOND_PASSPORT_EXISTS,
117: SEX,
118: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='SEX'
119: AND LOOKUP_CODE=SEX AND p_eff_date between nvl(start_date_active,p_eff_date)
120: AND nvl(end_date_active,p_eff_Date)
121: AND enabled_flag = 'Y')
122: SEX_DESC,

Line 124: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='STUDENT_STATUS'

120: AND nvl(end_date_active,p_eff_Date)
121: AND enabled_flag = 'Y')
122: SEX_DESC,
123: STUDENT_STATUS,
124: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='STUDENT_STATUS'
125: AND LOOKUP_CODE=STUDENT_STATUS AND p_eff_date between nvl(start_date_active,p_eff_date)
126: AND nvl(end_date_active,p_eff_Date)
127: AND enabled_flag = 'Y')
128: STUDENT_STATUS_DESC,

Line 131: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='TITLE'

127: AND enabled_flag = 'Y')
128: STUDENT_STATUS_DESC,
129: SUFFIX,
130: TITLE,
131: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='TITLE'
132: AND LOOKUP_CODE=TITLE AND p_eff_date between nvl(start_date_active,p_eff_date)
133: and nvl(end_date_active,p_eff_Date)
134: and enabled_flag = 'Y')
135: TITLE_DESC, -- too many rows - date effective ?

Line 138: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='WORK_SCHEDULE'

134: and enabled_flag = 'Y')
135: TITLE_DESC, -- too many rows - date effective ?
136: VENDOR_ID,
137: WORK_SCHEDULE,
138: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='WORK_SCHEDULE'
139: AND LOOKUP_CODE=WORK_SCHEDULE AND p_eff_date between nvl(start_date_active,p_eff_date)
140: and nvl(end_date_active,p_eff_Date)
141: and enabled_flag = 'Y')
142: WORK_SCHEDULE_DESC,

Line 150: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='TOBACCO_USER'

146: to_char(DPDNT_ADOPTION_DATE,'YYYY-MM-DD'),
147: DPDNT_VLNTRY_SVCE_FLAG,
148: to_char(RECEIPT_OF_DEATH_CERT_DATE,'YYYY-MM-DD'),
149: USES_TOBACCO_FLAG,
150: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE='TOBACCO_USER'
151: AND LOOKUP_CODE=USES_TOBACCO_FLAG AND p_eff_date between nvl(start_date_active,p_eff_date)
152: and nvl(end_date_active,p_eff_Date)
153: and enabled_flag = 'Y')
154: USES_TOBACCO_FLAG_DESC,

Line 326: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE =

322: , PAAF.PRIMARY_FLAG
323: , APPLICATION_ID
324: , ASSIGNMENT_NUMBER
325: , CHANGE_REASON
326: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE =
327: DECODE(PAAF.ASSIGNMENT_TYPE,'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON','')
328: AND LOOKUP_CODE = PAAF.CHANGE_REASON AND p_eff_date between nvl(start_date_active,p_eff_date)
329: and nvl(end_date_active,p_eff_Date)
330: and enabled_flag = 'Y') CHANGE_REASON_DESC

Line 335: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'EMP_CAT'

331: , COMMENT_ID
332: , to_char(DATE_PROBATION_END,'YYYY-MM-DD')
333: , DEFAULT_CODE_COMB_ID
334: , EMPLOYMENT_CATEGORY
335: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'EMP_CAT'
336: AND LOOKUP_CODE = EMPLOYMENT_CATEGORY
337: AND p_eff_date between nvl(start_date_active,p_eff_date) and nvl(end_date_active,p_eff_Date)
338: and enabled_flag = 'Y')
339: EMPLOYMENT_CATEGORY_DESC -- Too many values

Line 341: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'

337: AND p_eff_date between nvl(start_date_active,p_eff_date) and nvl(end_date_active,p_eff_Date)
338: and enabled_flag = 'Y')
339: EMPLOYMENT_CATEGORY_DESC -- Too many values
340: , FREQUENCY
341: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'
342: AND LOOKUP_CODE = PAAF.FREQUENCY AND p_eff_date between nvl(start_date_active,p_eff_date)
343: and nvl(end_date_active,p_eff_Date)
344: and enabled_flag = 'Y')
345: FREQUENCY_DESC -- Too many values

Line 351: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'

347: , MANAGER_FLAG
348: , NORMAL_HOURS
349: , PERF_REVIEW_PERIOD
350: , PERF_REVIEW_PERIOD_FREQUENCY
351: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'
352: AND LOOKUP_CODE = PAAF.PERF_REVIEW_PERIOD_FREQUENCY AND p_eff_date between nvl(start_date_active,p_eff_date)
353: and nvl(end_date_active,p_eff_Date)
354: and enabled_flag = 'Y')
355: PERF_RP_FREQUENCY_DESC -- Too many values

Line 359: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'QUALIFYING_UNITS'

355: PERF_RP_FREQUENCY_DESC -- Too many values
356: , PERIOD_OF_SERVICE_ID
357: , PROBATION_PERIOD
358: , PROBATION_UNIT
359: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'QUALIFYING_UNITS'
360: AND LOOKUP_CODE = PAAF.PROBATION_UNIT AND p_eff_date between nvl(start_date_active,p_eff_date)
361: and nvl(end_date_active,p_eff_Date)
362: and enabled_flag = 'Y') PROBATION_UNIT_DESC
363: , SAL_REVIEW_PERIOD

Line 365: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'

361: and nvl(end_date_active,p_eff_Date)
362: and enabled_flag = 'Y') PROBATION_UNIT_DESC
363: , SAL_REVIEW_PERIOD
364: , SAL_REVIEW_PERIOD_FREQUENCY
365: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'
366: AND LOOKUP_CODE = PAAF.SAL_REVIEW_PERIOD_FREQUENCY AND p_eff_date between nvl(start_date_active,p_eff_date)
367: and nvl(end_date_active,p_eff_Date)
368: and enabled_flag = 'Y')
369: SAL_RP_FREQUENCY_DESC -- Too many values

Line 375: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'BARGAINING_UNIT_CODE'

371: , SOURCE_TYPE
372: , TIME_NORMAL_FINISH
373: , TIME_NORMAL_START
374: , BARGAINING_UNIT_CODE
375: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'BARGAINING_UNIT_CODE'
376: AND LOOKUP_CODE = PAAF.BARGAINING_UNIT_CODE AND p_eff_date between nvl(start_date_active,p_eff_date)
377: and nvl(end_date_active,p_eff_Date)
378: and enabled_flag = 'Y')
379: BARGAINING_UNIT_DESC

Line 382: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'HOURLY_SALARIED_CODE'

378: and enabled_flag = 'Y')
379: BARGAINING_UNIT_DESC
380: , LABOUR_UNION_MEMBER_FLAG
381: , HOURLY_SALARIED_CODE
382: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'HOURLY_SALARIED_CODE'
383: AND LOOKUP_CODE = PAAF.HOURLY_SALARIED_CODE AND p_eff_date between nvl(start_date_active,p_eff_date)
384: and nvl(end_date_active,p_eff_Date)
385: and enabled_flag = 'Y')
386: HOURLY_SALARIED_DESC

Line 429: , (select meaning from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'

425: , TITLE
426: , NOTICE_PERIOD
427: , NOTICE_PERIOD_UOM
428: , EMPLOYEE_CATEGORY
429: , (select meaning from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'
430: AND LOOKUP_CODE = PAAF.EMPLOYEE_CATEGORY AND p_eff_date between nvl(start_date_active,p_eff_date)
431: and nvl(end_date_active,p_eff_Date)
432: and enabled_flag = 'Y') EMPLOYEE_CATEGORY_DESC
433: , WORK_AT_HOME

Line 582: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'ADDRESS_TYPE' AND LOOKUP_CODE = ADDRESS_TYPE

578: , ADDRESS_LINE1
579: , ADDRESS_LINE2
580: , ADDRESS_LINE3
581: , ADDRESS_TYPE
582: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'ADDRESS_TYPE' AND LOOKUP_CODE = ADDRESS_TYPE
583: AND p_eff_date between nvl(start_date_active,p_eff_date)
584: and nvl(end_date_active,p_eff_Date)
585: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
586: , COUNTRY

Line 654: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'ADDRESS_TYPE' AND LOOKUP_CODE = ADDRESS_TYPE

650: , ADDRESS_LINE1
651: , ADDRESS_LINE2
652: , ADDRESS_LINE3
653: , ADDRESS_TYPE
654: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'ADDRESS_TYPE' AND LOOKUP_CODE = ADDRESS_TYPE
655: AND p_eff_date between nvl(start_date_active,p_eff_date)
656: and nvl(end_date_active,p_eff_Date)
657: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
658: , COUNTRY

Line 1076: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_CM_MTHD' AND LOOKUP_CODE = COMM_DLVRY_METHOD

1072: SELECT DELIVERY_METHOD_ID
1073: , to_char(DATE_START,'YYYY-MM-DD')
1074: , to_char(DATE_END,'YYYY-MM-DD')
1075: , COMM_DLVRY_METHOD
1076: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_CM_MTHD' AND LOOKUP_CODE = COMM_DLVRY_METHOD
1077: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1078: AND ENABLED_FLAG = 'Y') COMM_DLVRY_METHOD_DESC
1079: , PREFERRED_FLAG
1080: , ATTRIBUTE_CATEGORY

Line 1240: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PHONE_TYPE' AND LOOKUP_CODE = PHONE_TYPE

1236: PHONE_ID,
1237: to_char(DATE_FROM,'YYYY-MM-DD'),
1238: to_char(DATE_TO,'YYYY-MM-DD'),
1239: PHONE_TYPE,
1240: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PHONE_TYPE' AND LOOKUP_CODE = PHONE_TYPE
1241: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1242: AND ENABLED_FLAG = 'Y') COMM_DLVRY_METHOD_DESC,
1243: PHONE_NUMBER,
1244: ATTRIBUTE_CATEGORY,

Line 1289: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = STATUS

1285: select QUALIFICATION_ID,
1286: TITLE,
1287: GRADE_ATTAINED,
1288: STATUS,
1289: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = STATUS
1290: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1291: AND ENABLED_FLAG = 'Y') STATUS_DESC,
1292: TO_CHAR(AWARDED_DATE,'YYYY-MM-DD'),
1293: FEE,

Line 1311: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_TUITION_METHODS' AND LOOKUP_CODE = TUITION_METHOD

1307: LICENSE_RESTRICTIONS,
1308: TO_CHAR(PROJECTED_COMPLETION_DATE,'YYYY-MM-DD'),
1309: AWARDING_BODY,
1310: TUITION_METHOD,
1311: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_TUITION_METHODS' AND LOOKUP_CODE = TUITION_METHOD
1312: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1313: AND ENABLED_FLAG = 'Y') TUITION_METHOD_DESC,
1314: GROUP_RANKING,
1315: COMMENTS,

Line 1345: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PQP_SUBSCRIPTION_PAY_METHODS' AND LOOKUP_CODE = SUBSCRIPTION_PAYMENT_METHOD

1341: PROFESSIONAL_BODY_NAME,
1342: MEMBERSHIP_NUMBER,
1343: MEMBERSHIP_CATEGORY,
1344: SUBSCRIPTION_PAYMENT_METHOD,
1345: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PQP_SUBSCRIPTION_PAY_METHODS' AND LOOKUP_CODE = SUBSCRIPTION_PAYMENT_METHOD
1346: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1347: AND ENABLED_FLAG = 'Y')SUBSCRIPTION_PAYMENT_DESC,
1348: QUA_INFORMATION_CATEGORY,
1349: QUA_INFORMATION1,

Line 1385: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = SUBJECT_STATUS

1381: SELECT SUBJECTS_TAKEN_ID,
1382: to_char(START_DATE,'YYYY-MM-DD'),
1383: MAJOR,
1384: SUBJECT_STATUS,
1385: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = SUBJECT_STATUS
1386: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1387: AND ENABLED_FLAG = 'Y')SUBJECT_STATUS_DESC,
1388: SUBJECT,
1389: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECTS' AND LOOKUP_CODE = SUBJECT

Line 1389: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECTS' AND LOOKUP_CODE = SUBJECT

1385: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = SUBJECT_STATUS
1386: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1387: AND ENABLED_FLAG = 'Y')SUBJECT_STATUS_DESC,
1388: SUBJECT,
1389: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECTS' AND LOOKUP_CODE = SUBJECT
1390: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1391: AND ENABLED_FLAG = 'Y')
1392: SUBJECT_DESC,
1393: GRADE_ATTAINED,

Line 1574: from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'

1570:
1571: if p_srch_criteria(i).p_employee_category is not null
1572: then
1573: select LOOKUP_CODE into p_empl_category
1574: from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'
1575: AND meaning = p_srch_criteria(i).p_employee_category
1576: AND p_srch_criteria(i).p_effective_date between nvl(start_date_active,p_srch_criteria(i).p_effective_date)
1577: and nvl(end_date_active,p_srch_criteria(i).p_effective_date)
1578: and enabled_flag = 'Y';

Line 1584: from HR_LOOKUPS where lookup_type = 'EMP_CAT'

1580:
1581: if p_srch_criteria(i).p_employment_category is not null
1582: then
1583: select LOOKUP_CODE into p_emplmt_category
1584: from HR_LOOKUPS where lookup_type = 'EMP_CAT'
1585: AND meaning = p_srch_criteria(i).p_employment_category
1586: AND p_srch_criteria(i).p_effective_date between nvl(start_date_active,p_srch_criteria(i).p_effective_date)
1587: and nvl(end_date_active,p_srch_criteria(i).p_effective_date)
1588: and enabled_flag = 'Y';