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

Line 10: ,employee_name per_all_people_f.full_name%TYPE

6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE
7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE
11: ,comment_text hxc_time_building_blocks.comment_text%TYPE
12: ,application_name fnd_application_tl.application_name%TYPE
13: ,resource_id hxc_time_building_blocks.resource_id%TYPE
14: ,total_hours NUMBER(15, 3)

Line 653: p_person_id IN per_all_people_f.person_id%TYPE

649: END IF;
650: END release_locks;
651:
652: FUNCTION get_name(
653: p_person_id IN per_all_people_f.person_id%TYPE
654: )
655: RETURN VARCHAR2
656: IS
657:

Line 659: p_person_id per_all_people_f.person_id%TYPE

655: RETURN VARCHAR2
656: IS
657:
658: CURSOR c_name(
659: p_person_id per_all_people_f.person_id%TYPE
660: )
661: IS
662: SELECT full_name
663: FROM per_all_people_f

Line 663: FROM per_all_people_f

659: p_person_id per_all_people_f.person_id%TYPE
660: )
661: IS
662: SELECT full_name
663: FROM per_all_people_f
664: WHERE person_id = p_person_id
665: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
666:
667: l_name per_all_people_f.full_name%TYPE;

Line 667: l_name per_all_people_f.full_name%TYPE;

663: FROM per_all_people_f
664: WHERE person_id = p_person_id
665: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
666:
667: l_name per_all_people_f.full_name%TYPE;
668: BEGIN
669: OPEN c_name(p_person_id);
670: FETCH c_name INTO l_name;
671: CLOSE c_name;

Line 685: -- l_approver_name per_all_people_f.full_name%TYPE;

681: ,p_to_date IN VARCHAR2
682: ,p_adv_search IN VARCHAR2
683: )
684: IS
685: -- l_approver_name per_all_people_f.full_name%TYPE;
686: l_item_type wf_item_activity_statuses.item_type%TYPE := 'HXCEMP';
687: l_item_key wf_item_activity_statuses.item_key%TYPE;
688: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
689: l_app_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;

Line 749: ,per_all_people_f ppf

745: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)
746: FROM hxc_app_period_summary apsum
747: ,hxc_time_building_blocks htbb
748: ,fnd_application_tl favtl
749: ,per_all_people_f ppf
750: ,hxc_time_recipients htr
751: ,hxc_tc_ap_links htal
752: ,hxc_timecard_summary hts
753:

Line 1050: ,per_all_people_f ppf

1046: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)
1047: FROM hxc_app_period_summary apsum
1048: ,hxc_time_building_blocks htbb
1049: ,fnd_application_tl favtl
1050: ,per_all_people_f ppf
1051: ,hxc_time_recipients htr
1052: ,hxc_tc_ap_links htal
1053: ,hxc_timecard_summary hts
1054: