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.

[Home] [Help]

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 307: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE =

303: , PAAF.PRIMARY_FLAG
304: , APPLICATION_ID
305: , ASSIGNMENT_NUMBER
306: , CHANGE_REASON
307: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE =
308: DECODE(PAAF.ASSIGNMENT_TYPE,'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON','')
309: AND LOOKUP_CODE = PAAF.CHANGE_REASON AND p_eff_date between nvl(start_date_active,p_eff_date)
310: and nvl(end_date_active,p_eff_Date)
311: and enabled_flag = 'Y') CHANGE_REASON_DESC

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

312: , COMMENT_ID
313: , to_char(DATE_PROBATION_END,'YYYY-MM-DD')
314: , DEFAULT_CODE_COMB_ID
315: , EMPLOYMENT_CATEGORY
316: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'EMP_CAT'
317: AND LOOKUP_CODE = EMPLOYMENT_CATEGORY
318: AND p_eff_date between nvl(start_date_active,p_eff_date) and nvl(end_date_active,p_eff_Date)
319: and enabled_flag = 'Y')
320: EMPLOYMENT_CATEGORY_DESC -- Too many values

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

318: AND p_eff_date between nvl(start_date_active,p_eff_date) and nvl(end_date_active,p_eff_Date)
319: and enabled_flag = 'Y')
320: EMPLOYMENT_CATEGORY_DESC -- Too many values
321: , FREQUENCY
322: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'
323: AND LOOKUP_CODE = PAAF.FREQUENCY AND p_eff_date between nvl(start_date_active,p_eff_date)
324: and nvl(end_date_active,p_eff_Date)
325: and enabled_flag = 'Y')
326: FREQUENCY_DESC -- Too many values

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

328: , MANAGER_FLAG
329: , NORMAL_HOURS
330: , PERF_REVIEW_PERIOD
331: , PERF_REVIEW_PERIOD_FREQUENCY
332: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'
333: AND LOOKUP_CODE = PAAF.PERF_REVIEW_PERIOD_FREQUENCY AND p_eff_date between nvl(start_date_active,p_eff_date)
334: and nvl(end_date_active,p_eff_Date)
335: and enabled_flag = 'Y')
336: PERF_RP_FREQUENCY_DESC -- Too many values

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

336: PERF_RP_FREQUENCY_DESC -- Too many values
337: , PERIOD_OF_SERVICE_ID
338: , PROBATION_PERIOD
339: , PROBATION_UNIT
340: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'QUALIFYING_UNITS'
341: AND LOOKUP_CODE = PAAF.PROBATION_UNIT AND p_eff_date between nvl(start_date_active,p_eff_date)
342: and nvl(end_date_active,p_eff_Date)
343: and enabled_flag = 'Y') PROBATION_UNIT_DESC
344: , SAL_REVIEW_PERIOD

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

342: and nvl(end_date_active,p_eff_Date)
343: and enabled_flag = 'Y') PROBATION_UNIT_DESC
344: , SAL_REVIEW_PERIOD
345: , SAL_REVIEW_PERIOD_FREQUENCY
346: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'FREQUENCY'
347: AND LOOKUP_CODE = PAAF.SAL_REVIEW_PERIOD_FREQUENCY AND p_eff_date between nvl(start_date_active,p_eff_date)
348: and nvl(end_date_active,p_eff_Date)
349: and enabled_flag = 'Y')
350: SAL_RP_FREQUENCY_DESC -- Too many values

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

352: , SOURCE_TYPE
353: , TIME_NORMAL_FINISH
354: , TIME_NORMAL_START
355: , BARGAINING_UNIT_CODE
356: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'BARGAINING_UNIT_CODE'
357: AND LOOKUP_CODE = PAAF.BARGAINING_UNIT_CODE AND p_eff_date between nvl(start_date_active,p_eff_date)
358: and nvl(end_date_active,p_eff_Date)
359: and enabled_flag = 'Y')
360: BARGAINING_UNIT_DESC

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

359: and enabled_flag = 'Y')
360: BARGAINING_UNIT_DESC
361: , LABOUR_UNION_MEMBER_FLAG
362: , HOURLY_SALARIED_CODE
363: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'HOURLY_SALARIED_CODE'
364: AND LOOKUP_CODE = PAAF.HOURLY_SALARIED_CODE AND p_eff_date between nvl(start_date_active,p_eff_date)
365: and nvl(end_date_active,p_eff_Date)
366: and enabled_flag = 'Y')
367: HOURLY_SALARIED_DESC

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

406: , TITLE
407: , NOTICE_PERIOD
408: , NOTICE_PERIOD_UOM
409: , EMPLOYEE_CATEGORY
410: , (select meaning from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'
411: AND LOOKUP_CODE = PAAF.EMPLOYEE_CATEGORY AND p_eff_date between nvl(start_date_active,p_eff_date)
412: and nvl(end_date_active,p_eff_Date)
413: and enabled_flag = 'Y') EMPLOYEE_CATEGORY_DESC
414: , WORK_AT_HOME

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

559: , ADDRESS_LINE1
560: , ADDRESS_LINE2
561: , ADDRESS_LINE3
562: , ADDRESS_TYPE
563: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'ADDRESS_TYPE' AND LOOKUP_CODE = ADDRESS_TYPE
564: AND p_eff_date between nvl(start_date_active,p_eff_date)
565: and nvl(end_date_active,p_eff_Date)
566: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
567: , COUNTRY

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

631: , ADDRESS_LINE1
632: , ADDRESS_LINE2
633: , ADDRESS_LINE3
634: , ADDRESS_TYPE
635: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'ADDRESS_TYPE' AND LOOKUP_CODE = ADDRESS_TYPE
636: AND p_eff_date between nvl(start_date_active,p_eff_date)
637: and nvl(end_date_active,p_eff_Date)
638: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
639: , COUNTRY

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

