DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_TC_AP_LINKS

Line 3973: FROM hxc_tc_ap_links links

3969: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3970: )
3971: IS
3972: SELECT timecards.comment_text
3973: FROM hxc_tc_ap_links links
3974: ,hxc_time_building_blocks timecards
3975: WHERE links.application_period_id = p_app_period_id
3976: AND links.timecard_id = timecards.time_building_block_id
3977: AND timecards.date_to = hr_general.end_of_time;

Line 4260: hxc_tc_ap_links hal

4256: ,details.translation_display_key
4257: from hxc_time_building_blocks timecard,
4258: hxc_time_building_blocks details,
4259: hxc_time_building_blocks days,
4260: hxc_tc_ap_links hal
4261: where
4262: days.time_building_block_id = details.parent_building_block_id
4263: and days.object_version_number = details.parent_building_block_ovn
4264: and hal.APPLICATION_PERIOD_ID = p_app_period_id

Line 5111: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts

5107: IS
5108: SELECT tal.application_period_id,
5109: ts.start_time,
5110: ts.stop_time
5111: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts
5112: WHERE ts.timecard_id = p_timecard_id
5113: and ts.timecard_id = tal.timecard_id;
5114:
5115: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;