DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_APP_PERIOD_SUMMARY

Line 4282: FROM hxc_app_period_summary apsum

4278: SELECT hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)
4279: ,favtl.application_name
4280: ,apsum.approver_id
4281: ,apsum.time_category_id
4282: FROM hxc_app_period_summary apsum
4283: ,fnd_application_tl favtl
4284: ,hxc_time_recipients htr
4285: WHERE apsum.application_period_id = p_app_period_id
4286: AND favtl.application_id = htr.application_id

Line 4535: FROM hxc_app_period_summary

4531: p_block_id hxc_time_building_blocks.time_building_block_id%TYPE
4532: )
4533: IS
4534: SELECT 'Y'
4535: FROM hxc_app_period_summary
4536: WHERE application_period_id = p_block_id;
4537:
4538: l_result VARCHAR2(1) := NULL;
4539: BEGIN