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

Line 167: l_p60_weeks := pay_balance_pkg.get_value (

163: p_assignment_action_id number) return number as
164: l_p60_weeks number;
165: BEGIN
166:
167: l_p60_weeks := pay_balance_pkg.get_value (
168: get_defined_balance_id ('_PER_PAYE_REF_PRSI_YTD', 'IE PRSI Insurable Weeks'),
169: p_max_action_id,
170: l_segment4,
171: NULL,

Line 178: pay_balance_pkg.get_value (

174: NULL,
175: NULL
176: )
177: -
178: pay_balance_pkg.get_value (
179: get_defined_balance_id ('_PER_PAYE_REF_PRSI_YTD', 'IE PRSI Insurable Weeks'),
180: p_assignment_action_id,
181: l_segment4,
182: NULL,

Line 333: pay_balance_pkg.get_value (

329: -- get the employee and total PRSI contribution till the last period max action id
330: p_this_emp_prsi_cont := to_char(p_prsi_employee_cont -
331: ROUND (
332: NVL (
333: pay_balance_pkg.get_value (
334: pay_ie_p35.get_defined_balance_id (
335: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
336: 'IE PRSI Employee'
337: ),

Line 351: pay_balance_pkg.get_value (

347: ),
348: 0
349: )
350: + NVL (
351: pay_balance_pkg.get_value (
352: pay_ie_p35.get_defined_balance_id (
353: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
354: 'IE PRSI K Employee Lump Sum'
355: ),

Line 369: pay_balance_pkg.get_value (

365: ),
366: 0
367: )
368: + NVL (
369: pay_balance_pkg.get_value (
370: pay_ie_p35.get_defined_balance_id (
371: '_PER_YTD',
372: 'IE PRSI M Employee Lump Sum'
373: ),

Line 394: pay_balance_pkg.get_value (

390:
391: p_this_tot_prsi := to_char(p_prsi_tot_cont -
392: ROUND (
393: NVL (
394: pay_balance_pkg.get_value (
395: pay_ie_p35.get_defined_balance_id (
396: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
397: 'IE PRSI Employee'
398: ),

Line 412: pay_balance_pkg.get_value (

408: ),
409: 0
410: )
411: + NVL (
412: pay_balance_pkg.get_value (
413: pay_ie_p35.get_defined_balance_id (
414: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
415: 'IE PRSI Employer'
416: ),

Line 430: pay_balance_pkg.get_value (

426: ),
427: 0
428: )
429: + NVL (
430: pay_balance_pkg.get_value (
431: pay_ie_p35.get_defined_balance_id (
432: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
433: 'IE PRSI K Employee Lump Sum'
434: ),

Line 448: pay_balance_pkg.get_value (

444: ),
445: 0
446: )
447: + NVL (
448: pay_balance_pkg.get_value (
449: pay_ie_p35.get_defined_balance_id (
450: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
451: 'IE PRSI M Employee Lump Sum'
452: ),

Line 466: pay_balance_pkg.get_value (

462: ),
463: 0
464: )
465: + NVL (
466: pay_balance_pkg.get_value (
467: pay_ie_p35.get_defined_balance_id (
468: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
469: 'IE PRSI K Employer Lump Sum'
470: ),

Line 484: pay_balance_pkg.get_value (

480: ),
481: 0
482: )
483: + NVL (
484: pay_balance_pkg.get_value (
485: pay_ie_p35.get_defined_balance_id (
486: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
487: 'IE PRSI M Employer Lump Sum'
488: ),

Line 1399: pay_balance_pkg.get_value (

1395: DECODE (SIGN (TO_NUMBER (p_arch_net_tax)), -1, 'H9', 1, 'J7'), --Q1_PR_Indicator
1396: NVL (
1397: ROUND (
1398: TO_NUMBER (
1399: pay_balance_pkg.get_value (
1400: pay_ie_p35.get_defined_balance_id (
1401: '_ASG_YTD',
1402: 'IE P45 Pay'
1403: ),

Line 1414: pay_balance_pkg.get_value (

1410: ), -- Q1_Previous_Emp_Pay
1411: NVL (
1412: ROUND (
1413: TO_NUMBER (
1414: pay_balance_pkg.get_value (
1415: pay_ie_p35.get_defined_balance_id (
1416: '_ASG_YTD',
1417: 'IE P45 Tax Deducted'
1418: ),

Line 1488: pay_balance_pkg.get_value (

1484: paa.assignment_action_id, -- FOR CALCULATION
1485: DECODE (
1486: SIGN (
1487: NVL (
1488: pay_balance_pkg.get_value (
1489: pay_ie_p35.get_defined_balance_id (
1490: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
1491: 'IE Net Tax'
1492: ),

Line 1583: pay_balance_pkg.get_value (

1579:
1580: NVL (TRIM (RPAD (ppf.per_information1, 30)), ' '), --MOTHERS_NAME
1581: DECODE (
1582: SIGN (
1583: pay_balance_pkg.get_value (
1584: pay_ie_p35.get_defined_balance_id (
1585: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made--6633719
1586: 'IE Net Tax'
1587: ),

Line 1605: pay_balance_pkg.get_value (

1601: ), --Q1_PR_Indicator
1602: NVL (
1603: ROUND (
1604: TO_NUMBER (
1605: pay_balance_pkg.get_value (
1606: pay_ie_p35.get_defined_balance_id (
1607: '_ASG_YTD',
1608: 'IE P45 Pay'
1609: ),

Line 1620: pay_balance_pkg.get_value (

1616: ), -- Q1_Previous_Emp_Pay
1617: NVL (
1618: ROUND (
1619: TO_NUMBER (
1620: pay_balance_pkg.get_value (
1621: pay_ie_p35.get_defined_balance_id (
1622: '_ASG_YTD',
1623: 'IE P45 Tax Deducted'
1624: ),

Line 1691: pay_balance_pkg.get_value (

1687: paa.assignment_action_id, -- FOR CALCULATION
1688: DECODE (
1689: SIGN (
1690: NVL (
1691: pay_balance_pkg.get_value (
1692: pay_ie_p35.get_defined_balance_id (
1693: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made--6633719
1694: 'IE Net Tax'
1695: ),

Line 1787: pay_balance_pkg.get_value (

1783:
1784: NVL (TRIM (RPAD (ppf.per_information1, 30)), ' '), -- MOTHERS_NAME
1785: DECODE (
1786: SIGN (
1787: pay_balance_pkg.get_value (
1788: pay_ie_p35.get_defined_balance_id (
1789: p_dimension_name, ---'_PER_PAYE_REF_YTD', -- changes made--6633719
1790: 'IE Net Tax'
1791: ),

Line 1809: pay_balance_pkg.get_value (

1805: ), --Q1_PR_Indicator
1806: NVL (
1807: ROUND (
1808: TO_NUMBER (
1809: pay_balance_pkg.get_value (
1810: pay_ie_p35.get_defined_balance_id (
1811: '_ASG_YTD',
1812: 'IE P45 Pay'
1813: ),

Line 1824: pay_balance_pkg.get_value (

1820: ), -- Q1_Previous_Emp_Pay
1821: NVL (
1822: ROUND (
1823: TO_NUMBER (
1824: pay_balance_pkg.get_value (
1825: pay_ie_p35.get_defined_balance_id (
1826: '_ASG_YTD',
1827: 'IE P45 Tax Deducted'
1828: ),

Line 2359: pay_balance_pkg.get_value (

2355: l_arch_pay :=
2356: TO_CHAR (
2357: ROUND (
2358: NVL (
2359: pay_balance_pkg.get_value (
2360: pay_ie_p35.get_defined_balance_id (
2361: l_dimension_name,
2362: 'IE Taxable Pay'
2363: ),

Line 2396: pay_balance_pkg.get_value (

2392: l_arch_net_tax :=
2393: TO_CHAR (
2394: ROUND (
2395: NVL (
2396: pay_balance_pkg.get_value (
2397: pay_ie_p35.get_defined_balance_id (
2398: l_dimension_name,
2399: 'IE Net Tax'
2400: ),

Line 2433: pay_balance_pkg.get_value (

2429: l_arch_employees_prsi_cont :=
2430: TO_CHAR (
2431: ROUND (
2432: NVL (
2433: pay_balance_pkg.get_value (
2434: pay_ie_p35.get_defined_balance_id (
2435: l_dimension_name,
2436: 'IE PRSI Employee'
2437: ),

Line 2476: pay_balance_pkg.get_value (

2472: l_temp_prsi_cont :=
2473: TO_CHAR (
2474: ROUND (
2475: NVL (
2476: pay_balance_pkg.get_value (
2477: pay_ie_p35.get_defined_balance_id (
2478: l_dimension_name,
2479: 'IE PRSI K Employee Lump Sum'
2480: ),

Line 2521: pay_balance_pkg.get_value (

2517: l_temp_prsi_cont :=
2518: TO_CHAR (
2519: ROUND (
2520: NVL (
2521: pay_balance_pkg.get_value (
2522: pay_ie_p35.get_defined_balance_id (
2523: l_dimension_name,
2524: 'IE PRSI M Employee Lump Sum'
2525: ),

Line 2566: pay_balance_pkg.get_value (

2562: l_arch_employer_prsi_cont :=
2563: TO_CHAR (
2564: ROUND (
2565: NVL (
2566: pay_balance_pkg.get_value (
2567: pay_ie_p35.get_defined_balance_id (
2568: l_dimension_name,
2569: 'IE PRSI Employer'
2570: ),

Line 2604: pay_balance_pkg.get_value (

2600: l_temp_prsi_cont :=
2601: TO_CHAR (
2602: ROUND (
2603: NVL (
2604: pay_balance_pkg.get_value (
2605: pay_ie_p35.get_defined_balance_id (
2606: l_dimension_name,
2607: 'IE PRSI K Employer Lump Sum'
2608: ),

Line 2649: pay_balance_pkg.get_value (

2645: l_temp_prsi_cont :=
2646: TO_CHAR (
2647: ROUND (
2648: NVL (
2649: pay_balance_pkg.get_value (
2650: pay_ie_p35.get_defined_balance_id (
2651: l_dimension_name,
2652: 'IE PRSI M Employer Lump Sum'
2653: ),

Line 2696: pay_balance_pkg.get_value (

2692: l_arch_total_notional_pay :=
2693: TO_CHAR (
2694: ROUND (
2695: NVL (
2696: pay_balance_pkg.get_value (
2697: pay_ie_p35.get_defined_balance_id (
2698: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
2699: 'IE BIK Taxable and PRSIable Pay'
2700: ),

Line 2723: pay_balance_pkg.get_value (

2719: l_arch_pen_emp_rbs :=
2720: TO_CHAR (
2721: ROUND (
2722: NVL (
2723: pay_balance_pkg.get_value (
2724: pay_ie_p35.get_defined_balance_id (
2725: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
2726: 'IE RBS EE Contribution'
2727: ),

Line 2745: pay_balance_pkg.get_value (

2741: )
2742: +
2743: ROUND (
2744: NVL (
2745: pay_balance_pkg.get_value (
2746: pay_ie_p35.get_defined_balance_id (
2747: l_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
2748: 'IE RBS EE AVC Contribution'
2749: ),

Line 2770: pay_balance_pkg.get_value (

2766: l_arch_pen_empr_rbs :=
2767: TO_CHAR (
2768: ROUND (
2769: NVL (
2770: pay_balance_pkg.get_value (
2771: pay_ie_p35.get_defined_balance_id (
2772: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
2773: 'IE RBS ER Contribution'
2774: ),

Line 2795: pay_balance_pkg.get_value (

2791: l_arch_pen_emp_prsa :=
2792: TO_CHAR (
2793: ROUND (
2794: NVL (
2795: pay_balance_pkg.get_value (
2796: pay_ie_p35.get_defined_balance_id (
2797: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
2798: 'IE PRSA EE Contribution'
2799: ),

Line 2817: pay_balance_pkg.get_value (

2813: )
2814: +
2815: ROUND (
2816: NVL (
2817: pay_balance_pkg.get_value (
2818: pay_ie_p35.get_defined_balance_id (
2819: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
2820: 'IE PRSA EE AVC Contribution'
2821: ),

Line 2842: pay_balance_pkg.get_value (

2838: l_arch_pen_empr_prsa :=
2839: TO_CHAR (
2840: ROUND (
2841: NVL (
2842: pay_balance_pkg.get_value (
2843: pay_ie_p35.get_defined_balance_id (
2844: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
2845: 'IE PRSA ER Contribution'
2846: ),

Line 2867: pay_balance_pkg.get_value (

2863: l_arch_pen_emp_rac :=
2864: TO_CHAR (
2865: ROUND (
2866: NVL (
2867: pay_balance_pkg.get_value (
2868: pay_ie_p35.get_defined_balance_id (
2869: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
2870: 'IE RAC EE Contribution'
2871: ),

Line 2894: pay_balance_pkg.get_value (

2890: l_medical_insurance :=
2891: TO_CHAR (
2892: ROUND (
2893: NVL (
2894: pay_balance_pkg.get_value (
2895: pay_ie_p35.get_defined_balance_id (
2896: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
2897: 'IE BIK Medical Insurance'
2898: ),

Line 2922: pay_balance_pkg.get_value (

2918: l_arch_non_tax_pay :=
2919: TO_CHAR (
2920: ROUND (
2921: NVL (
2922: pay_balance_pkg.get_value (
2923: pay_ie_p35.get_defined_balance_id (
2924: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
2925: 'Total Pay'
2926: ),

Line 3042: pay_balance_pkg.get_value (

3038: l_arch_net_tax :=
3039: TO_CHAR (
3040: ROUND (
3041: NVL (
3042: pay_balance_pkg.get_value (
3043: pay_ie_p35.get_defined_balance_id (
3044: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3045: 'IE Net Tax'
3046: ),

Line 3067: pay_balance_pkg.get_value (

3063: l_arch_employees_prsi_cont :=
3064: TO_CHAR (
3065: ROUND (
3066: NVL (
3067: pay_balance_pkg.get_value (
3068: pay_ie_p35.get_defined_balance_id (
3069: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3070: 'IE PRSI Employee'
3071: ),

Line 3085: pay_balance_pkg.get_value (

3081: ),
3082: 0
3083: )
3084: + NVL (
3085: pay_balance_pkg.get_value (
3086: pay_ie_p35.get_defined_balance_id (
3087: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3088: 'IE PRSI K Employee Lump Sum'
3089: ),

Line 3103: pay_balance_pkg.get_value (

3099: ),
3100: 0
3101: )
3102: + NVL (
3103: pay_balance_pkg.get_value (
3104: pay_ie_p35.get_defined_balance_id (
3105: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3106: 'IE PRSI M Employee Lump Sum'
3107: ),

Line 3128: pay_balance_pkg.get_value (

3124: l_arch_total_prsi_cont :=
3125: TO_CHAR (
3126: ROUND (
3127: NVL (
3128: pay_balance_pkg.get_value (
3129: pay_ie_p35.get_defined_balance_id (
3130: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3131: 'IE PRSI Employee'
3132: ),

Line 3146: pay_balance_pkg.get_value (

3142: ),
3143: 0
3144: )
3145: + NVL (
3146: pay_balance_pkg.get_value (
3147: pay_ie_p35.get_defined_balance_id (
3148: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3149: 'IE PRSI Employer'
3150: ),

Line 3164: pay_balance_pkg.get_value (

3160: ),
3161: 0
3162: )
3163: + NVL (
3164: pay_balance_pkg.get_value (
3165: pay_ie_p35.get_defined_balance_id (
3166: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3167: 'IE PRSI K Employee Lump Sum'
3168: ),

Line 3182: pay_balance_pkg.get_value (

3178: ),
3179: 0
3180: )
3181: + NVL (
3182: pay_balance_pkg.get_value (
3183: pay_ie_p35.get_defined_balance_id (
3184: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3185: 'IE PRSI M Employee Lump Sum'
3186: ),

Line 3200: pay_balance_pkg.get_value (

3196: ),
3197: 0
3198: )
3199: + NVL (
3200: pay_balance_pkg.get_value (
3201: pay_ie_p35.get_defined_balance_id (
3202: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3203: 'IE PRSI K Employer Lump Sum'
3204: ),

Line 3218: pay_balance_pkg.get_value (

3214: ),
3215: 0
3216: )
3217: + NVL (
3218: pay_balance_pkg.get_value (
3219: pay_ie_p35.get_defined_balance_id (
3220: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3221: 'IE PRSI M Employer Lump Sum'
3222: ),

Line 3243: pay_balance_pkg.get_value (

3239: l_arch_pay :=
3240: TO_CHAR (
3241: ROUND (
3242: NVL (
3243: pay_balance_pkg.get_value (
3244: pay_ie_p35.get_defined_balance_id (
3245: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3246: 'IE Taxable Pay'
3247: ),

Line 3268: pay_balance_pkg.get_value (

3264: l_arch_total_notional_pay :=
3265: TO_CHAR (
3266: ROUND (
3267: NVL (
3268: pay_balance_pkg.get_value (
3269: pay_ie_p35.get_defined_balance_id (
3270: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3271: 'IE BIK Taxable and PRSIable Pay'
3272: ),

Line 3294: pay_balance_pkg.get_value (

3290: l_arch_pen_emp_rbs :=
3291: TO_CHAR (
3292: ROUND (
3293: NVL (
3294: pay_balance_pkg.get_value (
3295: pay_ie_p35.get_defined_balance_id (
3296: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3297: 'IE RBS EE Contribution'
3298: ),

Line 3316: pay_balance_pkg.get_value (

3312: )
3313: +
3314: ROUND (
3315: NVL (
3316: pay_balance_pkg.get_value (
3317: pay_ie_p35.get_defined_balance_id (
3318: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3319: 'IE RBS EE AVC Contribution'
3320: ),

Line 3341: pay_balance_pkg.get_value (

3337: l_arch_pen_empr_rbs :=
3338: TO_CHAR (
3339: ROUND (
3340: NVL (
3341: pay_balance_pkg.get_value (
3342: pay_ie_p35.get_defined_balance_id (
3343: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3344: 'IE RBS ER Contribution'
3345: ),

Line 3366: pay_balance_pkg.get_value (

3362: l_arch_pen_emp_prsa :=
3363: TO_CHAR (
3364: ROUND (
3365: NVL (
3366: pay_balance_pkg.get_value (
3367: pay_ie_p35.get_defined_balance_id (
3368: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3369: 'IE PRSA EE Contribution'
3370: ),

Line 3388: pay_balance_pkg.get_value (

3384: )
3385: +
3386: ROUND (
3387: NVL (
3388: pay_balance_pkg.get_value (
3389: pay_ie_p35.get_defined_balance_id (
3390: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3391: 'IE PRSA EE AVC Contribution'
3392: ),

Line 3413: pay_balance_pkg.get_value (

3409: l_arch_pen_empr_prsa :=
3410: TO_CHAR (
3411: ROUND (
3412: NVL (
3413: pay_balance_pkg.get_value (
3414: pay_ie_p35.get_defined_balance_id (
3415: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3416: 'IE PRSA ER Contribution'
3417: ),

Line 3438: pay_balance_pkg.get_value (

3434: l_arch_pen_emp_rac :=
3435: TO_CHAR (
3436: ROUND (
3437: NVL (
3438: pay_balance_pkg.get_value (
3439: pay_ie_p35.get_defined_balance_id (
3440: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3441: 'IE RAC EE Contribution'
3442: ),

Line 3465: pay_balance_pkg.get_value (

3461: l_medical_insurance :=
3462: TO_CHAR (
3463: ROUND (
3464: NVL (
3465: pay_balance_pkg.get_value (
3466: pay_ie_p35.get_defined_balance_id (
3467: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3468: 'IE BIK Medical Insurance'
3469: ),

Line 3493: pay_balance_pkg.get_value (

3489: l_arch_non_tax_pay :=
3490: TO_CHAR (
3491: ROUND (
3492: NVL (
3493: pay_balance_pkg.get_value (
3494: pay_ie_p35.get_defined_balance_id (
3495: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3496: 'Total Pay'
3497: ),

Line 3565: pay_balance_pkg.get_value (

3561: l_arch_net_tax :=
3562: TO_CHAR (
3563: ROUND (
3564: NVL (
3565: pay_balance_pkg.get_value (
3566: pay_ie_p35.get_defined_balance_id (
3567: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3568: 'IE Net Tax'
3569: ),

Line 3590: pay_balance_pkg.get_value (

3586: l_arch_employees_prsi_cont :=
3587: TO_CHAR (
3588: ROUND (
3589: NVL (
3590: pay_balance_pkg.get_value (
3591: pay_ie_p35.get_defined_balance_id (
3592: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3593: 'IE PRSI Employee'
3594: ),

Line 3608: pay_balance_pkg.get_value (

3604: ),
3605: 0
3606: )
3607: + NVL (
3608: pay_balance_pkg.get_value (
3609: pay_ie_p35.get_defined_balance_id (
3610: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3611: 'IE PRSI K Employee Lump Sum'
3612: ),

Line 3626: pay_balance_pkg.get_value (

3622: ),
3623: 0
3624: )
3625: + NVL (
3626: pay_balance_pkg.get_value (
3627: pay_ie_p35.get_defined_balance_id (
3628: '_PER_YTD',
3629: 'IE PRSI M Employee Lump Sum'
3630: ),

Line 3652: pay_balance_pkg.get_value (

3648: l_arch_total_prsi_cont :=
3649: TO_CHAR (
3650: ROUND (
3651: NVL (
3652: pay_balance_pkg.get_value (
3653: pay_ie_p35.get_defined_balance_id (
3654: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3655: 'IE PRSI Employee'
3656: ),

Line 3670: pay_balance_pkg.get_value (

3666: ),
3667: 0
3668: )
3669: + NVL (
3670: pay_balance_pkg.get_value (
3671: pay_ie_p35.get_defined_balance_id (
3672: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3673: 'IE PRSI Employer'
3674: ),

Line 3688: pay_balance_pkg.get_value (

3684: ),
3685: 0
3686: )
3687: + NVL (
3688: pay_balance_pkg.get_value (
3689: pay_ie_p35.get_defined_balance_id (
3690: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3691: 'IE PRSI K Employee Lump Sum'
3692: ),

Line 3706: pay_balance_pkg.get_value (

3702: ),
3703: 0
3704: )
3705: + NVL (
3706: pay_balance_pkg.get_value (
3707: pay_ie_p35.get_defined_balance_id (
3708: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3709: 'IE PRSI M Employee Lump Sum'
3710: ),

Line 3724: pay_balance_pkg.get_value (

3720: ),
3721: 0
3722: )
3723: + NVL (
3724: pay_balance_pkg.get_value (
3725: pay_ie_p35.get_defined_balance_id (
3726: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3727: 'IE PRSI K Employer Lump Sum'
3728: ),

Line 3742: pay_balance_pkg.get_value (

3738: ),
3739: 0
3740: )
3741: + NVL (
3742: pay_balance_pkg.get_value (
3743: pay_ie_p35.get_defined_balance_id (
3744: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3745: 'IE PRSI M Employer Lump Sum'
3746: ),

Line 3767: pay_balance_pkg.get_value (

3763: l_arch_pay :=
3764: TO_CHAR (
3765: ROUND (
3766: NVL (
3767: pay_balance_pkg.get_value (
3768: pay_ie_p35.get_defined_balance_id (
3769: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3770: 'IE Taxable Pay'
3771: ),

Line 3796: pay_balance_pkg.get_value (

3792: l_arch_total_notional_pay :=
3793: TO_CHAR (
3794: ROUND (
3795: NVL (
3796: pay_balance_pkg.get_value (
3797: pay_ie_p35.get_defined_balance_id (
3798: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
3799: 'IE BIK Taxable and PRSIable Pay'
3800: ),

Line 3822: pay_balance_pkg.get_value (

3818: l_arch_pen_emp_rbs :=
3819: TO_CHAR (
3820: ROUND (
3821: NVL (
3822: pay_balance_pkg.get_value (
3823: pay_ie_p35.get_defined_balance_id (
3824: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3825: 'IE RBS EE Contribution'
3826: ),

Line 3844: pay_balance_pkg.get_value (

3840: )
3841: +
3842: ROUND (
3843: NVL (
3844: pay_balance_pkg.get_value (
3845: pay_ie_p35.get_defined_balance_id (
3846: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3847: 'IE RBS EE AVC Contribution'
3848: ),

Line 3869: pay_balance_pkg.get_value (

3865: l_arch_pen_empr_rbs :=
3866: TO_CHAR (
3867: ROUND (
3868: NVL (
3869: pay_balance_pkg.get_value (
3870: pay_ie_p35.get_defined_balance_id (
3871: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3872: 'IE RBS ER Contribution'
3873: ),

Line 3894: pay_balance_pkg.get_value (

3890: l_arch_pen_emp_prsa :=
3891: TO_CHAR (
3892: ROUND (
3893: NVL (
3894: pay_balance_pkg.get_value (
3895: pay_ie_p35.get_defined_balance_id (
3896: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3897: 'IE PRSA EE Contribution'
3898: ),

Line 3916: pay_balance_pkg.get_value (

3912: )
3913: +
3914: ROUND (
3915: NVL (
3916: pay_balance_pkg.get_value (
3917: pay_ie_p35.get_defined_balance_id (
3918: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3919: 'IE PRSA EE AVC Contribution'
3920: ),

Line 3941: pay_balance_pkg.get_value (

3937: l_arch_pen_empr_prsa :=
3938: TO_CHAR (
3939: ROUND (
3940: NVL (
3941: pay_balance_pkg.get_value (
3942: pay_ie_p35.get_defined_balance_id (
3943: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3944: 'IE PRSA ER Contribution'
3945: ),

Line 3966: pay_balance_pkg.get_value (

3962: l_arch_pen_emp_rac :=
3963: TO_CHAR (
3964: ROUND (
3965: NVL (
3966: pay_balance_pkg.get_value (
3967: pay_ie_p35.get_defined_balance_id (
3968: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3969: 'IE RAC EE Contribution'
3970: ),

Line 3993: pay_balance_pkg.get_value (

3989: l_medical_insurance :=
3990: TO_CHAR (
3991: ROUND (
3992: NVL (
3993: pay_balance_pkg.get_value (
3994: pay_ie_p35.get_defined_balance_id (
3995: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3996: 'IE BIK Medical Insurance'
3997: ),

Line 4021: pay_balance_pkg.get_value (

4017: l_arch_non_tax_pay :=
4018: TO_CHAR (
4019: ROUND (
4020: NVL (
4021: pay_balance_pkg.get_value (
4022: pay_ie_p35.get_defined_balance_id (
4023: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4024: 'Total Pay'
4025: ),

Line 4076: pay_balance_pkg.get_value (

4072: END IF;
4073: l_arch_previous_emp_pay := NVL (
4074: ROUND (
4075: TO_NUMBER (
4076: pay_balance_pkg.get_value (
4077: pay_ie_p35.get_defined_balance_id (
4078: '_ASG_YTD',
4079: 'IE P45 Pay'
4080: ),

Line 4092: pay_balance_pkg.get_value (

4088: hr_utility.set_location('l_arch_previous_emp_pay.'||l_arch_previous_emp_pay,5001);
4089: l_arch_previous_emp_tax := NVL (
4090: ROUND (
4091: TO_NUMBER (
4092: pay_balance_pkg.get_value (
4093: pay_ie_p35.get_defined_balance_id (
4094: '_ASG_YTD',
4095: 'IE P45 Tax Deducted'
4096: ),

Line 4341: l_this_pay := l_arch_pay - pay_balance_pkg.get_value (

4337: hr_utility.set_location('l_arch_pay..'||l_arch_pay,5004);
4338: hr_utility.set_location('l_aact_id..'||l_aact_id,5004);
4339: IF l_aact_id IS NOT NULL THEN
4340: -- for bug 5435931.
4341: l_this_pay := l_arch_pay - pay_balance_pkg.get_value (
4342: pay_ie_p35.get_defined_balance_id (
4343: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4344: 'IE Taxable Pay'
4345: ),

Line 4358: l_this_tax := l_arch_net_tax - pay_balance_pkg.get_value (

4354: 'TRUE'
4355:
4356: );
4357: hr_utility.set_location('l_this_pay..'||l_this_pay,5004);
4358: l_this_tax := l_arch_net_tax - pay_balance_pkg.get_value (
4359: pay_ie_p35.get_defined_balance_id (
4360: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4361: 'IE Net Tax'
4362: ),

Line 5330: pay_balance_pkg.get_value (

5326:
5327: l_weeks := 0;
5328:
5329: l_weeks := l_weeks +
5330: pay_balance_pkg.get_value (
5331: l_defined_balance_id,
5332: t_asg_action_id,
5333: l_segment4,
5334: NULL,

Line 5363: pay_balance_pkg.get_value (

5359: l_initial_weeks := 0;
5360: --FOR csr_action_rec IN 1..t_asg_action_id.count
5361: --LOOP -- Bug fix 4004470
5362: l_initial_weeks := l_initial_weeks +
5363: pay_balance_pkg.get_value (
5364: l_defined_balance_id,
5365: t_asg_action_id,
5366: l_segment4,
5367: NULL,

Line 5403: pay_balance_pkg.get_value (

5399: l_weeks_at_second_class := 0; --Bug fix 4023794, flusing of variables
5400: --FOR csr_action_rec IN 1..t_asg_action_id.count
5401: --LOOP
5402: l_weeks_at_second_class := l_weeks_at_second_class +
5403: pay_balance_pkg.get_value (
5404: l_defined_balance_id,
5405: -- l_assignment_action_id,
5406: t_asg_action_id,
5407: l_segment4,

Line 5439: pay_balance_pkg.get_value (

5435: l_weeks_at_third_class := 0; --Bug fix 4023794, flusing of variables
5436: --FOR csr_action_rec IN 1..t_asg_action_id.count
5437: --LOOP
5438: l_weeks_at_third_class := l_weeks_at_third_class +
5439: pay_balance_pkg.get_value (
5440: l_defined_balance_id,
5441: --l_assignment_action_id,
5442: t_asg_action_id,
5443: l_segment4,

Line 5474: pay_balance_pkg.get_value (

5470: l_weeks_at_fourth_class := 0; --Bug fix 4023794, flusing of variables
5471: --FOR csr_action_rec IN 1..t_asg_action_id.count
5472: --LOOP
5473: l_weeks_at_fourth_class := l_weeks_at_fourth_class +
5474: pay_balance_pkg.get_value (
5475: l_defined_balance_id,
5476: -- l_assignment_action_id,
5477: t_asg_action_id,
5478: l_segment4,

Line 5510: pay_balance_pkg.get_value (

5506: IF l_fifth_class IS NOT NULL
5507: THEN
5508: l_weeks_at_fifth_class := 0;
5509: l_weeks_at_fifth_class := l_weeks_at_fifth_class +
5510: pay_balance_pkg.get_value (
5511: l_defined_balance_id,
5512: t_asg_action_id,
5513: l_segment4,
5514: NULL,

Line 5567: nvl(pay_balance_pkg.get_value (

5563:
5564: l_total_weeks := 0;
5565: --Bug fix 4004470
5566: l_total_weeks :=l_total_weeks +
5567: nvl(pay_balance_pkg.get_value (
5568: pay_ie_p35.get_defined_balance_id (
5569: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
5570: 'IE PRSI Insurable Weeks'
5571: ),

Line 5583: nvl(pay_balance_pkg.get_value (

5579: null,
5580: 'TRUE'
5581: ),0)
5582: +
5583: nvl(pay_balance_pkg.get_value (
5584: pay_ie_p35.get_defined_balance_id (
5585: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
5586: 'IE PRSI K Term Insurable Weeks'
5587: ),

Line 5598: + nvl(pay_balance_pkg.get_value (

5594: null,
5595: null,
5596: 'TRUE'
5597: ),0)
5598: + nvl(pay_balance_pkg.get_value (
5599: pay_ie_p35.get_defined_balance_id (
5600: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
5601: 'IE PRSI M Term Insurable Weeks'
5602: ),