DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_TC_AP_LINKS

Line 4309: FROM hxc_tc_ap_links links

4305: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4306: )
4307: IS
4308: SELECT timecards.comment_text
4309: FROM hxc_tc_ap_links links
4310: ,hxc_time_building_blocks timecards
4311: WHERE links.application_period_id = p_app_period_id
4312: AND links.timecard_id = timecards.time_building_block_id
4313: AND timecards.date_to = hr_general.end_of_time;

Line 4596: hxc_tc_ap_links hal

4592: ,details.translation_display_key
4593: from hxc_time_building_blocks timecard,
4594: hxc_time_building_blocks details,
4595: hxc_time_building_blocks days,
4596: hxc_tc_ap_links hal
4597: where
4598: days.time_building_block_id = details.parent_building_block_id
4599: and days.object_version_number = details.parent_building_block_ovn
4600: and hal.APPLICATION_PERIOD_ID = p_app_period_id

Line 5530: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts

5526: IS
5527: SELECT tal.application_period_id,
5528: ts.start_time,
5529: ts.stop_time
5530: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts
5531: WHERE ts.timecard_id = p_timecard_id
5532: and ts.timecard_id = tal.timecard_id;
5533:
5534: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;