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.HXC_TIMEKEEPER_GROUP_API dependencies on PER_PEOPLE

Line 641: FROM per_people_f p

637: CURSOR csr_chk_tk_resource_id IS
638: SELECT 'x'
639: FROM dual
640: WHERE EXISTS ( select 'x'
641: FROM per_people_f p
642: WHERE p.person_id = p_tk_resource_id );
643:
644: BEGIN
645:

Line 705: FROM per_people p

701:
702: CURSOR csr_get_full_name ( p_person_id NUMBER ) IS
703: SELECT p.full_name
704: , nvl(p.employee_number, p.npw_number) employee_number
705: FROM per_people p
706: WHERE p.person_id = p_person_id;
707:
708:
709:

Line 769: per_people p

765: , nvl(p.employee_number, p.npw_number) employee_number
766: , SUBSTR(hxc_tk_grp_query_criteria_api.get_tc_period ( p.person_id ),1,80) tc_period_name
767: , hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id) person_type
768: FROM
769: per_people p
770: , per_assignments asg
771: , hr_assignment_set_amendments asa
772: , hr_assignment_sets ass
773: , per_person_types ppt --added 2943706

Line 794: per_people p

790: , nvl(p.employee_number, p.npw_number) employee_number
791: , SUBSTR(hxc_tk_grp_query_criteria_api.get_tc_period ( p.person_id ),1,80) tc_period_name
792: , hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id) person_type
793: FROM
794: per_people p
795: , per_assignments asg
796: , per_person_types ppt --added 2943706
797: , per_person_type_usages pptu
798: WHERE asg.organization_id = p_populate_id