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_OFFER_CUSTOM dependencies on PER_ALL_PEOPLE_F

Line 119: from per_all_people_f ppf

115: cursor csr_pp(l_effective_date in date) is
116: select ppf.person_id
117: ,ppf.first_name||' '||ppf.last_name
118: ,ppf.applicant_number
119: from per_all_people_f ppf
120: ,per_all_assignments_f paf
121: where paf.assignment_id = p_candidate_assignment_id
122: and l_effective_date
123: between paf.effective_start_date

Line 188: function set_supervisor_id (p_person_id in per_all_people_f.person_id%type)

184: -- ----------------------------------------------------------------------------
185: --
186: -- This function returns the Id of a supervisor.
187: --
188: function set_supervisor_id (p_person_id in per_all_people_f.person_id%type)
189: return per_all_people_f.person_id%type is
190: --
191: cursor csr_supervisor_id is
192: select a.supervisor_id

Line 189: return per_all_people_f.person_id%type is

185: --
186: -- This function returns the Id of a supervisor.
187: --
188: function set_supervisor_id (p_person_id in per_all_people_f.person_id%type)
189: return per_all_people_f.person_id%type is
190: --
191: cursor csr_supervisor_id is
192: select a.supervisor_id
193: from per_all_assignments_f a

Line 235: ,per_all_people_f ppf

231: cursor csr_pa(l_effective_date in date
232: ,l_in_person_id in per_people_f.person_id%type) is
233: select ppf.person_id
234: from per_all_assignments_f paf
235: ,per_all_people_f ppf
236: where paf.person_id = l_in_person_id
237: and paf.primary_flag = 'Y'
238: and l_effective_date
239: between paf.effective_start_date