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_ITP_BUS dependencies on HR_TEMPLATE_ITEMS_B

Line 60: ,hr_template_items_b tim

56: --
57: cursor csr_leg_code is
58: select tmp.legislation_code
59: from hr_form_templates_b tmp
60: ,hr_template_items_b tim
61: ,hr_item_properties_b itp
62: where tmp.form_template_id = tim.form_template_id
63: and tim.template_item_id = itp.template_item_id
64: and itp.item_property_id = p_item_property_id

Line 68: ,hr_template_items_b tim

64: and itp.item_property_id = p_item_property_id
65: union
66: select tmp.legislation_code
67: from hr_form_templates_b tmp
68: ,hr_template_items_b tim
69: ,hr_template_item_contexts_b tic
70: ,hr_item_properties_b itp
71: where tmp.form_template_id = tim.form_template_id
72: and tim.template_item_id = tic.template_item_id

Line 156: FROM hr_template_items_b hti

152: AND p_template_item_id is null
153: AND p_template_item_context_id is null
154: UNION
155: SELECT form_id
156: FROM hr_template_items_b hti
157: , hr_form_items_b hfi
158: WHERE hti.template_item_id = p_template_item_id
159: AND hti.form_item_id = hfi.form_item_id
160: AND p_template_item_id is not null

Line 166: , hr_template_items_b hti

162: AND p_template_item_context_id is null
163: UNION
164: SELECT form_id
165: FROM hr_template_item_contexts_b tic
166: , hr_template_items_b hti
167: , hr_form_items_b hfi
168: WHERE tic.template_item_context_id = p_template_item_context_id
169: AND hti.template_item_id = tic.template_item_id
170: AND hti.form_item_id = hfi.form_item_id

Line 311: ,hr_template_items_b tim

307: --
308: cursor csr_template_item is
309: select fim.item_type
310: from hr_form_items_b fim
311: ,hr_template_items_b tim
312: where fim.form_item_id = tim.form_item_id
313: and tim.template_item_id = p_template_item_id;
314: --
315: cursor csr_template_item_context is

Line 318: ,hr_template_items_b tim

314: --
315: cursor csr_template_item_context is
316: select fim.item_type
317: from hr_form_items_b fim
318: ,hr_template_items_b tim
319: ,hr_template_item_contexts_b tic
320: where fim.form_item_id = tim.form_item_id
321: and tim.template_item_id = tic.template_item_id
322: and tic.template_item_context_id = p_template_item_context_id;