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.IRC_NOTIFICATION_DATA_PKG dependencies on HR_LOOKUPS

Line 315: ,hr_lookups hlk

311: from per_events pe
312: ,irc_interview_details iid
313: ,hr_locations_all loc
314: ,per_all_people_f ppf
315: ,hr_lookups hlk
316: ,hr_lookups hlk1
317: ,fnd_timezones_vl ft
318: where pe.event_id = c_interviewId
319: and iid.event_id = pe.event_id

Line 316: ,hr_lookups hlk1

312: ,irc_interview_details iid
313: ,hr_locations_all loc
314: ,per_all_people_f ppf
315: ,hr_lookups hlk
316: ,hr_lookups hlk1
317: ,fnd_timezones_vl ft
318: where pe.event_id = c_interviewId
319: and iid.event_id = pe.event_id
320: and c_effectiveDate between iid.start_date and iid.end_date

Line 435: from HR_LOOKUPS

431: select c_attributeName
432: || ':'
433: || meaning
434: || ';'
435: from HR_LOOKUPS
436: where LOOKUP_TYPE = 'IRC_INTERVIEW_STATUS'
437: and LOOKUP_CODE = c_interviewStatusCode;
438: l_interviewStatusMeaning varchar2(500);
439: l_func varchar2(50) := 'getInterviewStatusMeaning';