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

Line 347: ,hr_lookups hlk

343: from per_events pe
344: ,irc_interview_details iid
345: ,hr_locations_all loc
346: ,per_all_people_f ppf
347: ,hr_lookups hlk
348: ,hr_lookups hlk1
349: ,fnd_timezones_vl ft
350: where pe.event_id = c_interviewId
351: and iid.event_id = pe.event_id

Line 348: ,hr_lookups hlk1

344: ,irc_interview_details iid
345: ,hr_locations_all loc
346: ,per_all_people_f ppf
347: ,hr_lookups hlk
348: ,hr_lookups hlk1
349: ,fnd_timezones_vl ft
350: where pe.event_id = c_interviewId
351: and iid.event_id = pe.event_id
352: and c_effectiveDate between iid.start_date and iid.end_date

Line 556: from HR_LOOKUPS

552: select c_attributeName
553: || ':'
554: || meaning
555: || ';'
556: from HR_LOOKUPS
557: where LOOKUP_TYPE = 'IRC_INTERVIEW_STATUS'
558: and LOOKUP_CODE = c_interviewStatusCode;
559: l_interviewStatusMeaning varchar2(500);
560: l_func varchar2(50) := 'getInterviewStatusMeaning';