DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_APP_PERIOD_SUMMARY

Line 4618: FROM hxc_app_period_summary apsum

4614: SELECT hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)
4615: ,favtl.application_name
4616: ,apsum.approver_id
4617: ,apsum.time_category_id
4618: FROM hxc_app_period_summary apsum
4619: ,fnd_application_tl favtl
4620: ,hxc_time_recipients htr
4621: WHERE apsum.application_period_id = p_app_period_id
4622: AND favtl.application_id = htr.application_id

Line 4871: FROM hxc_app_period_summary

4867: p_block_id hxc_time_building_blocks.time_building_block_id%TYPE
4868: )
4869: IS
4870: SELECT 'Y'
4871: FROM hxc_app_period_summary
4872: WHERE application_period_id = p_block_id;
4873:
4874: l_result VARCHAR2(1) := NULL;
4875: BEGIN