DBA Data[Home] [Help]

APPS.HXC_PREFERENCE_EVALUATION dependencies on HXC_TIMECARD_SUMMARY

Line 3419: from HXC_TIME_ATTRIBUTES ta, HXC_TIME_ATTRIBUTE_USAGES tau, hxc_latest_details ld, hxc_timecard_summary tbd

3415: RETURN NUMBER
3416: IS
3417: cursor get_resp_id(p_resource_id IN NUMBER, p_evaluation_date IN DATE) is
3418: SELECT ta.attribute4 , ta.attribute3
3419: from HXC_TIME_ATTRIBUTES ta, HXC_TIME_ATTRIBUTE_USAGES tau, hxc_latest_details ld, hxc_timecard_summary tbd
3420: where ta.time_attribute_id = tau.time_attribute_id
3421: and tau.time_building_block_id = ld.time_building_block_id
3422: and tau.time_building_block_ovn = ld.object_version_number
3423: and ld.resource_id = p_resource_id