638:
639: CURSOR cur_check
640: IS
641: SELECT 1
642: FROM hr_template_windows twn
643: WHERE twn.template_window_id = p_template_window_id
644: AND twn.form_window_id = p_form_window_id;
645:
646: CURSOR cur_win_tl
949:
950: CURSOR cur_check
951: IS
952: SELECT twn.form_window_id
953: FROM hr_template_windows twn
954: WHERE twn.template_window_id = p_template_window_id_from
955: INTERSECT
956: SELECT twn.form_window_id
957: FROM hr_template_windows twn
953: FROM hr_template_windows twn
954: WHERE twn.template_window_id = p_template_window_id_from
955: INTERSECT
956: SELECT twn.form_window_id
957: FROM hr_template_windows twn
958: WHERE twn.template_window_id = p_template_window_id_to;
959:
960: CURSOR cur_win_tl
961: IS