eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ITEM_PROPERTIES_BSI dependencies on HR_TEMPLATE_ITEM_CONTEXTS

Line 79: ,hr_template_item_contexts_b tc2

75: )
76: IS
77: SELECT itp.item_property_id
78: FROM hr_item_properties_b itp
79: ,hr_template_item_contexts_b tc2
80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
83: ,hr_template_items_b ti1

Line 84: ,hr_template_item_contexts_b tc1

80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
83: ,hr_template_items_b ti1
84: ,hr_template_item_contexts_b tc1
85: WHERE itp.template_item_context_id = tc2.template_item_context_id
86: AND tc2.item_context_id = tc1.item_context_id
87: AND tc2.template_item_id = ti2.template_item_id
88: AND ti2.form_template_id = ti1.form_template_id

Line 1595: FROM hr_template_item_contexts tic

1591:
1592: CURSOR cur_check
1593: IS
1594: SELECT 1
1595: FROM hr_template_item_contexts tic
1596: WHERE tic.template_item_context_id = p_template_item_context_id
1597: AND tic.template_item_id = p_template_item_id;
1598:
1599: -- added a outer join so that the correct values are returned

Line 2601: FROM hr_template_item_contexts tic

2597:
2598: CURSOR cur_check
2599: IS
2600: SELECT tiw.form_item_id
2601: FROM hr_template_item_contexts tic
2602: , hr_template_items_b tiw
2603: WHERE tic.template_item_id = tiw.template_item_id
2604: AND tic.template_item_context_id = p_template_item_context_id_frm
2605: INTERSECT

Line 2607: FROM hr_template_item_contexts tic

2603: WHERE tic.template_item_id = tiw.template_item_id
2604: AND tic.template_item_context_id = p_template_item_context_id_frm
2605: INTERSECT
2606: SELECT tiw.form_item_id
2607: FROM hr_template_item_contexts tic
2608: , hr_template_items_b tiw
2609: WHERE tic.template_item_id = tiw.template_item_id
2610: AND tic.template_item_context_id = p_template_item_context_id_to;
2611:

Line 2680: , hr_template_item_contexts_b tic

2676: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
2677: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
2678: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
2679: FROM hr_item_properties_b itp
2680: , hr_template_item_contexts_b tic
2681: WHERE itp.template_item_context_id = tic.template_item_context_id
2682: AND tic.template_item_context_id = p_template_item_context_id_frm;
2683:
2684: CURSOR cur_item_tl