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_FORM_ITEMS_B

Line 149: FROM hr_form_items_b

145: --
146: CURSOR cur_form
147: IS
148: SELECT form_id
149: FROM hr_form_items_b
150: WHERE form_item_id = p_form_item_id
151: AND p_form_item_id is not null
152: AND p_template_item_id is null
153: AND p_template_item_context_id is null

Line 157: , hr_form_items_b hfi

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
161: AND p_form_item_id is null

Line 167: , hr_form_items_b hfi

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
171: AND p_template_item_context_id is not null

Line 178: FROM hr_form_items_b

174:
175: CURSOR cur_item(l_item_id number)
176: IS
177: SELECT form_id
178: FROM hr_form_items_b
179: WHERE form_item_id = l_item_id;
180:
181: l_form_id number(15);
182: l_prev_form_id number(15);

Line 305: from hr_form_items_b fim

301: -- Declare cursors
302: --
303: cursor csr_form_item is
304: select fim.item_type
305: from hr_form_items_b fim
306: where fim.form_item_id = p_form_item_id;
307: --
308: cursor csr_template_item is
309: select fim.item_type

Line 310: from hr_form_items_b fim

306: where fim.form_item_id = p_form_item_id;
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: --

Line 317: from hr_form_items_b fim

313: and tim.template_item_id = p_template_item_id;
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