DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_APPLICATION_SET_COMPS_V

Line 204: FROM hxc_application_set_comps_v hasc

200: AND details.parent_building_block_id = days.time_building_block_id
201: AND details.parent_building_block_ovn = days.object_version_number
202: AND details.date_to = hr_general.end_of_time
203: AND EXISTS ( SELECT 1
204: FROM hxc_application_set_comps_v hasc
205: WHERE hasc.application_set_id = details.application_set_id
206: AND hasc.time_recipient_id = p_time_recipient_id) ;
207:
208:

Line 2895: hxc_application_set_comps_v hasc,

2891: htr.application_id,
2892: htr.application_period_function,
2893: htr.time_recipient_id
2894: from hxc_application_sets_v has,
2895: hxc_application_set_comps_v hasc,
2896: hxc_time_recipients htr
2897: where to_char(has.application_set_id) = p_app_set
2898: and hasc.application_set_id = has.application_set_id
2899: and hasc.time_recipient_id = htr.time_recipient_id;