[Home] [Help]
PACKAGE BODY: APPS.PAY_ASSOC_BAL
Source
1 package body pay_assoc_bal as
2 /* $Header: pyascbal.pkb 120.0 2005/05/29 03:00:41 appldev noship $ */
3 --
4 /*
5 --
6 -- Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
7 /*
8 PRODUCT
9 Oracle*Payroll
10 --
11 NAME
12 pyascbal.pkb - procedures for associating STU balances with STU element
13 types.
14 --
15 MODIFED
16 27-OCT-94 HPARICHA Created.
17 28-NOV-94 HPARICHA Primary balances for Tax Deductions are
18 the same as Withheld balances - we'll do
19 away with the Withheld Balance DDF seg.
20 30-NOV-94 HPARICHA Added "City HT Withheld" as Primary balance
21 for CITY_HT_WK and "City SC Withheld" as
22 Primary bal for CITY_SC_WK.
23 05-DEC-94 HPARICHA Associated primary balance for 'Workers
24 Compensation' STU ele.
25 07-DEC-94 HPARICHA Added "Not Taken" assoc bals for STU garns.
26 Added "Subject and Withholdable" assoc bals
27 for STU tax dedns.
28 19-JAN-95 HPARICHA Added "Hours" associated balances (G1565).
29 30-JUN-95 HPARICHA Changed "..ER Withheld" bal names to
30 "..ER Liability".
31 28-Jun-01 VMEHTA Changed Primary hours balance for
32 Regular Salary and Regular Wages to
33 Regular Salary Hours and Regular Wages
34 Hours respectively from Regular Hours Worked.
35 10-Dec-04 Fusman Added retro_element Procedure to update
36 all the seeded US earnings with the default
37 event group.
38 29-Apr-05 rdhingra Added procedure map_time_definition to stamp
39 PAY_US_TIME_DEFINITIONS value set id onto
40 the information element.
41 10-may-05 djoshi 115.6 Modified sql to get the event group.
42 for 'Entry Changes' event we need to
43 look if Core event Group exist
44 and for Regular Earnings' we
45 need to make sure we have US
46 event. Added legislation_code = null
47 and Business Group id = NUll for
48 core and Added legislation = 'US'
49 for Regular Earnings' event.
50
51
52 --
53 DESCRIPTION
54
55 This is a post install step to be run when the installation of startup
56 elements and balances has occurred.
57 Select installed balance and element type ids BY NAME; associate balances
58 with elements as approp.
59 */
60 ---
61 PROCEDURE map_time_definition (
62 p_element_name IN VARCHAR2,
63 p_input_value_name IN VARCHAR2,
64 p_flex_value_set_name IN VARCHAR2
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
74 -- Get input_value_id
75 CURSOR get_input_value_id (
76 l_input_value_name VARCHAR2,
77 l_element_type_id NUMBER
78 ) IS
79 SELECT input_value_id
80 FROM pay_input_values_f
81 WHERE element_type_id = l_element_type_id
82 AND UPPER (NAME) = UPPER (l_input_value_name)
83 AND business_group_id IS NULL
84 AND legislation_code = 'US';
85
86 -- Get flex_value_set_id
87 CURSOR get_flex_value_set_id (l_flex_value_set_name VARCHAR2) IS
88 SELECT flex_value_set_id
89 FROM fnd_flex_value_sets
90 WHERE validation_type = 'F'
91 AND UPPER (flex_value_set_name) = UPPER (l_flex_value_set_name);
92
93 l_eletype_id NUMBER;
94 l_input_value_id NUMBER;
95 l_flex_value_set_id NUMBER;
96 BEGIN
97 l_eletype_id := NULL;
98 l_input_value_id := NULL;
99 l_flex_value_set_id := NULL;
100
101 -- Get Element type id
102 OPEN get_element_type_id (p_element_name);
103
104 FETCH get_element_type_id
105 INTO l_eletype_id;
106
107 IF (get_element_type_id%FOUND) AND (l_eletype_id IS NOT NULL) THEN
108
109 -- Get Input value id
110 OPEN get_input_value_id (p_input_value_name, l_eletype_id);
111
112 FETCH get_input_value_id
113 INTO l_input_value_id;
114
115 IF (get_input_value_id%FOUND) AND (l_input_value_id IS NOT NULL) THEN
116
117 -- Get value set id
118 OPEN get_flex_value_set_id (p_flex_value_set_name);
119
120 FETCH get_flex_value_set_id
121 INTO l_flex_value_set_id;
122
123 IF (get_flex_value_set_id%FOUND)
124 AND (l_flex_value_set_id IS NOT NULL) THEN
125
126 -- Stamp value set in input value of FLSA Time Definition element
127 UPDATE pay_input_values_f
128 SET value_set_id = l_flex_value_set_id
129 WHERE input_value_id = l_input_value_id
130 AND business_group_id IS NULL
131 AND legislation_code = 'US';
132
133 ELSE
134 NULL;
135 END IF;
136
137 CLOSE get_flex_value_set_id;
138 ELSE
139 NULL;
140 END IF;
141
142 CLOSE get_input_value_id;
143 --
144 ELSE
145 -- hr_utility.trace(p_element_name ||' element does not exist');
146 NULL;
147 END IF;
148
149 CLOSE get_element_type_id;
150
151 END map_time_definition;
152
153 ---
154 PROCEDURE retro_element(p_element_name in varchar2,
155 p_event_group_id in number) IS
156
157 l_eletype_id NUMBER(9);
158
159 Begin
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
169 exception
170 when no_data_found then
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';
180
181 EXCEPTION
182 --
183 WHEN NO_DATA_FOUND THEN
184 hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);
185 --
186 WHEN TOO_MANY_ROWS THEN
187 hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);
188 --
189
190 end;
191 --
192 PROCEDURE assoc_bal( p_element_name in varchar2,
193 p_balance_name in varchar2,
194 p_association in varchar2) IS
195 --
196 -- Associates primary balances into ELEMENT_INFORMATION10 on eletype.
197 --
198 v_baltype_id NUMBER(9);
199 v_eletype_id NUMBER(9);
200 v_ddf_column VARCHAR2(20);
201
202 BEGIN
203
204 hr_utility.set_location('pay_assoc_bal.assoc_bal',1);
205 hr_utility.set_location('Element : '||p_element_name,3);
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
215 hr_utility.set_location('pay_assoc_bal.assoc_bal',7);
216 SELECT balance_type_id
217 INTO v_baltype_id
218 FROM pay_balance_types
219 WHERE UPPER(balance_name) = UPPER(p_balance_name)
220 AND business_group_id IS NULL
221 AND legislation_code = 'US';
222
223 exception
224 when no_data_found then
225 v_baltype_id := NULL;
226
227 end;
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
327 --
328 END IF;
329 --
330 EXCEPTION
331 --
332 WHEN NO_DATA_FOUND THEN
333 hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);
334 --
335 WHEN TOO_MANY_ROWS THEN
336 hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);
337 --
338 END assoc_bal;
339
340 --
341 -- MAIN
342 --
343 procedure create_associated_balances is
344 --
345 l_entry_change_evnt_grp_id Number(15);
346 l_reg_ear_evnt_grp_id Number(15);
347
348 BEGIN
349 --
350 assoc_bal( p_element_name => 'Child Support',
351 p_balance_name => 'Child Support',
352 p_association => 'PRIMARY BALANCE');
353 --
354 assoc_bal( p_element_name => 'Company Car',
355 p_balance_name => 'Company Car',
356 p_association => 'PRIMARY BALANCE');
357 --
358 assoc_bal( p_element_name => 'Creditor Garnishment',
359 p_balance_name => 'Creditor Garnishment',
360 p_association => 'PRIMARY BALANCE');
361 --
362 assoc_bal( p_element_name => 'Federal Tax Levies',
363 p_balance_name => 'Federal Tax Levies',
364 p_association => 'PRIMARY BALANCE');
365 --
366 assoc_bal( p_element_name => 'GTL EE Contribution',
367 p_balance_name => 'GTL EE Contribution',
368 p_association => 'PRIMARY BALANCE');
369 --
370 assoc_bal( p_element_name => 'GTL Imputed Income',
371 p_balance_name => 'GTL Imputed Income',
372 p_association => 'PRIMARY BALANCE');
373 --
374 assoc_bal( p_element_name => 'Labor Recording',
375 p_balance_name => 'Labor Recording',
376 p_association => 'PRIMARY BALANCE');
377 --
378 assoc_bal( p_element_name => 'Local Tax Levies',
379 p_balance_name => 'Local Tax Levies',
380 p_association => 'PRIMARY BALANCE');
381 --
382 assoc_bal( p_element_name => 'Overtime',
383 p_balance_name => 'Overtime',
384 p_association => 'PRIMARY BALANCE');
385 --
386 assoc_bal( p_element_name => 'Regular Salary',
387 p_balance_name => 'Regular Salary',
388 p_association => 'PRIMARY BALANCE');
389 --
390 assoc_bal( p_element_name => 'Regular Wages',
391 p_balance_name => 'Regular Wages',
392 p_association => 'PRIMARY BALANCE');
393 --
394 assoc_bal( p_element_name => 'Shift Pay',
395 p_balance_name => 'Shift Pay',
396 p_association => 'PRIMARY BALANCE');
397 --
398 assoc_bal( p_element_name => 'State Tax Levies',
399 p_balance_name => 'State Tax Levies',
400 p_association => 'PRIMARY BALANCE');
401 --
402 assoc_bal( p_element_name => 'Straight Time Overtime',
403 p_balance_name => 'Straight Time Overtime',
404 p_association => 'PRIMARY BALANCE');
405 --
406 assoc_bal( p_element_name => 'Time Entry Wages',
407 p_balance_name => 'Time Entry Wages',
408 p_association => 'PRIMARY BALANCE');
409 --
410 assoc_bal( p_element_name => 'Workers Compensation',
411 p_balance_name => 'Workers Compensation',
412 p_association => 'PRIMARY BALANCE');
413 --
414 assoc_bal( p_element_name => 'Vacation Pay',
415 p_balance_name => 'Vacation Pay',
416 p_association => 'PRIMARY BALANCE');
417 --
418 assoc_bal( p_element_name => 'Sick Pay',
419 p_balance_name => 'Sick Pay',
420 p_association => 'PRIMARY BALANCE');
421 --
422 assoc_bal( p_element_name => 'Regular Salary',
423 p_balance_name => 'Regular Salary Hours',
424 p_association => 'HOURS BALANCE');
425 --
426 assoc_bal( p_element_name => 'Regular Wages',
427 p_balance_name => 'Regular Wages Hours',
428 p_association => 'HOURS BALANCE');
429 --
430 assoc_bal( p_element_name => 'Vacation Pay',
431 p_balance_name => 'Vacation Hours',
432 p_association => 'HOURS BALANCE');
433 --
434 assoc_bal( p_element_name => 'Sick Pay',
435 p_balance_name => 'Sick Hours',
436 p_association => 'HOURS BALANCE');
437 --
438 assoc_bal( p_element_name => 'Overtime',
439 p_balance_name => 'Overtime Hours',
440 p_association => 'HOURS BALANCE');
441 --
445 --
442 assoc_bal( p_element_name => 'Shift Pay',
443 p_balance_name => 'Shift Hours',
444 p_association => 'HOURS BALANCE');
446 assoc_bal( p_element_name => 'Time Entry Wages',
447 p_balance_name => 'Time Entry Hours',
448 p_association => 'HOURS BALANCE');
449 --
450 assoc_bal( p_element_name => 'Child Support',
451 p_balance_name => 'Child Support Arrears',
452 p_association => 'ARREARS BALANCE');
453 --
454 assoc_bal( p_element_name => 'Creditor Garnishment',
455 p_balance_name => 'Creditor Garnishment Arrears',
456 p_association => 'ARREARS BALANCE');
457 --
458 assoc_bal( p_element_name => 'Federal Tax Levies',
459 p_balance_name => 'Federal Tax Levies Arrears',
460 p_association => 'ARREARS BALANCE');
461 --
462 assoc_bal( p_element_name => 'Local Tax Levies',
463 p_balance_name => 'Local Tax Levies Arrears',
464 p_association => 'ARREARS BALANCE');
465 --
466 assoc_bal( p_element_name => 'State Tax Levies',
467 p_balance_name => 'State Tax Levies Arrears',
468 p_association => 'ARREARS BALANCE');
469 --
470 assoc_bal( p_element_name => 'Child Support',
471 p_balance_name => 'Child Support Not Taken',
472 p_association => 'NOT TAKEN BALANCE');
473 --
474 assoc_bal( p_element_name => 'Creditor Garnishment',
475 p_balance_name => 'Creditor Garnishment Not Taken',
476 p_association => 'NOT TAKEN BALANCE');
477 --
478 assoc_bal( p_element_name => 'Federal Tax Levies',
479 p_balance_name => 'Federal Tax Levies Not Taken',
480 p_association => 'NOT TAKEN BALANCE');
481 --
482 assoc_bal( p_element_name => 'Local Tax Levies',
483 p_balance_name => 'Local Tax Levies Not Taken',
484 p_association => 'NOT TAKEN BALANCE');
485 --
486 assoc_bal( p_element_name => 'State Tax Levies',
487 p_balance_name => 'State Tax Levies Not Taken',
488 p_association => 'NOT TAKEN BALANCE');
489 --
490 assoc_bal( p_element_name => 'City_RS',
491 p_balance_name => 'Gross Earnings',
492 p_association => 'GROSS BALANCE');
493 --
494 assoc_bal( p_element_name => 'City_HT_RS',
495 p_balance_name => 'Gross Earnings',
496 p_association => 'GROSS BALANCE');
497 --
498 assoc_bal( p_element_name => 'City_SC_RS',
499 p_balance_name => 'Gross Earnings',
500 p_association => 'GROSS BALANCE');
501 --
502 assoc_bal( p_element_name => 'City_WK',
503 p_balance_name => 'Gross Earnings',
504 p_association => 'GROSS BALANCE');
505 --
506 assoc_bal( p_element_name => 'City_HT_WK',
507 p_balance_name => 'Gross Earnings',
508 p_association => 'GROSS BALANCE');
509 --
510 assoc_bal( p_element_name => 'City_SC_WK',
511 p_balance_name => 'Gross Earnings',
512 p_association => 'GROSS BALANCE');
513 --
514 assoc_bal( p_element_name => 'County_RS',
515 p_balance_name => 'Gross Earnings',
516 p_association => 'GROSS BALANCE');
517 --
518 assoc_bal( p_element_name => 'County_WK',
519 p_balance_name => 'Gross Earnings',
520 p_association => 'GROSS BALANCE');
521 --
522 assoc_bal( p_element_name => 'EIC',
523 p_balance_name => 'Gross Earnings',
524 p_association => 'GROSS BALANCE');
525 --
526 assoc_bal( p_element_name => 'FIT',
527 p_balance_name => 'Gross Earnings',
528 p_association => 'GROSS BALANCE');
529 --
530 assoc_bal( p_element_name => 'FUTA',
531 p_balance_name => 'Gross Earnings',
532 p_association => 'GROSS BALANCE');
533 --
534 assoc_bal( p_element_name => 'Medicare_EE',
535 p_balance_name => 'Gross Earnings',
536 p_association => 'GROSS BALANCE');
537 --
538 assoc_bal( p_element_name => 'SDI_EE',
539 p_balance_name => 'Gross Earnings',
540 p_association => 'GROSS BALANCE');
541 --
542 assoc_bal( p_element_name => 'SIT_RS',
543 p_balance_name => 'Gross Earnings',
544 p_association => 'GROSS BALANCE');
545 --
546 assoc_bal( p_element_name => 'SIT_WK',
547 p_balance_name => 'Gross Earnings',
548 p_association => 'GROSS BALANCE');
549 --
550 assoc_bal( p_element_name => 'SS_EE',
551 p_balance_name => 'Gross Earnings',
552 p_association => 'GROSS BALANCE');
553 --
554 assoc_bal( p_element_name => 'SUI_EE',
555 p_balance_name => 'Gross Earnings',
556 p_association => 'GROSS BALANCE');
557 --
558 assoc_bal( p_element_name => 'City_RS',
559 p_balance_name => 'City Subject',
560 p_association => 'SUBJECT BALANCE');
561 --
562 assoc_bal( p_element_name => 'City_HT_RS',
563 p_balance_name => 'City Subject',
564 p_association => 'SUBJECT BALANCE');
565 --
566 assoc_bal( p_element_name => 'City_SC_RS',
567 p_balance_name => 'City Subject',
568 p_association => 'SUBJECT BALANCE');
569 --
570 assoc_bal( p_element_name => 'City_WK',
571 p_balance_name => 'City Subject',
572 p_association => 'SUBJECT BALANCE');
573 --
574 assoc_bal( p_element_name => 'City_HT_WK',
575 p_balance_name => 'City Subject',
576 p_association => 'SUBJECT BALANCE');
577 --
578 assoc_bal( p_element_name => 'City_SC_WK',
579 p_balance_name => 'City Subject',
580 p_association => 'SUBJECT BALANCE');
581 --
582 assoc_bal( p_element_name => 'County_RS',
586 assoc_bal( p_element_name => 'County_WK',
583 p_balance_name => 'County Subject',
584 p_association => 'SUBJECT BALANCE');
585 --
587 p_balance_name => 'County Subject',
588 p_association => 'SUBJECT BALANCE');
589 --
590 assoc_bal( p_element_name => 'EIC',
591 p_balance_name => 'EIC Subject',
592 p_association => 'SUBJECT BALANCE');
593 --
594 assoc_bal( p_element_name => 'FIT',
595 p_balance_name => 'FIT Subject',
596 p_association => 'SUBJECT BALANCE');
597 --
598 assoc_bal( p_element_name => 'FUTA',
599 p_balance_name => 'FUTA Subject',
600 p_association => 'SUBJECT BALANCE');
601 --
602 assoc_bal( p_element_name => 'Medicare_EE',
603 p_balance_name => 'Medicare Subject',
604 p_association => 'SUBJECT BALANCE');
605 --
606 assoc_bal( p_element_name => 'SIT_RS',
607 p_balance_name => 'SIT Subject',
608 p_association => 'SUBJECT BALANCE');
609 --
610 assoc_bal( p_element_name => 'SIT_WK',
611 p_balance_name => 'SIT Subject',
612 p_association => 'SUBJECT BALANCE');
613 --
614 assoc_bal( p_element_name => 'SS_EE',
615 p_balance_name => 'SS Subject',
616 p_association => 'SUBJECT BALANCE');
617 --
618 assoc_bal( p_element_name => 'SUI_EE',
619 p_balance_name => 'SUI Subject',
620 p_association => 'SUBJECT BALANCE');
621 --
622 assoc_bal( p_element_name => 'City_WK',
623 p_balance_name => 'City Pretax Reductions',
624 p_association => 'PRETAX BALANCE');
625 --
626 assoc_bal( p_element_name => 'City_HT_WK',
627 p_balance_name => 'City Pretax Reductions',
628 p_association => 'PRETAX BALANCE');
629 --
630 assoc_bal( p_element_name => 'City_SC_WK',
631 p_balance_name => 'City Pretax Reductions',
632 p_association => 'PRETAX BALANCE');
633 --
634 assoc_bal( p_element_name => 'City_RS',
635 p_balance_name => 'City Pretax Reductions',
636 p_association => 'PRETAX BALANCE');
637 --
638 assoc_bal( p_element_name => 'City_HT_RS',
639 p_balance_name => 'City Pretax Reductions',
640 p_association => 'PRETAX BALANCE');
641 --
642 assoc_bal( p_element_name => 'City_SC_RS',
643 p_balance_name => 'City Pretax Reductions',
644 p_association => 'PRETAX BALANCE');
645 --
646 assoc_bal( p_element_name => 'County_RS',
647 p_balance_name => 'County Pretax Reductions',
648 p_association => 'PRETAX BALANCE');
649 --
650 assoc_bal( p_element_name => 'County_WK',
651 p_balance_name => 'County Pretax Reductions',
652 p_association => 'PRETAX BALANCE');
653 --
654 assoc_bal( p_element_name => 'FIT',
655 p_balance_name => 'FIT Pretax Reductions',
656 p_association => 'PRETAX BALANCE');
657 --
658 assoc_bal( p_element_name => 'SIT_RS',
659 p_balance_name => 'SIT Pretax Reductions',
660 p_association => 'PRETAX BALANCE');
661 --
662 assoc_bal( p_element_name => 'SIT_WK',
663 p_balance_name => 'SIT Pretax Reductions',
664 p_association => 'PRETAX BALANCE');
665 --
666 assoc_bal( p_element_name => 'City_RS',
667 p_balance_name => 'City Subject and Withholdable',
668 p_association => 'SUBJECT WHABLE');
669 --
670 assoc_bal( p_element_name => 'City_WK',
671 p_balance_name => 'City Subject and Withholdable',
672 p_association => 'SUBJECT WHABLE');
673 --
674 assoc_bal( p_element_name => 'County_RS',
675 p_balance_name => 'County Subject and Withholdable',
676 p_association => 'SUBJECT WHABLE');
677 --
678 assoc_bal( p_element_name => 'County_WK',
679 p_balance_name => 'County Subject and Withholdable',
680 p_association => 'SUBJECT WHABLE');
681 --
682 assoc_bal( p_element_name => 'FIT',
683 p_balance_name => 'FIT Subject and Withholdable',
684 p_association => 'SUBJECT WHABLE');
685 --
686 assoc_bal( p_element_name => 'FIT_Supp',
687 p_balance_name => 'FIT Subject and Withholdable',
688 p_association => 'SUBJECT WHABLE');
689 --
690 assoc_bal( p_element_name => 'FUTA',
691 p_balance_name => 'FUTA Subject and Withholdable',
692 p_association => 'SUBJECT WHABLE');
693 --
694 assoc_bal( p_element_name => 'Medicare_EE',
695 p_balance_name => 'Medicare EE Subject and Withholdable',
696 p_association => 'SUBJECT WHABLE');
697 --
698 assoc_bal( p_element_name => 'SDI_EE',
699 p_balance_name => 'SDI Subject and Withholdable',
700 p_association => 'SUBJECT WHABLE');
701 --
702 assoc_bal( p_element_name => 'SIT_RS',
703 p_balance_name => 'SIT Subject and Withholdable',
704 p_association => 'SUBJECT WHABLE');
705 --
706 assoc_bal( p_element_name => 'SIT_WK',
707 p_balance_name => 'SIT Subject and Withholdable',
708 p_association => 'SUBJECT WHABLE');
709 --
710 assoc_bal( p_element_name => 'SIT_SUPP_RS',
711 p_balance_name => 'SIT Subject and Withholdable',
712 p_association => 'SUBJECT WHABLE');
713 --
714 assoc_bal( p_element_name => 'SIT_SUPP_WK',
715 p_balance_name => 'SIT Subject and Withholdable',
716 p_association => 'SUBJECT WHABLE');
717 --
718 assoc_bal( p_element_name => 'SS_EE',
719 p_balance_name => 'SS EE Subject and Withholdable',
720 p_association => 'SUBJECT WHABLE');
721 --
722 assoc_bal( p_element_name => 'SUI_EE',
723 p_balance_name => 'SUI EE Subject and Withholdable',
724 p_association => 'SUBJECT WHABLE');
725 --
726 assoc_bal( p_element_name => 'City_RS',
727 p_balance_name => 'CITY SUBJECT NOT WITHHELD',
728 p_association => 'SUBJECT NOT WHABLE');
729 --
730 assoc_bal( p_element_name => 'City_HT_RS',
731 p_balance_name => 'CITY SUBJECT NOT WITHHELD',
732 p_association => 'SUBJECT NOT WHABLE');
733 --
734 assoc_bal( p_element_name => 'City_SC_RS',
735 p_balance_name => 'CITY SUBJECT NOT WITHHELD',
736 p_association => 'SUBJECT NOT WHABLE');
737 --
738 assoc_bal( p_element_name => 'City_WK',
739 p_balance_name => 'CITY SUBJECT NOT WITHHELD',
740 p_association => 'SUBJECT NOT WHABLE');
741 --
742 assoc_bal( p_element_name => 'City_HT_WK',
743 p_balance_name => 'CITY SUBJECT NOT WITHHELD',
744 p_association => 'SUBJECT NOT WHABLE');
745 --
746 assoc_bal( p_element_name => 'City_SC_WK',
747 p_balance_name => 'CITY SUBJECT NOT WITHHELD',
748 p_association => 'SUBJECT NOT WHABLE');
749 --
750 assoc_bal( p_element_name => 'County_RS',
751 p_balance_name => 'County Subject Not Withheld',
752 p_association => 'SUBJECT NOT WHABLE');
753 --
754 assoc_bal( p_element_name => 'County_WK',
755 p_balance_name => 'County Subject Not Withheld',
756 p_association => 'SUBJECT NOT WHABLE');
757 --
758 assoc_bal( p_element_name => 'EIC',
759 p_balance_name => 'EIC Subject Not Withheld',
760 p_association => 'SUBJECT NOT WHABLE');
761 --
762 assoc_bal( p_element_name => 'FIT',
763 p_balance_name => 'FIT Subject Not Withheld',
764 p_association => 'SUBJECT NOT WHABLE');
765 --
766 assoc_bal( p_element_name => 'FUTA',
767 p_balance_name => 'FUTA Subject Not Withholdable',
768 p_association => 'SUBJECT NOT WHABLE');
769 --
770 assoc_bal( p_element_name => 'Medicare_EE',
771 p_balance_name => 'Medicare Subject Not Withheld',
772 p_association => 'SUBJECT NOT WHABLE');
773 --
774 assoc_bal( p_element_name => 'SDI_EE',
775 p_balance_name => 'SDI Subject Not Withheld',
776 p_association => 'SUBJECT NOT WHABLE');
777 --
778 assoc_bal( p_element_name => 'SIT_RS',
779 p_balance_name => 'SIT Subject Not Withheld',
780 p_association => 'SUBJECT NOT WHABLE');
781 --
782 assoc_bal( p_element_name => 'SIT_WK',
783 p_balance_name => 'SIT Subject Not Withheld',
784 p_association => 'SUBJECT NOT WHABLE');
785 --
786 assoc_bal( p_element_name => 'SS_EE',
787 p_balance_name => 'SS Subject Not Withheld',
788 p_association => 'SUBJECT NOT WHABLE');
789 --
790 assoc_bal( p_element_name => 'SUI_EE',
791 p_balance_name => 'SUI Subject Not Withheld',
792 p_association => 'SUBJECT NOT WHABLE');
793 --
794 assoc_bal( p_element_name => 'EIC',
795 p_balance_name => 'EIC Excess',
799 p_balance_name => 'FUTA Excess',
796 p_association => 'EXCESS BALANCE');
797 --
798 assoc_bal( p_element_name => 'FUTA',
800 p_association => 'EXCESS BALANCE');
801 --
802 assoc_bal( p_element_name => 'Medicare_EE',
803 p_balance_name => 'Medicare EE Excess',
804 p_association => 'EXCESS BALANCE');
805 --
806 assoc_bal( p_element_name => 'SDI_EE',
807 p_balance_name => 'SDI EE Excess',
808 p_association => 'EXCESS BALANCE');
809 --
810 assoc_bal( p_element_name => 'SS_EE',
811 p_balance_name => 'SS EE Excess',
812 p_association => 'EXCESS BALANCE');
813 --
814 assoc_bal( p_element_name => 'SUI_EE',
815 p_balance_name => 'SUI EE Excess',
816 p_association => 'EXCESS BALANCE');
817 --
818 assoc_bal( p_element_name => 'EIC',
819 p_balance_name => 'EIC Taxable',
820 p_association => 'TAXABLE BALANCE');
821 --
822 assoc_bal( p_element_name => 'FUTA',
823 p_balance_name => 'FUTA Taxable',
824 p_association => 'TAXABLE BALANCE');
825 --
826 assoc_bal( p_element_name => 'Medicare_EE',
827 p_balance_name => 'Medicare EE Taxable',
828 p_association => 'TAXABLE BALANCE');
829 --
830 assoc_bal( p_element_name => 'SDI_EE',
831 p_balance_name => 'SDI EE Taxable',
832 p_association => 'TAXABLE BALANCE');
833 --
834 assoc_bal( p_element_name => 'SS_EE',
835 p_balance_name => 'SS EE Taxable',
836 p_association => 'TAXABLE BALANCE');
837 --
838 assoc_bal( p_element_name => 'SUI_EE',
839 p_balance_name => 'SUI EE Taxable',
840 p_association => 'TAXABLE BALANCE');
841 --
842 assoc_bal( p_element_name => 'City_RS',
843 p_balance_name => 'City Exempt',
844 p_association => 'EXEMPT BALANCE');
845 --
846 assoc_bal( p_element_name => 'City_HT_RS',
847 p_balance_name => 'City Exempt',
848 p_association => 'EXEMPT BALANCE');
849 --
850 assoc_bal( p_element_name => 'City_SC_RS',
851 p_balance_name => 'City Exempt',
852 p_association => 'EXEMPT BALANCE');
853 --
854 assoc_bal( p_element_name => 'City_WK',
855 p_balance_name => 'City Exempt',
856 p_association => 'EXEMPT BALANCE');
857 --
858 assoc_bal( p_element_name => 'City_HT_WK',
859 p_balance_name => 'City Exempt',
860 p_association => 'EXEMPT BALANCE');
861 --
862 assoc_bal( p_element_name => 'City_SC_WK',
863 p_balance_name => 'City Exempt',
864 p_association => 'EXEMPT BALANCE');
865 --
866 assoc_bal( p_element_name => 'County_WK',
867 p_balance_name => 'County Exempt',
868 p_association => 'EXEMPT BALANCE');
869 --
870 assoc_bal( p_element_name => 'County_RS',
871 p_balance_name => 'County Exempt',
872 p_association => 'EXEMPT BALANCE');
873 --
874 assoc_bal( p_element_name => 'EIC',
875 p_balance_name => 'EIC Exempt',
876 p_association => 'EXEMPT BALANCE');
877 --
878 assoc_bal( p_element_name => 'FIT',
879 p_balance_name => 'FIT Exempt',
880 p_association => 'EXEMPT BALANCE');
881 --
882 assoc_bal( p_element_name => 'FUTA',
883 p_balance_name => 'FUTA Exempt',
884 p_association => 'EXEMPT BALANCE');
885 --
886 assoc_bal( p_element_name => 'Medicare_EE',
887 p_balance_name => 'Medicare EE Exempt',
888 p_association => 'EXEMPT BALANCE');
889 --
890 assoc_bal( p_element_name => 'SDI_EE',
891 p_balance_name => 'SDI EE Exempt',
892 p_association => 'EXEMPT BALANCE');
893 --
894 assoc_bal( p_element_name => 'SIT_RS',
895 p_balance_name => 'SIT Exempt',
896 p_association => 'EXEMPT BALANCE');
897 --
898 assoc_bal( p_element_name => 'SIT_WK',
902 assoc_bal( p_element_name => 'SS_EE',
899 p_balance_name => 'SIT Exempt',
900 p_association => 'EXEMPT BALANCE');
901 --
903 p_balance_name => 'SS EE Exempt',
904 p_association => 'EXEMPT BALANCE');
905 --
906 assoc_bal( p_element_name => 'SUI_EE',
907 p_balance_name => 'SUI EE Exempt',
908 p_association => 'EXEMPT BALANCE');
909 --
910 assoc_bal( p_element_name => 'Medicare_EE',
911 p_balance_name => 'Medicare ER Liability',
912 p_association => 'EE OR ER CONTR BALANCE');
913 --
914 assoc_bal( p_element_name => 'SDI_EE',
915 p_balance_name => 'SDI ER Liability',
916 p_association => 'EE OR ER CONTR BALANCE');
917 --
918 assoc_bal( p_element_name => 'SS_EE',
919 p_balance_name => 'SS ER Liability',
920 p_association => 'EE OR ER CONTR BALANCE');
921 --
922 assoc_bal( p_element_name => 'SUI_EE',
923 p_balance_name => 'SUI ER Liability',
924 p_association => 'EE OR ER CONTR BALANCE');
925 --
926 assoc_bal( p_element_name => 'City_RS',
927 p_balance_name => 'City Withheld',
928 p_association => 'PRIMARY BALANCE');
929 --
930 assoc_bal( p_element_name => 'City_HT_RS',
931 p_balance_name => 'City HT Withheld',
932 p_association => 'PRIMARY BALANCE');
933 --
934 assoc_bal( p_element_name => 'City_SC_RS',
935 p_balance_name => 'City SC Withheld',
936 p_association => 'PRIMARY BALANCE');
937 --
938 assoc_bal( p_element_name => 'City_WK',
939 p_balance_name => 'City Withheld',
940 p_association => 'PRIMARY BALANCE');
941 --
942 assoc_bal( p_element_name => 'City_HT_WK',
943 p_balance_name => 'City HT Withheld',
944 p_association => 'PRIMARY BALANCE');
945 --
946 assoc_bal( p_element_name => 'City_SC_WK',
947 p_balance_name => 'City SC Withheld',
948 p_association => 'PRIMARY BALANCE');
949 --
950 assoc_bal( p_element_name => 'County_WK',
951 p_balance_name => 'County Withheld',
952 p_association => 'PRIMARY BALANCE');
953 --
954 assoc_bal( p_element_name => 'County_RS',
955 p_balance_name => 'County Withheld',
956 p_association => 'PRIMARY BALANCE');
957 --
958 assoc_bal( p_element_name => 'EIC',
959 p_balance_name => 'EIC Withheld',
960 p_association => 'PRIMARY BALANCE');
961 --
962 assoc_bal( p_element_name => 'FIT',
963 p_balance_name => 'FIT Withheld',
964 p_association => 'PRIMARY BALANCE');
965 --
966 assoc_bal( p_element_name => 'FIT_SUPP',
967 p_balance_name => 'FIT Supp Withheld',
968 p_association => 'PRIMARY BALANCE');
969 --
970 assoc_bal( p_element_name => 'FUTA',
971 p_balance_name => 'FUTA Liability',
972 p_association => 'PRIMARY BALANCE');
973 --
974 assoc_bal( p_element_name => 'Medicare_EE',
975 p_balance_name => 'Medicare EE Withheld',
976 p_association => 'PRIMARY BALANCE');
977 --
978 assoc_bal( p_element_name => 'SDI_EE',
979 p_balance_name => 'SDI EE Withheld',
980 p_association => 'PRIMARY BALANCE');
981 --
982 assoc_bal( p_element_name => 'SIT_WK',
983 p_balance_name => 'SIT Withheld',
984 p_association => 'PRIMARY BALANCE');
985 --
986 assoc_bal( p_element_name => 'SIT_RS',
987 p_balance_name => 'SIT Withheld',
988 p_association => 'PRIMARY BALANCE');
989 --
990 assoc_bal( p_element_name => 'SS_EE',
991 p_balance_name => 'SS EE Withheld',
992 p_association => 'PRIMARY BALANCE');
993 --
994 assoc_bal( p_element_name => 'SUI_EE',
995 p_balance_name => 'SUI EE Withheld',
996 p_association => 'PRIMARY BALANCE');
997
998 --
999 begin
1000
1001 SELECT EVENT_GROUP_ID
1002 INTO l_entry_change_evnt_grp_id
1003 FROM pay_event_groups
1004 WHERE event_group_name = 'Entry Changes'
1005 AND business_group_id is NULL
1006 AND legislation_Code is NULL ;
1007
1008 SELECT EVENT_GROUP_ID
1009 INTO l_reg_ear_evnt_grp_id
1010 FROM pay_event_groups
1011 WHERE event_group_name ='Regular Earnings'
1012 AND legislation_Code = 'US';
1013
1014
1015 exception
1016 when no_data_found then
1017 hr_utility.set_location('No Event Group found.',99);
1018
1019 end;
1020
1021 retro_element( p_element_name => 'Company Car',
1022 p_event_group_id => l_entry_change_evnt_grp_id);
1023
1024 retro_element( p_element_name => 'GTL Imputed Income',
1025 p_event_group_id => l_entry_change_evnt_grp_id);
1026
1027 retro_element( p_element_name => 'Regular Salary',
1028 p_event_group_id => l_reg_ear_evnt_grp_id);
1029
1030 retro_element( p_element_name => 'Overtime',
1031 p_event_group_id => l_reg_ear_evnt_grp_id);
1032
1033 retro_element( p_element_name => 'Regular Wages',
1034 p_event_group_id => l_reg_ear_evnt_grp_id);
1035
1036 retro_element( p_element_name => 'Shift Pay',
1037 p_event_group_id => l_reg_ear_evnt_grp_id);
1038
1039 retro_element( p_element_name => 'Sick Pay',
1040 p_event_group_id => l_reg_ear_evnt_grp_id);
1041
1042 retro_element( p_element_name => 'Time Entry Wages',
1043 p_event_group_id => l_reg_ear_evnt_grp_id);
1044
1045 retro_element( p_element_name => 'Vacation Pay',
1046 p_event_group_id => l_reg_ear_evnt_grp_id);
1047
1048
1049 --
1050 map_time_definition (
1051 p_element_name =>'FLSA Time Definition',
1052 p_input_value_name =>'Time Definition',
1053 p_flex_value_set_name =>'PAY_US_TIME_DEFINITIONS'
1054 );
1055 --
1056 end create_associated_balances;
1057
1058 END pay_assoc_bal;