DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_API dependencies on HR_TEMPLATE_ITEM_CONTEXT_PAGES

Line 43: FROM hr_template_item_context_pages tcp

39: IS
40: SELECT tic.template_item_context_id
41: FROM hr_template_item_contexts_b tic
42: WHERE NOT EXISTS (SELECT 0
43: FROM hr_template_item_context_pages tcp
44: WHERE tcp.template_tab_page_id = p_template_tab_page_id
45: AND tcp.template_item_context_id = tic.template_item_context_id)
46: AND tic.template_item_id = p_template_item_id;
47: l_template_item_context csr_template_item_contexts%ROWTYPE;

Line 218: FROM hr_template_item_context_pages tcp

214: )
215: IS
216: SELECT tcp.template_item_context_page_id
217: ,tcp.object_version_number
218: FROM hr_template_item_context_pages tcp
219: ,hr_template_item_contexts_b tic
220: ,hr_template_item_tab_pages tip
221: WHERE tcp.template_tab_page_id = tip.template_tab_page_id
222: AND tcp.template_item_context_id = tic.template_item_context_id