DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_API dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B

Line 41: FROM hr_template_item_contexts_b tic

37: ,p_template_tab_page_id IN NUMBER
38: )
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)

Line 219: ,hr_template_item_contexts_b tic

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
223: AND tic.template_item_id = tip.template_item_id