APPS.HXC_RETRIEVAL_ROLLBACK dependencies on PER_ALL_PEOPLE_F

Line 34: FROM per_all_people_f

30: IS
31:
32: CURSOR get_person_name
33: IS SELECT full_name
34: FROM per_all_people_f
35: WHERE person_id = p_person_id
36: AND SYSDATE BETWEEN effective_start_date
37: AND effective_end_date ;
38:

Line 1053: per_all_people_f ppf

1049: TRUNC(stop_time),
1050: full_name,
1051: NVL(employee_number,npw_number)
1052: FROM hxc_time_building_blocks tc,
1053: per_all_people_f ppf
1054: WHERE tc.time_building_block_id = p_timecard_id
1055: AND tc.resource_id = ppf.person_id
1056: AND SYSDATE BETWEEN ppf.effective_start_date
1057: AND ppf.effective_end_date

Line 1121: per_all_people_f ppf

1117: TRUNC(stop_time),
1118: full_name,
1119: NVL(employee_number,npw_number)
1120: FROM hxc_time_building_blocks tc,
1121: per_all_people_f ppf
1122: WHERE tc.time_building_block_id = p_timecard_id
1123: AND tc.resource_id = ppf.person_id
1124: AND SYSDATE BETWEEN ppf.effective_start_date
1125: AND ppf.effective_end_date;