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.PAY_ASSOC_BAL dependencies on PAY_ELEMENT_TYPES_F

Line 74: FROM pay_element_types_f

70: ) IS
71: -- Get element_template_id
72: CURSOR get_element_type_id (l_element_name VARCHAR2) IS
73: SELECT element_type_id
74: FROM pay_element_types_f
75: WHERE UPPER (element_name) = UPPER (l_element_name)
76: AND business_group_id IS NULL
77: AND legislation_code = 'US';
78:

Line 169: FROM pay_element_types_f

165:
166: begin
167: SELECT element_type_id
168: INTO l_eletype_id
169: FROM pay_element_types_f
170: WHERE UPPER(element_name) = UPPER(p_element_name)
171: AND business_group_id IS NULL
172: AND legislation_code = 'US';
173:

Line 180: update pay_element_types_f

176: hr_utility.set_location('No Element Found',99);
177:
178: end;
179:
180: update pay_element_types_f
181: set RECALC_EVENT_GROUP_ID = p_event_group_id
182: where element_type_id = l_eletype_id
183: and business_group_id is null
184: and legislation_code = 'US';

Line 215: FROM pay_element_types_f

211: hr_utility.set_location('Primary Balance : '||p_balance_name,5);
212: begin
213: SELECT element_type_id
214: INTO v_eletype_id
215: FROM pay_element_types_f
216: WHERE UPPER(element_name) = UPPER(p_element_name)
217: AND business_group_id IS NULL
218: AND legislation_code = 'US';
219:

Line 237: update pay_element_types_f

233:
234: IF UPPER(p_association) = 'PRIMARY BALANCE' THEN
235:
236: hr_utility.set_location('pay_assoc_bal.assoc_bal',9);
237: update pay_element_types_f
238: set ELEMENT_INFORMATION10 = v_baltype_id
239: where element_type_id = v_eletype_id
240: and business_group_id is null
241: and legislation_code = 'US';

Line 246: update pay_element_types_f

242:
243: ELSIF UPPER(p_association) IN ('ACCRUED BALANCE', 'GROSS BALANCE') THEN
244:
245: hr_utility.set_location('pay_assoc_bal.assoc_bal',11);
246: update pay_element_types_f
247: set ELEMENT_INFORMATION11 = v_baltype_id
248: where element_type_id = v_eletype_id
249: and business_group_id is null
250: and legislation_code = 'US';

Line 255: update pay_element_types_f

251:
252: ELSIF UPPER(p_association) IN ('ARREARS BALANCE', 'SUBJECT BALANCE', 'HOURS BALANCE') THEN
253:
254: hr_utility.set_location('pay_assoc_bal.assoc_bal',13);
255: update pay_element_types_f
256: set ELEMENT_INFORMATION12 = v_baltype_id
257: where element_type_id = v_eletype_id
258: and business_group_id is null
259: and legislation_code = 'US';

Line 264: update pay_element_types_f

260: --
261: ELSIF UPPER(p_association) IN ('NOT TAKEN BALANCE', 'PRETAX BALANCE') THEN
262: --
263: hr_utility.set_location('pay_assoc_bal.assoc_bal',15);
264: update pay_element_types_f
265: set ELEMENT_INFORMATION13 = v_baltype_id
266: where element_type_id = v_eletype_id
267: and business_group_id is null
268: and legislation_code = 'US';

Line 273: update pay_element_types_f

269: --
270: ELSIF UPPER(p_association) IN ('TOWARD BOND PURCHASE', 'SUBJECT WHABLE') THEN
271: --
272: hr_utility.set_location('pay_assoc_bal.assoc_bal',17);
273: update pay_element_types_f
274: set ELEMENT_INFORMATION14 = v_baltype_id
275: where element_type_id = v_eletype_id
276: and business_group_id is null
277: and legislation_code = 'US';

Line 282: update pay_element_types_f

278: --
279: ELSIF UPPER(p_association) IN ('ABLE BALANCE', 'SUBJECT NOT WHABLE') THEN
280: --
281: hr_utility.set_location('pay_assoc_bal.assoc_bal',19);
282: update pay_element_types_f
283: set ELEMENT_INFORMATION15 = v_baltype_id
284: where element_type_id = v_eletype_id
285: and business_group_id is null
286: and legislation_code = 'US';

Line 291: update pay_element_types_f

287: --
288: ELSIF UPPER(p_association) = 'EXCESS BALANCE' THEN
289: --
290: hr_utility.set_location('pay_assoc_bal.assoc_bal',21);
291: update pay_element_types_f
292: set ELEMENT_INFORMATION16 = v_baltype_id
293: where element_type_id = v_eletype_id
294: and business_group_id is null
295: and legislation_code = 'US';

Line 300: update pay_element_types_f

296: --
297: ELSIF UPPER(p_association) = 'TAXABLE BALANCE' THEN
298: --
299: hr_utility.set_location('pay_assoc_bal.assoc_bal',23);
300: update pay_element_types_f
301: set ELEMENT_INFORMATION17 = v_baltype_id
302: where element_type_id = v_eletype_id
303: and business_group_id is null
304: and legislation_code = 'US';

Line 309: update pay_element_types_f

305: --
306: ELSIF UPPER(p_association) = 'EXEMPT BALANCE' THEN
307: --
308: hr_utility.set_location('pay_assoc_bal.assoc_bal',25);
309: update pay_element_types_f
310: set ELEMENT_INFORMATION18 = v_baltype_id
311: where element_type_id = v_eletype_id
312: and business_group_id is null
313: and legislation_code = 'US';

Line 318: update pay_element_types_f

314: --
315: ELSIF UPPER(p_association) = 'EE OR ER CONTR BALANCE' THEN
316: --
317: hr_utility.set_location('pay_assoc_bal.assoc_bal',27);
318: update pay_element_types_f
319: set ELEMENT_INFORMATION19 = v_baltype_id
320: where element_type_id = v_eletype_id
321: and business_group_id is null
322: and legislation_code = 'US';

Line 327: update pay_element_types_f

323: --
324: ELSIF UPPER(p_association) = 'WITHHELD BALANCE' THEN
325: --
326: hr_utility.set_location('pay_assoc_bal.assoc_bal',29);
327: update pay_element_types_f
328: set ELEMENT_INFORMATION20 = v_baltype_id
329: where element_type_id = v_eletype_id
330: and business_group_id is null
331: and legislation_code = 'US';