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.PAY_PPM_BUS dependencies on PER_PEOPLE_F

Line 281: from per_people_f pp1

277: return date is
278: --
279: cursor pp_sel is
280: select pp1.effective_end_date
281: from per_people_f pp1
282: where pp1.person_id = p_payee_id
283: and pp1.effective_start_date >= p_effective_date
284: and pp1.effective_end_date =
285: (select max(pp2.effective_end_date)

Line 286: from per_people_f pp2

282: where pp1.person_id = p_payee_id
283: and pp1.effective_start_date >= p_effective_date
284: and pp1.effective_end_date =
285: (select max(pp2.effective_end_date)
286: from per_people_f pp2
287: where pp2.person_id = p_payee_id
288: and pp2.effective_start_date >= p_effective_date)
289: for update nowait;
290: --

Line 703: from per_people_f per

699: -- Check that the person is valid
700: --
701: cursor csr_chk_person is
702: select null
703: from per_people_f per
704: where per.person_id = p_payee_id
705: and p_effective_date between per.effective_start_date
706: and per.effective_end_date;
707: --