DBA Data[Home] [Help]

APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_TIME_BUILDING_BLOCKS

Line 1052: FROM hxc_time_building_blocks tc,

1048: start_time,
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

Line 1120: FROM hxc_time_building_blocks tc,

1116: start_time,
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

Line 1512: hxc_time_building_blocks htb

1508: IS SELECT NVL(htb.measure,(htb.stop_time-htb.start_time)*24),
1509: htb.time_building_block_id,
1510: htb.application_set_id
1511: FROM hxc_pay_latest_details hld,
1512: hxc_time_building_blocks htb
1513: WHERE hld.timecard_id = p_timecard_id
1514: AND htb.time_building_block_id = hld.time_building_block_id
1515: AND htb.object_version_number = hld.object_version_number;
1516: