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 69: FROM pay_element_types_f

65: ) IS
66: -- Get element_template_id
67: CURSOR get_element_type_id (l_element_name VARCHAR2) IS
68: SELECT element_type_id
69: FROM pay_element_types_f
70: WHERE UPPER (element_name) = UPPER (l_element_name)
71: AND business_group_id IS NULL
72: AND legislation_code = 'US';
73:

Line 164: FROM pay_element_types_f

160:
161: begin
162: SELECT element_type_id
163: INTO l_eletype_id
164: FROM pay_element_types_f
165: WHERE UPPER(element_name) = UPPER(p_element_name)
166: AND business_group_id IS NULL
167: AND legislation_code = 'US';
168:

Line 175: update pay_element_types_f

171: hr_utility.set_location('No Element Found',99);
172:
173: end;
174:
175: update pay_element_types_f
176: set RECALC_EVENT_GROUP_ID = p_event_group_id
177: where element_type_id = l_eletype_id
178: and business_group_id is null
179: and legislation_code = 'US';

Line 210: FROM pay_element_types_f

206: hr_utility.set_location('Primary Balance : '||p_balance_name,5);
207: begin
208: SELECT element_type_id
209: INTO v_eletype_id
210: FROM pay_element_types_f
211: WHERE UPPER(element_name) = UPPER(p_element_name)
212: AND business_group_id IS NULL
213: AND legislation_code = 'US';
214:

Line 232: update pay_element_types_f

228:
229: IF UPPER(p_association) = 'PRIMARY BALANCE' THEN
230:
231: hr_utility.set_location('pay_assoc_bal.assoc_bal',9);
232: update pay_element_types_f
233: set ELEMENT_INFORMATION10 = v_baltype_id
234: where element_type_id = v_eletype_id
235: and business_group_id is null
236: and legislation_code = 'US';

Line 241: update pay_element_types_f

237:
238: ELSIF UPPER(p_association) IN ('ACCRUED BALANCE', 'GROSS BALANCE') THEN
239:
240: hr_utility.set_location('pay_assoc_bal.assoc_bal',11);
241: update pay_element_types_f
242: set ELEMENT_INFORMATION11 = v_baltype_id
243: where element_type_id = v_eletype_id
244: and business_group_id is null
245: and legislation_code = 'US';

Line 250: update pay_element_types_f

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

Line 259: update pay_element_types_f

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

Line 268: update pay_element_types_f

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

Line 277: update pay_element_types_f

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

Line 286: update pay_element_types_f

282: --
283: ELSIF UPPER(p_association) = 'EXCESS BALANCE' THEN
284: --
285: hr_utility.set_location('pay_assoc_bal.assoc_bal',21);
286: update pay_element_types_f
287: set ELEMENT_INFORMATION16 = v_baltype_id
288: where element_type_id = v_eletype_id
289: and business_group_id is null
290: and legislation_code = 'US';

Line 295: update pay_element_types_f

291: --
292: ELSIF UPPER(p_association) = 'TAXABLE BALANCE' THEN
293: --
294: hr_utility.set_location('pay_assoc_bal.assoc_bal',23);
295: update pay_element_types_f
296: set ELEMENT_INFORMATION17 = v_baltype_id
297: where element_type_id = v_eletype_id
298: and business_group_id is null
299: and legislation_code = 'US';

Line 304: update pay_element_types_f

300: --
301: ELSIF UPPER(p_association) = 'EXEMPT BALANCE' THEN
302: --
303: hr_utility.set_location('pay_assoc_bal.assoc_bal',25);
304: update pay_element_types_f
305: set ELEMENT_INFORMATION18 = v_baltype_id
306: where element_type_id = v_eletype_id
307: and business_group_id is null
308: and legislation_code = 'US';

Line 313: update pay_element_types_f

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

Line 322: update pay_element_types_f

318: --
319: ELSIF UPPER(p_association) = 'WITHHELD BALANCE' THEN
320: --
321: hr_utility.set_location('pay_assoc_bal.assoc_bal',29);
322: update pay_element_types_f
323: set ELEMENT_INFORMATION20 = v_baltype_id
324: where element_type_id = v_eletype_id
325: and business_group_id is null
326: and legislation_code = 'US';