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