DBA Data[Home] [Help]

APPS.HR_CANVAS_PROPERTIES_BSI dependencies on HR_TEMPLATE_CANVASES

Line 574: FROM hr_template_canvases tcn

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

Line 834: FROM hr_template_canvases tcn

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

Line 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

Line 880: , hr_template_canvases_b htc

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;