APPS.HR_TAB_PAGE_PROPERTIES_PKG dependencies on HR_TEMPLATE_TAB_PAGES

Line 56: ,HR_TEMPLATE_TAB_PAGES_B ttp

52: l_original csr_original%rowtype;
53: cursor csr_copies is
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

Line 59: ,HR_TEMPLATE_TAB_PAGES_B tto

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
63: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO

Line 220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
221: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
222: ),
223: p_ref_type => 'INS');
224:

Line 851: from hr_template_tab_pages

847:
848:
849: select template_tab_page_id
850: into x_template_tab_page_id
851: from hr_template_tab_pages
852: where template_canvas_id = x_template_canvas_id
853: and form_tab_page_id = x_form_tab_page_id;
854:
855: x_form_tab_page_id := null;

Line 1023: from hr_template_tab_pages

1019: and hft.template_name = x_template_name;
1020:
1021: select template_tab_page_id
1022: into x_template_tab_page_id
1023: from hr_template_tab_pages
1024: where template_canvas_id = x_template_canvas_id
1025: and form_tab_page_id = x_form_tab_page_id;
1026:
1027: x_form_tab_page_id := null;