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.PER_PEM_BUS dependencies on PER_ALL_PEOPLE_F

Line 727: from per_all_people_f

723: is
724: -- Define the cursor for the person_id
725: cursor csr_person_id is
726: select person_id
727: from per_all_people_f
728: where person_id = p_person_id;
729: --
730: cursor csr_effective_person_id is
731: select person_id

Line 732: from per_all_people_f

728: where person_id = p_person_id;
729: --
730: cursor csr_effective_person_id is
731: select person_id
732: from per_all_people_f
733: where person_id = p_person_id
734: and p_effective_date
735: between effective_start_date and effective_end_date;
736: --

Line 738: l_person_id per_all_people_f.person_id%type;

734: and p_effective_date
735: between effective_start_date and effective_end_date;
736: --
737: --
738: l_person_id per_all_people_f.person_id%type;
739: --
740: l_proc varchar2(72) := g_package||'chk_person_id';
741: l_api_updating boolean;
742: --