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 PER_ALL_PEOPLE_F

Line 108: ,per_all_people_f ppf

104: select 'IRC_CAND_AGENCY_ID:'
105: || inp.agency_id
106: || ';'
107: from irc_notification_preferences inp
108: ,per_all_people_f ppf
109: where inp.person_id = c_candidateId
110: and ppf.person_id = c_candidateId
111: and c_effectiveDate between ppf.effective_start_date
112: and ppf.effective_end_date;

Line 346: ,per_all_people_f ppf

342: pe.location_id
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

Line 467: from per_all_people_f per

463: || c_role
464: || '_EMAIL_ID:'
465: || per.email_address
466: || ';'
467: from per_all_people_f per
468: where per.person_id = c_personId
469: and trunc(c_effectiveDate)
470: between trunc(per.effective_start_date) and trunc(per.effective_end_date);
471: l_personDetails varchar2(1000);

Line 614: from per_all_people_f ppf

610: , c_effectiveDate date) is
611: select '

'
612: || ppf.full_name
613: || '

' interviewer
614: from per_all_people_f ppf
615: , per_bookings pb
616: where ppf.person_id = pb.person_id
617: and pb.event_id = c_interviewId
618: and trunc(c_effectiveDate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date);