[Home] [Help]
125: --and date_to = hr_general.end_of_time;
126:
127: cursor c_app_period_detail (p_app_period_id number) is
128: select time_building_block_id, time_building_block_ovn
129: from hxc_ap_detail_links
130: where application_period_id = p_app_period_id;
131:
132:
133: --l_tc_resource_id NUMBER;
511:
512:
513: cursor c_app_period_detail (p_app_period_id number) is
514: select time_building_block_id, time_building_block_ovn
515: from hxc_ap_detail_links
516: where application_period_id = p_app_period_id;
517:
518: cursor c_resource_period_lock (p_resource_id number) is
519: select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
1040: --and date_to = hr_general.end_of_time;
1041:
1042: cursor c_app_period_detail (p_app_period_id number) is
1043: select time_building_block_id, time_building_block_ovn
1044: from hxc_ap_detail_links
1045: where application_period_id = p_app_period_id;
1046:
1047:
1048: l_locker_type_req_id NUMBER;