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;