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

Line 376: -- If a row does exist in per_all_people_f for the given designated_receiver id,

372: -- p_business_group_id
373: -- p_effective_date
374: --
375: -- Post Success:
376: -- If a row does exist in per_all_people_f for the given designated_receiver id,
377: -- and this person is an active employee then processing continues.
378: --
379: -- Post Failure:
380: -- If a row does not exist in per_people_f for the given designated_receiver id then

Line 405: FROM per_all_people_f

401: l_proc VARCHAR2(72) := g_package||'chk_designated_receiver_id';
402: --
403: cursor csr_valid_pers IS
404: SELECT NULL
405: FROM per_all_people_f
406: WHERE person_id = p_designated_receiver_id
407: AND employee_number IS NOT NULL
408: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
409: AND ( p_business_group_id IS NULL