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_NO_EMP_CONT dependencies on PAY_BALANCE_PKG

Line 339: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

335: hr_utility.trace('EMP_CONT ::: LU ***** get exemption limit ');
336:
337: -- set the context values for balance
338: -- change 1a
339: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
340: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
341:
342: -- get defined balance ids
343: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;

Line 340: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

336:
337: -- set the context values for balance
338: -- change 1a
339: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
340: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
341:
342: -- get defined balance ids
343: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
344: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;

Line 350: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

346: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
347: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
348:
349: -- get the balance value
350: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
351: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
352:
353: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
354:

Line 351: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

347: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
348:
349: -- get the balance value
350: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
351: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
352:
353: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
354:
355: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );

Line 412: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

408:
409: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave' );
410:
411: -- change 2a
412: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
414: -----
415:
416: -- loop to get all assignment_action_id in the current payroll_action_id

Line 413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

409: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave' );
410:
411: -- change 2a
412: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
414: -----
415:
416: -- loop to get all assignment_action_id in the current payroll_action_id
417: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP

Line 430: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

426: hr_utility.trace('EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
427: hr_utility.trace('EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
428:
429: --setting the context values
430: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
431: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
432: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
433:
434: -- get the balance value

Line 431: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

427: hr_utility.trace('EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
428:
429: --setting the context values
430: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
431: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
432: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
433:
434: -- get the balance value
435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 432: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

428:
429: --setting the context values
430: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
431: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
432: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
433:
434: -- get the balance value
435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
436: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);

431: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
432: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
433:
434: -- get the balance value
435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
436: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
437:
438: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
439: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 436: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

432: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
433:
434: -- get the balance value
435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
436: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
437:
438: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
439: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);
440:

Line 438: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);

434: -- get the balance value
435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
436: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
437:
438: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
439: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);
440:
441: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
442:

Line 439: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);

435: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
436: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
437:
438: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
439: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);
440:
441: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
442:
443: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;

Line 515: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

511:
512: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave ' );
513:
514: -- change 3a
515: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
516: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
517: -----
518:
519: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP

Line 516: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

512: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave ' );
513:
514: -- change 3a
515: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
516: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
517: -----
518:
519: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
520:

Line 524: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

520:
521: hr_utility.trace('EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
522:
523: --setting the context values
524: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
525: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
526: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
527:
528: hr_utility.trace('EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

Line 525: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

521: hr_utility.trace('EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
522:
523: --setting the context values
524: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
525: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
526: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
527:
528: hr_utility.trace('EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
529:

Line 526: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

522:
523: --setting the context values
524: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
525: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
526: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
527:
528: hr_utility.trace('EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
529:
530: -- get the balance value

Line 531: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

527:
528: hr_utility.trace('EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
529:
530: -- get the balance value
531: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
532: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
533:
534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 532: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

528: hr_utility.trace('EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
529:
530: -- get the balance value
531: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
532: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
533:
534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
536:

Line 534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

530: -- get the balance value
531: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
532: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
533:
534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
536:
537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );

Line 535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

531: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
532: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
533:
534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
536:
537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );

Line 895: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

891: hr_utility.trace('EMP_CONT ::: LE #### get exemption limit used for LE , entering');
892:
893: -- set the context values for balance
894: -- change 1b
895: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
896: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
897:
898: -- get defined balance ids
899: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;

Line 896: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

892:
893: -- set the context values for balance
894: -- change 1b
895: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
896: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
897:
898: -- get defined balance ids
899: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
900: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;

Line 906: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

902: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
903: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
904:
905: -- get the balance value
906: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
907: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
908:
909: --l_bal_val_ytd := 0 ;
910: --l_bal_val_bimonth := 0 ;

Line 907: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

903: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
904:
905: -- get the balance value
906: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
907: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
908:
909: --l_bal_val_ytd := 0 ;
910: --l_bal_val_bimonth := 0 ;
911:

Line 971: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

967:
968: hr_utility.trace('EMP_CONT ::: LE #### level 0 leave' );
969:
970: -- change 2b -1
971: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
972: ----
973:
974: -- loop to get all assignment_action_id in the current payroll_action_id
975: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP

Line 990: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

986: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
987: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
988:
989: -- Change 2b - 2
990: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
991: -----
992:
993: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
994:

Line 999: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

995: hr_utility.trace('EMP_CONT ::: LE #### level 3, g_mu_tab ' );
996: hr_utility.trace('EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
997:
998: --setting the context values
999: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1000: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1001: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1002:
1003: -- get the balance value

Line 1000: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

996: hr_utility.trace('EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
997:
998: --setting the context values
999: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1000: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1001: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1002:
1003: -- get the balance value
1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 1001: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

997:
998: --setting the context values
999: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1000: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1001: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1002:
1003: -- get the balance value
1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
1005: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);

1000: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1001: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1002:
1003: -- get the balance value
1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
1005: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
1006:
1007: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
1008: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 1005: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

1001: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1002:
1003: -- get the balance value
1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
1005: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
1006:
1007: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
1008: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);
1009:

Line 1007: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);

1003: -- get the balance value
1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
1005: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
1006:
1007: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
1008: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);
1009:
1010: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1011:

Line 1008: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);

1004: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
1005: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
1006:
1007: l_asg_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,csr1_rec.ASSIGNMENT_ACTION_ID);
1008: l_asg_ers_over_62_base2 := pay_balance_pkg.get_value(l_def_bal_id_4,csr1_rec.ASSIGNMENT_ACTION_ID);
1009:
1010: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1011:
1012: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;

Line 1087: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

1083:
1084: hr_utility.trace('EMP_CONT ::: LE #### level 0 leave ' );
1085:
1086: -- change 3b -1
1087: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1088: ----
1089:
1090: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1091:

Line 1099: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

1095: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1096: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1097:
1098: -- change 3b -2
1099: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1100: ----
1101:
1102: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1103:

Line 1109: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

1105:
1106: hr_utility.trace('EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1107:
1108: --setting the context values
1109: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1110: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1111: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1112:
1113: -- get the balance value

Line 1110: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

1106: hr_utility.trace('EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1107:
1108: --setting the context values
1109: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1110: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1111: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1112:
1113: -- get the balance value
1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 1111: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

1107:
1108: --setting the context values
1109: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1110: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1111: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1112:
1113: -- get the balance value
1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1115: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

1110: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1111: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1112:
1113: -- get the balance value
1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1115: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1116:
1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 1115: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

1111: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1112:
1113: -- get the balance value
1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1115: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1116:
1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1119:

Line 1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

1113: -- get the balance value
1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1115: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1116:
1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1119:
1120: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );

Line 1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

1114: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1115: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1116:
1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1119:
1120: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1122: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62_base = '|| l_le_ers_over_62_base );