570:
571: CURSOR cur_check
572: IS
573: SELECT 1
574: FROM hr_template_canvases tcn
575: WHERE tcn.template_canvas_id = p_template_canvas_id
576: AND tcn.form_canvas_id = p_form_canvas_id;
577:
578: -- added a outer join so that the correct values are returned
830:
831: CURSOR cur_check
832: IS
833: SELECT tcn.form_canvas_id
834: FROM hr_template_canvases tcn
835: WHERE tcn.template_canvas_id = p_template_canvas_id_from
836: INTERSECT
837: SELECT tcn.form_canvas_id
838: FROM hr_template_canvases tcn
834: FROM hr_template_canvases tcn
835: WHERE tcn.template_canvas_id = p_template_canvas_id_from
836: INTERSECT
837: SELECT tcn.form_canvas_id
838: FROM hr_template_canvases tcn
839: WHERE tcn.template_canvas_id = p_template_canvas_id_to;
840:
841: CURSOR cur_can_prop
842: IS
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
879: FROM hr_canvas_properties cnp
880: , hr_template_canvases_b htc
881: WHERE cnp.template_canvas_id (+) = htc.template_canvas_id
882: and htc.template_canvas_id = p_template_canvas_id_from;
883:
884: l_check number;