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_APPRAISALS_UTIL_SS dependencies on PER_PEOPLE_F

Line 739: per_people_f

735: nvl(nvl(current_employee_flag
736: ,current_npw_flag)
737: ,'N')
738: FROM
739: per_people_f
740: WHERE person_id = p_person_id
741: AND sysdate BETWEEN effective_start_date AND effective_end_date;
742:
743: current_wkr_flag VARCHAR2(2);

Line 767: per_people_f

763: nvl(nvl(current_employee_flag
764: ,current_npw_flag)
765: ,'N')
766: FROM
767: per_people_f
768: WHERE person_id = p_person_id
769: AND sysdate BETWEEN effective_start_date AND effective_end_date;
770:
771: current_wkr_flag VARCHAR2(2);

Line 793: per_people_f

789: nvl(nvl(current_employee_flag
790: ,current_npw_flag)
791: ,'N')
792: FROM
793: per_people_f
794: WHERE person_id = p_approver_id
795: AND sysdate BETWEEN effective_start_date AND effective_end_date;
796:
797: current_wkr_flag VARCHAR2(2);

Line 829: per_people_f

825: nvl(nvl(current_employee_flag
826: ,current_npw_flag)
827: ,'N')
828: FROM
829: per_people_f
830: WHERE person_id = p_approver_id
831: AND sysdate BETWEEN effective_start_date AND effective_end_date;
832:
833: cursor csr_approver_id ( p_role in varchar2 ) is