DBA Data[Home] [Help]

APPS.HR_CNP_BUS dependencies on HR_TEMPLATE_CANVASES_B

Line 61: ,hr_template_canvases_b tcn

57: cursor csr_leg_code is
58: select tmp.legislation_code
59: from hr_form_templates_b tmp
60: ,hr_template_windows_b twn
61: ,hr_template_canvases_b tcn
62: ,hr_canvas_properties cnp
63: where tmp.form_template_id = twn.form_template_id
64: and twn.template_window_id = tcn.template_window_id
65: and tcn.template_canvas_id = cnp.template_canvas_id

Line 162: ,hr_template_canvases_b tcn

158: --
159: cursor csr_template_canvas is
160: select fcn.canvas_type
161: from hr_form_canvases_b fcn
162: ,hr_template_canvases_b tcn
163: where fcn.form_canvas_id = tcn.form_canvas_id
164: and tcn.template_canvas_id = p_template_canvas_id;
165: --
166: -- Declare local variables

Line 847: ,hr_template_canvases_b tcn

843: select nvl(twn.height,fwn.height)
844: ,nvl(twn.width,fwn.width)
845: from hr_form_windows fwn
846: ,hr_template_windows twn
847: ,hr_template_canvases_b tcn
848: where fwn.form_window_id = twn.form_window_id
849: and twn.template_window_id = tcn.template_window_id
850: and tcn.template_canvas_id = p_rec.template_canvas_id;
851: --