DBA Data[Home] [Help]

APPS.HR_CANVAS_PROPERTIES_PKG dependencies on HR_TEMPLATE_WINDOWS

Line 59: ,HR_TEMPLATE_WINDOWS_B twn

55: cursor csr_copies is
56: select cnp.canvas_property_id
57: from HR_CANVAS_PROPERTIES cnp
58: ,HR_TEMPLATE_CANVASES_B tcn
59: ,HR_TEMPLATE_WINDOWS_B twn
60: ,HR_TEMPLATE_CANVASES_B tco
61: where cnp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID
62: and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
63: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO

Line 66: from HR_TEMPLATE_WINDOWS tw1

62: and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
63: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
64: from HR_SOURCE_FORM_TEMPLATES sft
65: start with sft.FORM_TEMPLATE_ID_FROM = (select tw1.FORM_TEMPLATE_ID
66: from HR_TEMPLATE_WINDOWS tw1
67: where tw1.TEMPLATE_WINDOW_ID = tco.TEMPLATE_WINDOW_ID)
68: connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO)
69: and tcn.FORM_CANVAS_ID = tco.FORM_CANVAS_ID
70: and tco.TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID;

Line 715: ,hr_template_windows_b htw

711:
712: select htc.template_canvas_id
713: into x_template_canvas_id
714: from hr_template_canvases_b htc
715: ,hr_template_windows_b htw
716: , hr_form_templates hft
717: where htc.form_canvas_id = x_form_canvas_id
718: and htc.template_window_id = htw.template_window_id
719: and htw.form_window_id = x_form_window_id