APPS.HR_TAB_PAGE_PROPERTIES_PKG dependencies on HR_TEMPLATE_WINDOWS_B

Line 58: ,HR_TEMPLATE_WINDOWS_B twn

54: select tpp.tab_page_property_id
55: from HR_TAB_PAGE_PROPERTIES_B tpp
56: ,HR_TEMPLATE_TAB_PAGES_B ttp
57: ,HR_TEMPLATE_CANVASES_B tcn
58: ,HR_TEMPLATE_WINDOWS_B twn
59: ,HR_TEMPLATE_TAB_PAGES_B tto
60: where tpp.TEMPLATE_TAB_PAGE_ID = ttp.TEMPLATE_TAB_PAGE_ID
61: and ttp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID
62: and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID

Line 66: from HR_TEMPLATE_WINDOWS_B 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_B tw1
67: ,HR_TEMPLATE_CANVASES_B tc1
68: where tw1.TEMPLATE_WINDOW_ID = tc1.TEMPLATE_WINDOW_ID
69: and tc1.TEMPLATE_CANVAS_ID = tto.TEMPLATE_CANVAS_ID)
70: connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO)

Line 836: ,hr_template_windows_b htw

832:
833: select htc.template_canvas_id
834: into x_template_canvas_id
835: from hr_template_canvases_b htc
836: ,hr_template_windows_b htw
837: , hr_form_templates hft
838: where htc.form_canvas_id = x_form_canvas_id
839: and htc.template_window_id = htw.template_window_id
840: and htw.form_window_id = x_form_window_id

Line 1009: ,hr_template_windows_b htw

1005:
1006: select htc.template_canvas_id
1007: into x_template_canvas_id
1008: from hr_template_canvases_b htc
1009: ,hr_template_windows_b htw
1010: , hr_form_templates hft
1011: where htc.form_canvas_id = x_form_canvas_id
1012: and htc.template_window_id = htw.template_window_id
1013: and htw.form_window_id = x_form_window_id