1051: SELECT DELIVERY_METHOD_ID
1052: , to_char(DATE_START,'YYYY-MM-DD')
1053: , to_char(DATE_END,'YYYY-MM-DD')
1054: , COMM_DLVRY_METHOD
1055: , (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_CM_MTHD' AND LOOKUP_CODE = COMM_DLVRY_METHOD
1056: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1057: AND ENABLED_FLAG = 'Y') COMM_DLVRY_METHOD_DESC
1058: , PREFERRED_FLAG
1059: , ATTRIBUTE_CATEGORY

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

1215: PHONE_ID,
1216: to_char(DATE_FROM,'YYYY-MM-DD'),
1217: to_char(DATE_TO,'YYYY-MM-DD'),
1218: PHONE_TYPE,
1219: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PHONE_TYPE' AND LOOKUP_CODE = PHONE_TYPE
1220: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1221: AND ENABLED_FLAG = 'Y') COMM_DLVRY_METHOD_DESC,
1222: PHONE_NUMBER,
1223: ATTRIBUTE_CATEGORY,

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

1264: select QUALIFICATION_ID,
1265: TITLE,
1266: GRADE_ATTAINED,
1267: STATUS,
1268: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = STATUS
1269: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1270: AND ENABLED_FLAG = 'Y') STATUS_DESC,
1271: TO_CHAR(AWARDED_DATE,'YYYY-MM-DD'),
1272: FEE,

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

1286: LICENSE_RESTRICTIONS,
1287: TO_CHAR(PROJECTED_COMPLETION_DATE,'YYYY-MM-DD'),
1288: AWARDING_BODY,
1289: TUITION_METHOD,
1290: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_TUITION_METHODS' AND LOOKUP_CODE = TUITION_METHOD
1291: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1292: AND ENABLED_FLAG = 'Y') TUITION_METHOD_DESC,
1293: GROUP_RANKING,
1294: COMMENTS,

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

1320: PROFESSIONAL_BODY_NAME,
1321: MEMBERSHIP_NUMBER,
1322: MEMBERSHIP_CATEGORY,
1323: SUBSCRIPTION_PAYMENT_METHOD,
1324: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PQP_SUBSCRIPTION_PAY_METHODS' AND LOOKUP_CODE = SUBSCRIPTION_PAYMENT_METHOD
1325: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1326: AND ENABLED_FLAG = 'Y')SUBSCRIPTION_PAYMENT_DESC,
1327: QUA_INFORMATION_CATEGORY,
1328: QUA_INFORMATION1,

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

1360: SELECT SUBJECTS_TAKEN_ID,
1361: to_char(START_DATE,'YYYY-MM-DD'),
1362: MAJOR,
1363: SUBJECT_STATUS,
1364: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = SUBJECT_STATUS
1365: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1366: AND ENABLED_FLAG = 'Y')SUBJECT_STATUS_DESC,
1367: SUBJECT,
1368: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECTS' AND LOOKUP_CODE = SUBJECT

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

1364: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECT_STATUSES' AND LOOKUP_CODE = SUBJECT_STATUS
1365: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1366: AND ENABLED_FLAG = 'Y')SUBJECT_STATUS_DESC,
1367: SUBJECT,
1368: (SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUBJECTS' AND LOOKUP_CODE = SUBJECT
1369: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1370: AND ENABLED_FLAG = 'Y')
1371: SUBJECT_DESC,
1372: GRADE_ATTAINED,

Line 1959: ,hr_lookups hl

1955: from pay_payroll_actions ppa
1956: ,pay_assignment_actions paa
1957: ,per_assignments_f paf
1958: ,per_people_f ppf
1959: ,hr_lookups hl
1960: where ppa.action_type = 'X'
1961: and ppa.action_status = 'C'
1962: and ppa.report_type = hl.meaning
1963: and hl.lookup_type = 'PAYSLIP_REPORT_TYPES'

Line 1972: ,hr_lookups hl1

1968: and ppf.person_id = p_person_id
1969: and ppa.effective_date = (select max(ppa1.effective_date)
1970: from pay_payroll_actions ppa1
1971: ,pay_assignment_actions paa1
1972: ,hr_lookups hl1
1973: where ppa1.effective_date <= p_eff_date
1974: and ppa1.action_type = 'X'
1975: and ppa1.action_status = 'C'
1976: and ppa1.report_type = hl1.meaning

Line 2415: from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'

2411:
2412: if p_srch_criteria(i).p_employee_category is not null
2413: then
2414: select LOOKUP_CODE into p_empl_category
2415: from HR_LOOKUPS where lookup_type = 'EMPLOYEE_CATG'
2416: AND meaning = p_srch_criteria(i).p_employee_category
2417: AND p_srch_criteria(i).p_effective_date between nvl(start_date_active,p_srch_criteria(i).p_effective_date)
2418: and nvl(end_date_active,p_srch_criteria(i).p_effective_date)
2419: and enabled_flag = 'Y';

Line 2425: from HR_LOOKUPS where lookup_type = 'EMP_CAT'

2421:
2422: if p_srch_criteria(i).p_employment_category is not null
2423: then
2424: select LOOKUP_CODE into p_emplmt_category
2425: from HR_LOOKUPS where lookup_type = 'EMP_CAT'
2426: AND meaning = p_srch_criteria(i).p_employment_category
2427: AND p_srch_criteria(i).p_effective_date between nvl(start_date_active,p_srch_criteria(i).p_effective_date)
2428: and nvl(end_date_active,p_srch_criteria(i).p_effective_date)
2429: and enabled_flag = 'Y';