[Home] [Help]
3022: RETURN l_assignment_last_eff_dt;
3023: END assignment_last_eff_dt;
3024:
3025: FUNCTION evaluation_date (
3026: p_resource_id hxc_time_building_blocks.resource_id%TYPE,
3027: p_evaluation_date DATE
3028: )
3029: RETURN DATE
3030: IS
3509:
3510:
3511:
3512: Cursor get_tc_start_stop( p_resource_id IN NUMBER, l_detail_building_block_id IN NUMBER, detail_builiding_block_ovn IN NUMBER) is
3513: select START_TIME, STOP_TIME, DATE_TO from hxc_time_building_blocks t
3514: where scope = 'TIMECARD' AND
3515: resource_id =p_resource_id
3516: connect by prior parent_building_block_id = time_building_block_id
3517: and prior parent_building_block_ovn = object_version_number
3669: stop_time
3670: ORDER BY date_to DESC,
3671: time_building_block_id DESC,
3672: object_version_number DESC ) rank
3673: FROM hxc_time_building_blocks
3674: WHERE resource_id = p_resource_id
3675: AND scope = 'TIMECARD'
3676: AND TRUNC(start_time) BETWEEN p_start_evaluation_date
3677: AND p_end_evaluation_date
3758: BEGIN
3759: -- Public Procedure get_tc_resp
3760: -- Takes in the resource_id for whom the process is executed
3761: -- and the evaluation start and end dates.
3762: -- Get the valid time periods from hxc_time_building_blocks
3763: -- table falling within the given start and end dates for
3764: -- evaluation. Need to consider only those periods which
3765: -- fall within the given range, not the ones crossing over
3766: -- the boundaries, because Persistent responsibility can