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 723: from per_all_people_f

719: is
720: -- Define the cursor for the person_id
721: cursor csr_person_id is
722: select person_id
723: from per_all_people_f
724: where person_id = p_person_id;
725: --
726: cursor csr_effective_person_id is
727: select person_id

Line 728: from per_all_people_f

724: where person_id = p_person_id;
725: --
726: cursor csr_effective_person_id is
727: select person_id
728: from per_all_people_f
729: where person_id = p_person_id
730: and p_effective_date
731: between effective_start_date and effective_end_date;
732: --

Line 734: l_person_id per_all_people_f.person_id%type;

730: and p_effective_date
731: between effective_start_date and effective_end_date;
732: --
733: --
734: l_person_id per_all_people_f.person_id%type;
735: --
736: l_proc varchar2(72) := g_package||'chk_person_id';
737: l_api_updating boolean;
738: --