170: p_assignment_action_id number) return number as
171: l_p60_weeks number;
172: BEGIN
173:
174: l_p60_weeks := pay_balance_pkg.get_value (
175: get_defined_balance_id ('_PER_PAYE_REF_PRSI_YTD', 'IE PRSI Insurable Weeks'),
176: p_max_action_id,
177: l_segment4,
178: NULL,
181: NULL,
182: NULL
183: )
184: -
185: pay_balance_pkg.get_value (
186: get_defined_balance_id ('_PER_PAYE_REF_PRSI_YTD', 'IE PRSI Insurable Weeks'),
187: p_assignment_action_id,
188: l_segment4,
189: NULL,
336: -- get the employee and total PRSI contribution till the last period max action id
337: p_this_emp_prsi_cont := to_char(p_prsi_employee_cont -
338: ROUND (
339: NVL (
340: pay_balance_pkg.get_value (
341: pay_ie_p35.get_defined_balance_id (
342: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
343: 'IE PRSI Employee'
344: ),
354: ),
355: 0
356: )
357: + NVL (
358: pay_balance_pkg.get_value (
359: pay_ie_p35.get_defined_balance_id (
360: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
361: 'IE PRSI K Employee Lump Sum'
362: ),
372: ),
373: 0
374: )
375: + NVL (
376: pay_balance_pkg.get_value (
377: pay_ie_p35.get_defined_balance_id (
378: '_PER_YTD',
379: 'IE PRSI M Employee Lump Sum'
380: ),
397:
398: p_this_tot_prsi := to_char(p_prsi_tot_cont -
399: ROUND (
400: NVL (
401: pay_balance_pkg.get_value (
402: pay_ie_p35.get_defined_balance_id (
403: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
404: 'IE PRSI Employee'
405: ),
415: ),
416: 0
417: )
418: + NVL (
419: pay_balance_pkg.get_value (
420: pay_ie_p35.get_defined_balance_id (
421: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
422: 'IE PRSI Employer'
423: ),
433: ),
434: 0
435: )
436: + NVL (
437: pay_balance_pkg.get_value (
438: pay_ie_p35.get_defined_balance_id (
439: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
440: 'IE PRSI K Employee Lump Sum'
441: ),
451: ),
452: 0
453: )
454: + NVL (
455: pay_balance_pkg.get_value (
456: pay_ie_p35.get_defined_balance_id (
457: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
458: 'IE PRSI M Employee Lump Sum'
459: ),
469: ),
470: 0
471: )
472: + NVL (
473: pay_balance_pkg.get_value (
474: pay_ie_p35.get_defined_balance_id (
475: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
476: 'IE PRSI K Employer Lump Sum'
477: ),
487: ),
488: 0
489: )
490: + NVL (
491: pay_balance_pkg.get_value (
492: pay_ie_p35.get_defined_balance_id (
493: p_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
494: 'IE PRSI M Employer Lump Sum'
495: ),
1018: --8874161
1019: CURSOR csr_inc_levy(p_action_id_max NUMBER, p_asg_id NUMBER)
1020: IS
1021: SELECT
1022: pay_balance_pkg.get_value (
1023: pay_ie_p35.get_defined_balance_id (
1024: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1025: 'IE Income Tax Levy'),
1026: p_action_id_max,
1042: --12382953
1043: CURSOR csr_usc_prsi_tax_amt(p_action_id_max NUMBER, p_asg_id NUMBER)
1044: IS
1045: SELECT
1046: pay_balance_pkg.get_value (
1047: pay_ie_p35.get_defined_balance_id (
1048: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1049: 'IE USC Balance'),
1050: p_action_id_max,
1056: null,
1057: null,
1058: 'TRUE'
1059: ) usc,
1060: (pay_balance_pkg.get_value (
1061: pay_ie_p35.get_defined_balance_id (
1062: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1063: 'IE PRSI Employee'),
1064: p_action_id_max,
1070: null,
1071: null,
1072: 'TRUE'
1073: ) +
1074: pay_balance_pkg.get_value (
1075: pay_ie_p35.get_defined_balance_id (
1076: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1077: 'IE PRSI Employer'),
1078: p_action_id_max,
1084: null,
1085: null,
1086: 'TRUE'
1087: ) +
1088: pay_balance_pkg.get_value (
1089: pay_ie_p35.get_defined_balance_id (
1090: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1091: 'IE PRSI M Employee Lump Sum'),
1092: p_action_id_max,
1098: null,
1099: null,
1100: 'TRUE'
1101: ) +
1102: pay_balance_pkg.get_value (
1103: pay_ie_p35.get_defined_balance_id (
1104: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1105: 'IE PRSI M Employer Lump Sum'),
1106: p_action_id_max,
1112: null,
1113: null,
1114: 'TRUE'
1115: ) +
1116: pay_balance_pkg.get_value (
1117: pay_ie_p35.get_defined_balance_id (
1118: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1119: 'IE PRSI K Employee Lump Sum'),
1120: p_action_id_max,
1126: null,
1127: null,
1128: 'TRUE'
1129: ) +
1130: pay_balance_pkg.get_value (
1131: pay_ie_p35.get_defined_balance_id (
1132: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1133: 'IE PRSI K Employer Lump Sum'),
1134: p_action_id_max,
1140: null,
1141: null,
1142: 'TRUE'
1143: ) ) prsi,
1144: pay_balance_pkg.get_value (
1145: pay_ie_p35.get_defined_balance_id (
1146: DECODE(PAY_IE_P35.OVERRIDE_PPSN(p_asg_id),NULL,'_PER_PAYE_REF_YTD','_PER_PAYE_REF_PPSN_YTD'),
1147: 'IE Taxable Pay'),
1148: p_action_id_max,
1702: DECODE (SIGN (TO_NUMBER (p_arch_net_tax)), -1, 'H9', 1, 'J7'), --Q1_PR_Indicator
1703: NVL (
1704: ROUND (
1705: TO_NUMBER (
1706: pay_balance_pkg.get_value (
1707: pay_ie_p35.get_defined_balance_id (
1708: '_ASG_YTD',
1709: 'IE P45 Pay'
1710: ),
1717: ), -- Q1_Previous_Emp_Pay
1718: NVL (
1719: ROUND (
1720: TO_NUMBER (
1721: pay_balance_pkg.get_value (
1722: pay_ie_p35.get_defined_balance_id (
1723: '_ASG_YTD',
1724: 'IE P45 Tax Deducted'
1725: ),
1733: --14659262
1734: ,NVL (
1735: ROUND (
1736: TO_NUMBER (
1737: pay_balance_pkg.get_value (
1738: pay_ie_p35.get_defined_balance_id (
1739: '_ASG_YTD',
1740: 'IE P45 USC Pay'
1741: ),
1748: ) -- Q1_Previous_Emp_Pay_USC
1749: ,NVL (
1750: ROUND (
1751: TO_NUMBER (
1752: pay_balance_pkg.get_value (
1753: pay_ie_p35.get_defined_balance_id (
1754: '_ASG_YTD',
1755: 'IE P45 USC Deducted'
1756: ),
1825: paa.assignment_action_id, -- FOR CALCULATION
1826: DECODE (
1827: SIGN (
1828: NVL (
1829: pay_balance_pkg.get_value (
1830: pay_ie_p35.get_defined_balance_id (
1831: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
1832: 'IE Net Tax'
1833: ),
1920:
1921: NVL (TRIM (RPAD (ppf.per_information1, 30)), ' '), --MOTHERS_NAME
1922: DECODE (
1923: SIGN (
1924: pay_balance_pkg.get_value (
1925: pay_ie_p35.get_defined_balance_id (
1926: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made--6633719
1927: 'IE Net Tax'
1928: ),
1942: ), --Q1_PR_Indicator
1943: NVL (
1944: ROUND (
1945: TO_NUMBER (
1946: pay_balance_pkg.get_value (
1947: pay_ie_p35.get_defined_balance_id (
1948: '_ASG_YTD',
1949: 'IE P45 Pay'
1950: ),
1957: ), -- Q1_Previous_Emp_Pay
1958: NVL (
1959: ROUND (
1960: TO_NUMBER (
1961: pay_balance_pkg.get_value (
1962: pay_ie_p35.get_defined_balance_id (
1963: '_ASG_YTD',
1964: 'IE P45 Tax Deducted'
1965: ),
1973: --14659262
1974: ,NVL (
1975: ROUND (
1976: TO_NUMBER (
1977: pay_balance_pkg.get_value (
1978: pay_ie_p35.get_defined_balance_id (
1979: '_ASG_YTD',
1980: 'IE P45 USC Pay'
1981: ),
1988: ) -- Q1_Previous_Emp_Pay_USC
1989: ,NVL (
1990: ROUND (
1991: TO_NUMBER (
1992: pay_balance_pkg.get_value (
1993: pay_ie_p35.get_defined_balance_id (
1994: '_ASG_YTD',
1995: 'IE P45 USC Deducted'
1996: ),
2062: paa.assignment_action_id, -- FOR CALCULATION
2063: DECODE (
2064: SIGN (
2065: NVL (
2066: pay_balance_pkg.get_value (
2067: pay_ie_p35.get_defined_balance_id (
2068: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made--6633719
2069: 'IE Net Tax'
2070: ),
2158:
2159: NVL (TRIM (RPAD (ppf.per_information1, 30)), ' '), -- MOTHERS_NAME
2160: DECODE (
2161: SIGN (
2162: pay_balance_pkg.get_value (
2163: pay_ie_p35.get_defined_balance_id (
2164: p_dimension_name, ---'_PER_PAYE_REF_YTD', -- changes made--6633719
2165: 'IE Net Tax'
2166: ),
2180: ), --Q1_PR_Indicator
2181: NVL (
2182: ROUND (
2183: TO_NUMBER (
2184: pay_balance_pkg.get_value (
2185: pay_ie_p35.get_defined_balance_id (
2186: '_ASG_YTD',
2187: 'IE P45 Pay'
2188: ),
2195: ), -- Q1_Previous_Emp_Pay
2196: NVL (
2197: ROUND (
2198: TO_NUMBER (
2199: pay_balance_pkg.get_value (
2200: pay_ie_p35.get_defined_balance_id (
2201: '_ASG_YTD',
2202: 'IE P45 Tax Deducted'
2203: ),
2211: --14659262
2212: ,NVL (
2213: ROUND (
2214: TO_NUMBER (
2215: pay_balance_pkg.get_value (
2216: pay_ie_p35.get_defined_balance_id (
2217: '_ASG_YTD',
2218: 'IE P45 USC Pay'
2219: ),
2226: ) -- Q1_Previous_Emp_Pay_USC
2227: ,NVL (
2228: ROUND (
2229: TO_NUMBER (
2230: pay_balance_pkg.get_value (
2231: pay_ie_p35.get_defined_balance_id (
2232: '_ASG_YTD',
2233: 'IE P45 USC Deducted'
2234: ),
2886: l_arch_pay :=
2887: TO_CHAR (
2888: ROUND (
2889: NVL (
2890: pay_balance_pkg.get_value (
2891: pay_ie_p35.get_defined_balance_id (
2892: l_dimension_name,
2893: 'IE Taxable Pay'
2894: ),
2923: l_arch_net_tax :=
2924: TO_CHAR (
2925: ROUND (
2926: NVL (
2927: pay_balance_pkg.get_value (
2928: pay_ie_p35.get_defined_balance_id (
2929: l_dimension_name,
2930: 'IE Net Tax'
2931: ),
2960: l_arch_employees_prsi_cont :=
2961: TO_CHAR (
2962: ROUND (
2963: NVL (
2964: pay_balance_pkg.get_value (
2965: pay_ie_p35.get_defined_balance_id (
2966: l_dimension_name,
2967: 'IE PRSI Employee'
2968: ),
3003: l_temp_prsi_cont :=
3004: TO_CHAR (
3005: ROUND (
3006: NVL (
3007: pay_balance_pkg.get_value (
3008: pay_ie_p35.get_defined_balance_id (
3009: l_dimension_name,
3010: 'IE PRSI K Employee Lump Sum'
3011: ),
3048: l_temp_prsi_cont :=
3049: TO_CHAR (
3050: ROUND (
3051: NVL (
3052: pay_balance_pkg.get_value (
3053: pay_ie_p35.get_defined_balance_id (
3054: l_dimension_name,
3055: 'IE PRSI M Employee Lump Sum'
3056: ),
3093: l_arch_employer_prsi_cont :=
3094: TO_CHAR (
3095: ROUND (
3096: NVL (
3097: pay_balance_pkg.get_value (
3098: pay_ie_p35.get_defined_balance_id (
3099: l_dimension_name,
3100: 'IE PRSI Employer'
3101: ),
3131: l_temp_prsi_cont :=
3132: TO_CHAR (
3133: ROUND (
3134: NVL (
3135: pay_balance_pkg.get_value (
3136: pay_ie_p35.get_defined_balance_id (
3137: l_dimension_name,
3138: 'IE PRSI K Employer Lump Sum'
3139: ),
3176: l_temp_prsi_cont :=
3177: TO_CHAR (
3178: ROUND (
3179: NVL (
3180: pay_balance_pkg.get_value (
3181: pay_ie_p35.get_defined_balance_id (
3182: l_dimension_name,
3183: 'IE PRSI M Employer Lump Sum'
3184: ),
3223: l_arch_total_notional_pay :=
3224: TO_CHAR (
3225: ROUND (
3226: NVL (
3227: pay_balance_pkg.get_value (
3228: pay_ie_p35.get_defined_balance_id (
3229: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3230: 'IE BIK Taxable and PRSIable Pay'
3231: ),
3249: l_arch_total_share_scheme :=
3250: TO_CHAR (
3251: ROUND (
3252: NVL (
3253: pay_balance_pkg.get_value (
3254: pay_ie_p35.get_defined_balance_id (
3255: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3256: 'P35 Notional Pay Adjust Balance' --'IE Share Schemes'
3257: ),
3275: l_p35_taxable_pay_adjust :=
3276: TO_CHAR (
3277: ROUND (
3278: NVL (
3279: pay_balance_pkg.get_value (
3280: pay_ie_p35.get_defined_balance_id (
3281: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3282: 'P35 Taxable Pay Adjust Balance'
3283: ),
3301: l_p35_gross_pay_adjust :=
3302: TO_CHAR (
3303: ROUND (
3304: NVL (
3305: pay_balance_pkg.get_value (
3306: pay_ie_p35.get_defined_balance_id (
3307: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3308: 'P35 Gross Pay Adjust Balance'
3309: ),
3330: l_arch_pen_emp_rbs :=
3331: TO_CHAR (
3332: ROUND (
3333: NVL (
3334: pay_balance_pkg.get_value (
3335: pay_ie_p35.get_defined_balance_id (
3336: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3337: 'IE RBS EE Contribution'
3338: ),
3352: )
3353: +
3354: ROUND (
3355: NVL (
3356: pay_balance_pkg.get_value (
3357: pay_ie_p35.get_defined_balance_id (
3358: l_dimension_name, --'_PER_PAYE_REF_YTD', --6633719
3359: 'IE RBS EE AVC Contribution'
3360: ),
3377: l_arch_pen_empr_rbs :=
3378: TO_CHAR (
3379: ROUND (
3380: NVL (
3381: pay_balance_pkg.get_value (
3382: pay_ie_p35.get_defined_balance_id (
3383: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
3384: 'IE RBS ER Contribution'
3385: ),
3402: l_arch_pen_emp_prsa :=
3403: TO_CHAR (
3404: ROUND (
3405: NVL (
3406: pay_balance_pkg.get_value (
3407: pay_ie_p35.get_defined_balance_id (
3408: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
3409: 'IE PRSA EE Contribution'
3410: ),
3424: )
3425: +
3426: ROUND (
3427: NVL (
3428: pay_balance_pkg.get_value (
3429: pay_ie_p35.get_defined_balance_id (
3430: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
3431: 'IE PRSA EE AVC Contribution'
3432: ),
3449: l_arch_pen_empr_prsa :=
3450: TO_CHAR (
3451: ROUND (
3452: NVL (
3453: pay_balance_pkg.get_value (
3454: pay_ie_p35.get_defined_balance_id (
3455: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
3456: 'IE PRSA ER Contribution'
3457: ),
3474: l_arch_pen_emp_rac :=
3475: TO_CHAR (
3476: ROUND (
3477: NVL (
3478: pay_balance_pkg.get_value (
3479: pay_ie_p35.get_defined_balance_id (
3480: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
3481: 'IE RAC EE Contribution'
3482: ),
3506: l_temp_gross_pay :=
3507: TO_CHAR (
3508: ROUND (
3509: NVL (
3510: pay_balance_pkg.get_value (
3511: pay_ie_p35.get_defined_balance_id (
3512: l_dimension_name,
3513: 'IE Gross Income Adjustment'
3514: ),
3548: l_temp_gross_pay :=
3549: TO_CHAR (
3550: ROUND (
3551: NVL (
3552: pay_balance_pkg.get_value (
3553: pay_ie_p35.get_defined_balance_id (
3554: l_dimension_name,
3555: 'IE Gross Income'
3556: ),
3590: l_temp_gross_pay :=
3591: TO_CHAR (
3592: ROUND (
3593: NVL (
3594: pay_balance_pkg.get_value (
3595: pay_ie_p35.get_defined_balance_id (
3596: l_dimension_name,
3597: 'IE BIK Taxable and PRSIable Pay'
3598: ),
3633: l_temp_income_levy :=
3634: TO_CHAR (
3635: ROUND (
3636: NVL (
3637: pay_balance_pkg.get_value (
3638: pay_ie_p35.get_defined_balance_id (
3639: l_dimension_name,
3640: 'IE Income Tax Levy'
3641: ),
3677: l_temp_income_levy :=
3678: TO_CHAR (
3679: ROUND (
3680: NVL (
3681: pay_balance_pkg.get_value (
3682: pay_ie_p35.get_defined_balance_id (
3683: l_dimension_name,
3684: 'IE Income Tax Levy Refund Amount'
3685: ),
3720: l_arch_income_levy_first :=
3721: TO_CHAR (
3722: ROUND (
3723: NVL (
3724: pay_balance_pkg.get_value (
3725: pay_ie_p35.get_defined_balance_id (
3726: l_dimension_name,
3727: 'IE Income Tax Levy First Band'
3728: ),
3758: l_arch_income_levy_second :=
3759: TO_CHAR (
3760: ROUND (
3761: NVL (
3762: pay_balance_pkg.get_value (
3763: pay_ie_p35.get_defined_balance_id (
3764: l_dimension_name,
3765: 'IE Income Tax Levy Second Band'
3766: ),
3797: l_arch_income_levy_third :=
3798: TO_CHAR (
3799: ROUND (
3800: NVL (
3801: pay_balance_pkg.get_value (
3802: pay_ie_p35.get_defined_balance_id (
3803: l_dimension_name,
3804: 'IE Income Tax Levy Third Band'
3805: ),
3836: l_arch_illness_benefit :=
3837: TO_CHAR (
3838: ROUND (
3839: NVL (
3840: pay_balance_pkg.get_value (
3841: pay_ie_p35.get_defined_balance_id (
3842: l_dimension_name,
3843: 'IE Illness Benefit'
3844: ),
3875: l_arch_parking_levy :=
3876: TO_CHAR (
3877: ROUND (
3878: NVL (
3879: pay_balance_pkg.get_value (
3880: pay_ie_p35.get_defined_balance_id (
3881: l_dimension_name,
3882: 'IE Parking Levy'
3883: ),
3909: l_medical_insurance :=
3910: TO_CHAR (
3911: ROUND (
3912: NVL (
3913: pay_balance_pkg.get_value (
3914: pay_ie_p35.get_defined_balance_id (
3915: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
3916: 'IE BIK Medical Insurance'
3917: ),
3937: l_arch_non_tax_pay :=
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: 'Total Pay'
3945: ),
3987: l_temp_gross_pay_usc :=
3988: TO_CHAR (
3989: ROUND (
3990: NVL (
3991: pay_balance_pkg.get_value (
3992: pay_ie_p35.get_defined_balance_id (
3993: l_dimension_name,
3994: 'IE Gross Income Adjustment'
3995: ),
4029: l_temp_gross_pay_usc :=
4030: TO_CHAR (
4031: ROUND (
4032: NVL (
4033: pay_balance_pkg.get_value (
4034: pay_ie_p35.get_defined_balance_id (
4035: l_dimension_name,
4036: 'IE USCable Pay'
4037: ),
4071: l_temp_gross_pay_usc :=
4072: TO_CHAR (
4073: ROUND (
4074: NVL (
4075: pay_balance_pkg.get_value (
4076: pay_ie_p35.get_defined_balance_id (
4077: l_dimension_name,
4078: 'IE BIK Taxable and PRSIable Pay'
4079: ),
4114: l_temp_gross_pay_usc :=
4115: TO_CHAR (
4116: ROUND (
4117: NVL (
4118: pay_balance_pkg.get_value (
4119: pay_ie_p35.get_defined_balance_id (
4120: l_dimension_name,
4121: 'IE Court Order'
4122: ),
4159: l_temp_gross_pay_usc :=
4160: TO_CHAR (
4161: ROUND (
4162: NVL (
4163: pay_balance_pkg.get_value (
4164: pay_ie_p35.get_defined_balance_id (
4165: l_dimension_name,
4166: 'IE Court Order Child Portion'
4167: ),
4205: l_temp_gross_pay_usc :=
4206: TO_CHAR (
4207: ROUND (
4208: NVL (
4209: pay_balance_pkg.get_value (
4210: pay_ie_p35.get_defined_balance_id (
4211: l_dimension_name,
4212: 'IE PRSA ER Contribution'
4213: ),
4250: l_temp_usc :=
4251: TO_CHAR (
4252: ROUND (
4253: NVL (
4254: pay_balance_pkg.get_value (
4255: pay_ie_p35.get_defined_balance_id (
4256: l_dimension_name,
4257: 'IE USC Balance'
4258: ),
4293: l_arch_usc_first :=
4294: TO_CHAR (
4295: ROUND (
4296: NVL (
4297: pay_balance_pkg.get_value (
4298: pay_ie_p35.get_defined_balance_id (
4299: l_dimension_name,
4300: 'IE USC First Band'
4301: ),
4331: l_arch_usc_second :=
4332: TO_CHAR (
4333: ROUND (
4334: NVL (
4335: pay_balance_pkg.get_value (
4336: pay_ie_p35.get_defined_balance_id (
4337: l_dimension_name,
4338: 'IE USC Second Band'
4339: ),
4370: l_arch_usc_third :=
4371: TO_CHAR (
4372: ROUND (
4373: NVL (
4374: pay_balance_pkg.get_value (
4375: pay_ie_p35.get_defined_balance_id (
4376: l_dimension_name,
4377: 'IE USC Third Band'
4378: ),
4490: l_arch_net_tax :=
4491: TO_CHAR (
4492: ROUND (
4493: NVL (
4494: pay_balance_pkg.get_value (
4495: pay_ie_p35.get_defined_balance_id (
4496: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4497: 'IE Net Tax'
4498: ),
4515: l_arch_employees_prsi_cont :=
4516: TO_CHAR (
4517: ROUND (
4518: NVL (
4519: pay_balance_pkg.get_value (
4520: pay_ie_p35.get_defined_balance_id (
4521: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4522: 'IE PRSI Employee'
4523: ),
4533: ),
4534: 0
4535: )
4536: + NVL (
4537: pay_balance_pkg.get_value (
4538: pay_ie_p35.get_defined_balance_id (
4539: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4540: 'IE PRSI K Employee Lump Sum'
4541: ),
4551: ),
4552: 0
4553: )
4554: + NVL (
4555: pay_balance_pkg.get_value (
4556: pay_ie_p35.get_defined_balance_id (
4557: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4558: 'IE PRSI M Employee Lump Sum'
4559: ),
4576: l_arch_total_prsi_cont :=
4577: TO_CHAR (
4578: ROUND (
4579: NVL (
4580: pay_balance_pkg.get_value (
4581: pay_ie_p35.get_defined_balance_id (
4582: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4583: 'IE PRSI Employee'
4584: ),
4594: ),
4595: 0
4596: )
4597: + NVL (
4598: pay_balance_pkg.get_value (
4599: pay_ie_p35.get_defined_balance_id (
4600: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4601: 'IE PRSI Employer'
4602: ),
4612: ),
4613: 0
4614: )
4615: + NVL (
4616: pay_balance_pkg.get_value (
4617: pay_ie_p35.get_defined_balance_id (
4618: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4619: 'IE PRSI K Employee Lump Sum'
4620: ),
4630: ),
4631: 0
4632: )
4633: + NVL (
4634: pay_balance_pkg.get_value (
4635: pay_ie_p35.get_defined_balance_id (
4636: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4637: 'IE PRSI M Employee Lump Sum'
4638: ),
4648: ),
4649: 0
4650: )
4651: + NVL (
4652: pay_balance_pkg.get_value (
4653: pay_ie_p35.get_defined_balance_id (
4654: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4655: 'IE PRSI K Employer Lump Sum'
4656: ),
4666: ),
4667: 0
4668: )
4669: + NVL (
4670: pay_balance_pkg.get_value (
4671: pay_ie_p35.get_defined_balance_id (
4672: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4673: 'IE PRSI M Employer Lump Sum'
4674: ),
4691: l_arch_pay :=
4692: TO_CHAR (
4693: ROUND (
4694: NVL (
4695: pay_balance_pkg.get_value (
4696: pay_ie_p35.get_defined_balance_id (
4697: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4698: 'IE Taxable Pay'
4699: ),
4716: l_arch_total_notional_pay :=
4717: TO_CHAR (
4718: ROUND (
4719: NVL (
4720: pay_balance_pkg.get_value (
4721: pay_ie_p35.get_defined_balance_id (
4722: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4723: 'IE BIK Taxable and PRSIable Pay'
4724: ),
4742: l_arch_total_share_scheme :=
4743: TO_CHAR (
4744: ROUND (
4745: NVL (
4746: pay_balance_pkg.get_value (
4747: pay_ie_p35.get_defined_balance_id (
4748: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4749: 'P35 Notional Pay Adjust Balance' --'IE Share Schemes'
4750: ),
4768: l_p35_taxable_pay_adjust :=
4769: TO_CHAR (
4770: ROUND (
4771: NVL (
4772: pay_balance_pkg.get_value (
4773: pay_ie_p35.get_defined_balance_id (
4774: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4775: 'P35 Taxable Pay Adjust Balance'
4776: ),
4794: l_p35_gross_pay_adjust :=
4795: TO_CHAR (
4796: ROUND (
4797: NVL (
4798: pay_balance_pkg.get_value (
4799: pay_ie_p35.get_defined_balance_id (
4800: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4801: 'P35 Gross Pay Adjust Balance'
4802: ),
4821: l_arch_pen_emp_rbs :=
4822: TO_CHAR (
4823: ROUND (
4824: NVL (
4825: pay_balance_pkg.get_value (
4826: pay_ie_p35.get_defined_balance_id (
4827: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4828: 'IE RBS EE Contribution'
4829: ),
4843: )
4844: +
4845: ROUND (
4846: NVL (
4847: pay_balance_pkg.get_value (
4848: pay_ie_p35.get_defined_balance_id (
4849: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4850: 'IE RBS EE AVC Contribution'
4851: ),
4868: l_arch_pen_empr_rbs :=
4869: TO_CHAR (
4870: ROUND (
4871: NVL (
4872: pay_balance_pkg.get_value (
4873: pay_ie_p35.get_defined_balance_id (
4874: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4875: 'IE RBS ER Contribution'
4876: ),
4893: l_arch_pen_emp_prsa :=
4894: TO_CHAR (
4895: ROUND (
4896: NVL (
4897: pay_balance_pkg.get_value (
4898: pay_ie_p35.get_defined_balance_id (
4899: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4900: 'IE PRSA EE Contribution'
4901: ),
4915: )
4916: +
4917: ROUND (
4918: NVL (
4919: pay_balance_pkg.get_value (
4920: pay_ie_p35.get_defined_balance_id (
4921: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4922: 'IE PRSA EE AVC Contribution'
4923: ),
4940: l_arch_pen_empr_prsa :=
4941: TO_CHAR (
4942: ROUND (
4943: NVL (
4944: pay_balance_pkg.get_value (
4945: pay_ie_p35.get_defined_balance_id (
4946: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4947: 'IE PRSA ER Contribution'
4948: ),
4965: l_arch_pen_emp_rac :=
4966: TO_CHAR (
4967: ROUND (
4968: NVL (
4969: pay_balance_pkg.get_value (
4970: pay_ie_p35.get_defined_balance_id (
4971: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
4972: 'IE RAC EE Contribution'
4973: ),
4994: l_arch_gross_pay :=
4995: TO_CHAR (
4996: ROUND (
4997: NVL (
4998: pay_balance_pkg.get_value (
4999: pay_ie_p35.get_defined_balance_id (
5000: l_dimension_name,
5001: 'IE Gross Income Adjustment'
5002: ),
5020:
5021: TO_CHAR (
5022: ROUND (
5023: NVL (
5024: pay_balance_pkg.get_value (
5025: pay_ie_p35.get_defined_balance_id (
5026: l_dimension_name,
5027: 'IE Gross Income'
5028: ),
5044: +
5045: TO_CHAR (
5046: ROUND (
5047: NVL (
5048: pay_balance_pkg.get_value (
5049: pay_ie_p35.get_defined_balance_id (
5050: l_dimension_name,
5051: 'IE BIK Taxable and PRSIable Pay'
5052: ),
5071: l_arch_income_levy :=
5072: TO_CHAR (
5073: ROUND (
5074: NVL (
5075: pay_balance_pkg.get_value (
5076: pay_ie_p35.get_defined_balance_id (
5077: l_dimension_name,
5078: 'IE Income Tax Levy'
5079: ),
5097: +
5098: TO_CHAR (
5099: ROUND (
5100: NVL (
5101: pay_balance_pkg.get_value (
5102: pay_ie_p35.get_defined_balance_id (
5103: l_dimension_name,
5104: 'IE Income Tax Levy Refund Amount'
5105: ),
5124: l_arch_income_levy_first :=
5125: TO_CHAR (
5126: ROUND (
5127: NVL (
5128: pay_balance_pkg.get_value (
5129: pay_ie_p35.get_defined_balance_id (
5130: l_dimension_name,
5131: 'IE Income Tax Levy First Band'
5132: ),
5150: l_arch_income_levy_second :=
5151: TO_CHAR (
5152: ROUND (
5153: NVL (
5154: pay_balance_pkg.get_value (
5155: pay_ie_p35.get_defined_balance_id (
5156: l_dimension_name,
5157: 'IE Income Tax Levy Second Band'
5158: ),
5176: l_arch_income_levy_third :=
5177: TO_CHAR (
5178: ROUND (
5179: NVL (
5180: pay_balance_pkg.get_value (
5181: pay_ie_p35.get_defined_balance_id (
5182: l_dimension_name,
5183: 'IE Income Tax Levy Third Band'
5184: ),
5205: l_arch_illness_benefit :=
5206: TO_CHAR (
5207: ROUND (
5208: NVL (
5209: pay_balance_pkg.get_value (
5210: pay_ie_p35.get_defined_balance_id (
5211: l_dimension_name,
5212: 'IE Illness Benefit'
5213: ),
5232: l_arch_parking_levy :=
5233: TO_CHAR (
5234: ROUND (
5235: NVL (
5236: pay_balance_pkg.get_value (
5237: pay_ie_p35.get_defined_balance_id (
5238: l_dimension_name,
5239: 'IE Parking Levy'
5240: ),
5257: l_medical_insurance :=
5258: TO_CHAR (
5259: ROUND (
5260: NVL (
5261: pay_balance_pkg.get_value (
5262: pay_ie_p35.get_defined_balance_id (
5263: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5264: 'IE BIK Medical Insurance'
5265: ),
5286: l_arch_gross_pay_usc :=
5287: TO_CHAR (
5288: ROUND (
5289: NVL (
5290: pay_balance_pkg.get_value (
5291: pay_ie_p35.get_defined_balance_id (
5292: l_dimension_name,
5293: 'IE Gross Income Adjustment'
5294: ),
5312:
5313: TO_CHAR (
5314: ROUND (
5315: NVL (
5316: pay_balance_pkg.get_value (
5317: pay_ie_p35.get_defined_balance_id (
5318: l_dimension_name,
5319: 'IE USCable Pay'
5320: ),
5336: +
5337: TO_CHAR (
5338: ROUND (
5339: NVL (
5340: pay_balance_pkg.get_value (
5341: pay_ie_p35.get_defined_balance_id (
5342: l_dimension_name,
5343: 'IE BIK Taxable and PRSIable Pay'
5344: ),
5360: -
5361: TO_CHAR (
5362: ROUND (
5363: NVL (
5364: pay_balance_pkg.get_value (
5365: pay_ie_p35.get_defined_balance_id (
5366: l_dimension_name,
5367: 'IE Court Order'
5368: ),
5385: +
5386: TO_CHAR (
5387: ROUND (
5388: NVL (
5389: pay_balance_pkg.get_value (
5390: pay_ie_p35.get_defined_balance_id (
5391: l_dimension_name,
5392: 'IE Court Order Child Portion'
5393: ),
5411: +
5412: TO_CHAR (
5413: ROUND (
5414: NVL (
5415: pay_balance_pkg.get_value (
5416: pay_ie_p35.get_defined_balance_id (
5417: l_dimension_name,
5418: 'IE PRSA ER Contribution'
5419: ),
5439: l_arch_usc :=
5440: TO_CHAR (
5441: ROUND (
5442: NVL (
5443: pay_balance_pkg.get_value (
5444: pay_ie_p35.get_defined_balance_id (
5445: l_dimension_name,
5446: 'IE USC Balance'
5447: ),
5465: l_arch_usc_first :=
5466: TO_CHAR (
5467: ROUND (
5468: NVL (
5469: pay_balance_pkg.get_value (
5470: pay_ie_p35.get_defined_balance_id (
5471: l_dimension_name,
5472: 'IE USC First Band'
5473: ),
5491: l_arch_usc_second :=
5492: TO_CHAR (
5493: ROUND (
5494: NVL (
5495: pay_balance_pkg.get_value (
5496: pay_ie_p35.get_defined_balance_id (
5497: l_dimension_name,
5498: 'IE USC Second Band'
5499: ),
5517: l_arch_usc_third :=
5518: TO_CHAR (
5519: ROUND (
5520: NVL (
5521: pay_balance_pkg.get_value (
5522: pay_ie_p35.get_defined_balance_id (
5523: l_dimension_name,
5524: 'IE USC Third Band'
5525: ),
5547: l_arch_non_tax_pay :=
5548: TO_CHAR (
5549: ROUND (
5550: NVL (
5551: pay_balance_pkg.get_value (
5552: pay_ie_p35.get_defined_balance_id (
5553: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5554: 'Total Pay'
5555: ),
5624: l_arch_net_tax :=
5625: TO_CHAR (
5626: ROUND (
5627: NVL (
5628: pay_balance_pkg.get_value (
5629: pay_ie_p35.get_defined_balance_id (
5630: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5631: 'IE Net Tax'
5632: ),
5649: l_arch_employees_prsi_cont :=
5650: TO_CHAR (
5651: ROUND (
5652: NVL (
5653: pay_balance_pkg.get_value (
5654: pay_ie_p35.get_defined_balance_id (
5655: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5656: 'IE PRSI Employee'
5657: ),
5667: ),
5668: 0
5669: )
5670: + NVL (
5671: pay_balance_pkg.get_value (
5672: pay_ie_p35.get_defined_balance_id (
5673: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5674: 'IE PRSI K Employee Lump Sum'
5675: ),
5685: ),
5686: 0
5687: )
5688: + NVL (
5689: pay_balance_pkg.get_value (
5690: pay_ie_p35.get_defined_balance_id (
5691: '_PER_YTD',
5692: 'IE PRSI M Employee Lump Sum'
5693: ),
5711: l_arch_total_prsi_cont :=
5712: TO_CHAR (
5713: ROUND (
5714: NVL (
5715: pay_balance_pkg.get_value (
5716: pay_ie_p35.get_defined_balance_id (
5717: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5718: 'IE PRSI Employee'
5719: ),
5729: ),
5730: 0
5731: )
5732: + NVL (
5733: pay_balance_pkg.get_value (
5734: pay_ie_p35.get_defined_balance_id (
5735: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5736: 'IE PRSI Employer'
5737: ),
5747: ),
5748: 0
5749: )
5750: + NVL (
5751: pay_balance_pkg.get_value (
5752: pay_ie_p35.get_defined_balance_id (
5753: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5754: 'IE PRSI K Employee Lump Sum'
5755: ),
5765: ),
5766: 0
5767: )
5768: + NVL (
5769: pay_balance_pkg.get_value (
5770: pay_ie_p35.get_defined_balance_id (
5771: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5772: 'IE PRSI M Employee Lump Sum'
5773: ),
5783: ),
5784: 0
5785: )
5786: + NVL (
5787: pay_balance_pkg.get_value (
5788: pay_ie_p35.get_defined_balance_id (
5789: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5790: 'IE PRSI K Employer Lump Sum'
5791: ),
5801: ),
5802: 0
5803: )
5804: + NVL (
5805: pay_balance_pkg.get_value (
5806: pay_ie_p35.get_defined_balance_id (
5807: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5808: 'IE PRSI M Employer Lump Sum'
5809: ),
5826: l_arch_pay :=
5827: TO_CHAR (
5828: ROUND (
5829: NVL (
5830: pay_balance_pkg.get_value (
5831: pay_ie_p35.get_defined_balance_id (
5832: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5833: 'IE Taxable Pay'
5834: ),
5855: l_arch_total_notional_pay :=
5856: TO_CHAR (
5857: ROUND (
5858: NVL (
5859: pay_balance_pkg.get_value (
5860: pay_ie_p35.get_defined_balance_id (
5861: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
5862: 'IE BIK Taxable and PRSIable Pay'
5863: ),
5881: l_arch_total_share_scheme :=
5882: TO_CHAR (
5883: ROUND (
5884: NVL (
5885: pay_balance_pkg.get_value (
5886: pay_ie_p35.get_defined_balance_id (
5887: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
5888: 'P35 Notional Pay Adjust Balance' --'IE Share Schemes'
5889: ),
5907: l_p35_taxable_pay_adjust :=
5908: TO_CHAR (
5909: ROUND (
5910: NVL (
5911: pay_balance_pkg.get_value (
5912: pay_ie_p35.get_defined_balance_id (
5913: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
5914: 'P35 Taxable Pay Adjust Balance'
5915: ),
5933: l_p35_gross_pay_adjust :=
5934: TO_CHAR (
5935: ROUND (
5936: NVL (
5937: pay_balance_pkg.get_value (
5938: pay_ie_p35.get_defined_balance_id (
5939: l_dimension_name, ---'_PER_PAYE_REF_YTD',--6633719
5940: 'P35 Gross Pay Adjust Balance'
5941: ),
5960: l_arch_pen_emp_rbs :=
5961: TO_CHAR (
5962: ROUND (
5963: NVL (
5964: pay_balance_pkg.get_value (
5965: pay_ie_p35.get_defined_balance_id (
5966: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5967: 'IE RBS EE Contribution'
5968: ),
5982: )
5983: +
5984: ROUND (
5985: NVL (
5986: pay_balance_pkg.get_value (
5987: pay_ie_p35.get_defined_balance_id (
5988: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
5989: 'IE RBS EE AVC Contribution'
5990: ),
6007: l_arch_pen_empr_rbs :=
6008: TO_CHAR (
6009: ROUND (
6010: NVL (
6011: pay_balance_pkg.get_value (
6012: pay_ie_p35.get_defined_balance_id (
6013: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6014: 'IE RBS ER Contribution'
6015: ),
6032: l_arch_pen_emp_prsa :=
6033: TO_CHAR (
6034: ROUND (
6035: NVL (
6036: pay_balance_pkg.get_value (
6037: pay_ie_p35.get_defined_balance_id (
6038: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6039: 'IE PRSA EE Contribution'
6040: ),
6054: )
6055: +
6056: ROUND (
6057: NVL (
6058: pay_balance_pkg.get_value (
6059: pay_ie_p35.get_defined_balance_id (
6060: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6061: 'IE PRSA EE AVC Contribution'
6062: ),
6079: l_arch_pen_empr_prsa :=
6080: TO_CHAR (
6081: ROUND (
6082: NVL (
6083: pay_balance_pkg.get_value (
6084: pay_ie_p35.get_defined_balance_id (
6085: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6086: 'IE PRSA ER Contribution'
6087: ),
6104: l_arch_pen_emp_rac :=
6105: TO_CHAR (
6106: ROUND (
6107: NVL (
6108: pay_balance_pkg.get_value (
6109: pay_ie_p35.get_defined_balance_id (
6110: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6111: 'IE RAC EE Contribution'
6112: ),
6133: l_arch_gross_pay :=
6134: TO_CHAR (
6135: ROUND (
6136: NVL (
6137: pay_balance_pkg.get_value (
6138: pay_ie_p35.get_defined_balance_id (
6139: l_dimension_name,
6140: 'IE Gross Income Adjustment'
6141: ),
6159:
6160: TO_CHAR (
6161: ROUND (
6162: NVL (
6163: pay_balance_pkg.get_value (
6164: pay_ie_p35.get_defined_balance_id (
6165: l_dimension_name,
6166: 'IE Gross Income'
6167: ),
6183: +
6184: TO_CHAR (
6185: ROUND (
6186: NVL (
6187: pay_balance_pkg.get_value (
6188: pay_ie_p35.get_defined_balance_id (
6189: l_dimension_name,
6190: 'IE BIK Taxable and PRSIable Pay'
6191: ),
6210: l_arch_income_levy :=
6211: TO_CHAR (
6212: ROUND (
6213: NVL (
6214: pay_balance_pkg.get_value (
6215: pay_ie_p35.get_defined_balance_id (
6216: l_dimension_name,
6217: 'IE Income Tax Levy'
6218: ),
6236: +
6237: TO_CHAR (
6238: ROUND (
6239: NVL (
6240: pay_balance_pkg.get_value (
6241: pay_ie_p35.get_defined_balance_id (
6242: l_dimension_name,
6243: 'IE Income Tax Levy Refund Amount'
6244: ),
6263: l_arch_income_levy_first :=
6264: TO_CHAR (
6265: ROUND (
6266: NVL (
6267: pay_balance_pkg.get_value (
6268: pay_ie_p35.get_defined_balance_id (
6269: l_dimension_name,
6270: 'IE Income Tax Levy First Band'
6271: ),
6289: l_arch_income_levy_second :=
6290: TO_CHAR (
6291: ROUND (
6292: NVL (
6293: pay_balance_pkg.get_value (
6294: pay_ie_p35.get_defined_balance_id (
6295: l_dimension_name,
6296: 'IE Income Tax Levy Second Band'
6297: ),
6315: l_arch_income_levy_third :=
6316: TO_CHAR (
6317: ROUND (
6318: NVL (
6319: pay_balance_pkg.get_value (
6320: pay_ie_p35.get_defined_balance_id (
6321: l_dimension_name,
6322: 'IE Income Tax Levy Third Band'
6323: ),
6344: l_arch_illness_benefit :=
6345: TO_CHAR (
6346: ROUND (
6347: NVL (
6348: pay_balance_pkg.get_value (
6349: pay_ie_p35.get_defined_balance_id (
6350: l_dimension_name,
6351: 'IE Illness Benefit'
6352: ),
6371: l_arch_parking_levy :=
6372: TO_CHAR (
6373: ROUND (
6374: NVL (
6375: pay_balance_pkg.get_value (
6376: pay_ie_p35.get_defined_balance_id (
6377: l_dimension_name,
6378: 'IE Parking Levy'
6379: ),
6396: l_medical_insurance :=
6397: TO_CHAR (
6398: ROUND (
6399: NVL (
6400: pay_balance_pkg.get_value (
6401: pay_ie_p35.get_defined_balance_id (
6402: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6403: 'IE BIK Medical Insurance'
6404: ),
6424: l_arch_gross_pay_usc :=
6425: TO_CHAR (
6426: ROUND (
6427: NVL (
6428: pay_balance_pkg.get_value (
6429: pay_ie_p35.get_defined_balance_id (
6430: l_dimension_name,
6431: 'IE Gross Income Adjustment'
6432: ),
6450:
6451: TO_CHAR (
6452: ROUND (
6453: NVL (
6454: pay_balance_pkg.get_value (
6455: pay_ie_p35.get_defined_balance_id (
6456: l_dimension_name,
6457: 'IE USCable Pay'
6458: ),
6474: +
6475: TO_CHAR (
6476: ROUND (
6477: NVL (
6478: pay_balance_pkg.get_value (
6479: pay_ie_p35.get_defined_balance_id (
6480: l_dimension_name,
6481: 'IE BIK Taxable and PRSIable Pay'
6482: ),
6498: -
6499: TO_CHAR (
6500: ROUND (
6501: NVL (
6502: pay_balance_pkg.get_value (
6503: pay_ie_p35.get_defined_balance_id (
6504: l_dimension_name,
6505: 'IE Court Order'
6506: ),
6523: +
6524: TO_CHAR (
6525: ROUND (
6526: NVL (
6527: pay_balance_pkg.get_value (
6528: pay_ie_p35.get_defined_balance_id (
6529: l_dimension_name,
6530: 'IE Court Order Child Portion'
6531: ),
6549: +
6550: TO_CHAR (
6551: ROUND (
6552: NVL (
6553: pay_balance_pkg.get_value (
6554: pay_ie_p35.get_defined_balance_id (
6555: l_dimension_name,
6556: 'IE PRSA ER Contribution'
6557: ),
6577: l_arch_usc :=
6578: TO_CHAR (
6579: ROUND (
6580: NVL (
6581: pay_balance_pkg.get_value (
6582: pay_ie_p35.get_defined_balance_id (
6583: l_dimension_name,
6584: 'IE USC Balance'
6585: ),
6603: l_arch_usc_first :=
6604: TO_CHAR (
6605: ROUND (
6606: NVL (
6607: pay_balance_pkg.get_value (
6608: pay_ie_p35.get_defined_balance_id (
6609: l_dimension_name,
6610: 'IE USC First Band'
6611: ),
6629: l_arch_usc_second :=
6630: TO_CHAR (
6631: ROUND (
6632: NVL (
6633: pay_balance_pkg.get_value (
6634: pay_ie_p35.get_defined_balance_id (
6635: l_dimension_name,
6636: 'IE USC Second Band'
6637: ),
6655: l_arch_usc_third :=
6656: TO_CHAR (
6657: ROUND (
6658: NVL (
6659: pay_balance_pkg.get_value (
6660: pay_ie_p35.get_defined_balance_id (
6661: l_dimension_name,
6662: 'IE USC Third Band'
6663: ),
6685: l_arch_non_tax_pay :=
6686: TO_CHAR (
6687: ROUND (
6688: NVL (
6689: pay_balance_pkg.get_value (
6690: pay_ie_p35.get_defined_balance_id (
6691: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
6692: 'Total Pay'
6693: ),
6741: END IF;
6742: l_arch_previous_emp_pay := NVL (
6743: ROUND (
6744: TO_NUMBER (
6745: pay_balance_pkg.get_value (
6746: pay_ie_p35.get_defined_balance_id (
6747: '_ASG_YTD',
6748: 'IE P45 Pay'
6749: ),
6758: --14659262
6759: l_arch_previous_emp_pay_usc := NVL (
6760: ROUND (
6761: TO_NUMBER (
6762: pay_balance_pkg.get_value (
6763: pay_ie_p35.get_defined_balance_id (
6764: '_ASG_YTD',
6765: 'IE P45 USC Pay'
6766: ),
6776:
6777: l_arch_previous_emp_tax := NVL (
6778: ROUND (
6779: TO_NUMBER (
6780: pay_balance_pkg.get_value (
6781: pay_ie_p35.get_defined_balance_id (
6782: '_ASG_YTD',
6783: 'IE P45 Tax Deducted'
6784: ),
6794: --14659262
6795: l_arch_previous_emp_usc := NVL (
6796: ROUND (
6797: TO_NUMBER (
6798: pay_balance_pkg.get_value (
6799: pay_ie_p35.get_defined_balance_id (
6800: '_ASG_YTD',
6801: 'IE P45 USC Deducted'
6802: ),
7087: hr_utility.set_location('l_arch_pay..'||l_arch_pay,5004);
7088: hr_utility.set_location('l_aact_id..'||l_aact_id,5004);
7089: IF l_aact_id IS NOT NULL THEN
7090: -- for bug 5435931.
7091: l_this_pay := l_arch_pay - pay_balance_pkg.get_value (
7092: pay_ie_p35.get_defined_balance_id (
7093: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7094: 'IE Taxable Pay'
7095: ),
7104: 'TRUE'
7105:
7106: );
7107: hr_utility.set_location('l_this_pay..'||l_this_pay,5004);
7108: l_this_tax := l_arch_net_tax - pay_balance_pkg.get_value (
7109: pay_ie_p35.get_defined_balance_id (
7110: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7111: 'IE Net Tax'
7112: ),
7122:
7123: );
7124: hr_utility.set_location('l_this_tax..'||l_this_tax,5004);
7125: /* 8978805 */
7126: l_arch_prev_gross_pay := pay_balance_pkg.get_value (
7127: pay_ie_p35.get_defined_balance_id (
7128: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7129: 'IE Gross Income'
7130: ),
7139: 'TRUE'
7140:
7141: );
7142: hr_utility.set_location('prev gross pay..'|| l_arch_prev_gross_pay,5004);
7143: l_arch_prev_gross_pay_adjust := pay_balance_pkg.get_value (
7144: pay_ie_p35.get_defined_balance_id (
7145: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7146: 'IE Gross Income Adjustment'
7147: ),
7156: 'TRUE'
7157:
7158: );
7159: hr_utility.set_location('prev gross pay adjust..'|| l_arch_prev_gross_pay_adjust,5004);
7160: l_arch_prev_gross_pay_BIK := pay_balance_pkg.get_value (
7161: pay_ie_p35.get_defined_balance_id (
7162: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7163: 'IE BIK Taxable and PRSIable Pay'
7164: ),
7177: l_arch_prev_gross_pay:=NVL(l_arch_prev_gross_pay,0) + NVL(l_arch_prev_gross_pay_adjust,0) + NVL(l_arch_prev_gross_pay_BIK,0);
7178: hr_utility.set_location('l_arch_prev_gross_pay '|| l_arch_prev_gross_pay,5004);
7179: l_arch_total_this_gross_pay:=l_arch_gross_pay - l_arch_prev_gross_pay;
7180: hr_utility.set_location('actual this gross pay..'|| l_arch_total_this_gross_pay,5004);
7181: l_arch_this_income_levy :=l_arch_income_levy - pay_balance_pkg.get_value (
7182: pay_ie_p35.get_defined_balance_id (
7183: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7184: 'IE Income Tax Levy'
7185: ),
7196: );
7197: hr_utility.set_location('l_arch_this_income_levy '|| l_arch_this_income_levy,5004);
7198:
7199: --11857084
7200: l_arch_prev_gross_pay_usc := pay_balance_pkg.get_value (
7201: pay_ie_p35.get_defined_balance_id (
7202: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7203: 'IE USCable Pay'
7204: ),
7213: 'TRUE'
7214:
7215: );
7216: hr_utility.set_location('prev gross pay usc..'|| l_arch_prev_gross_pay_usc,5004);
7217: l_arch_prev_gross_pay_adj_usc := pay_balance_pkg.get_value (
7218: pay_ie_p35.get_defined_balance_id (
7219: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7220: 'IE Gross Income Adjustment'
7221: ),
7230: 'TRUE'
7231:
7232: );
7233: hr_utility.set_location('prev gross pay adjust usc..'|| l_arch_prev_gross_pay_adj_usc,5004);
7234: l_arch_prev_gross_pay_BIK_usc := pay_balance_pkg.get_value (
7235: pay_ie_p35.get_defined_balance_id (
7236: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7237: 'IE BIK Taxable and PRSIable Pay'
7238: ),
7248:
7249: );
7250: hr_utility.set_location('prev BIK usc..'|| l_arch_prev_gross_pay_BIK_usc,5004);
7251:
7252: l_arch_prev_gross_pay_CO_usc := pay_balance_pkg.get_value (
7253: pay_ie_p35.get_defined_balance_id (
7254: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7255: 'IE Court Order'
7256: ),
7267: );
7268: hr_utility.set_location('prev CO usc..'|| l_arch_prev_gross_pay_CO_usc,5004);
7269:
7270: --11076169
7271: l_arch_prev_gross_pay_CP_usc := pay_balance_pkg.get_value (
7272: pay_ie_p35.get_defined_balance_id (
7273: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7274: 'IE Court Order Child Portion'
7275: ),
7287: hr_utility.set_location('prev CP usc..'|| l_arch_prev_gross_pay_CP_usc,5004);
7288: --11076169
7289:
7290: --16242337
7291: l_arch_prev_gross_pay_ERPRSA := pay_balance_pkg.get_value (
7292: pay_ie_p35.get_defined_balance_id (
7293: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7294: 'IE PRSA ER Contribution'
7295: ),
7318:
7319: l_arch_tot_this_gross_pay_usc := l_arch_gross_pay_usc - l_arch_prev_gross_pay_usc;
7320: hr_utility.set_location('actual this gross pay usc..'|| l_arch_tot_this_gross_pay_usc,5004);
7321:
7322: l_arch_this_usc :=l_arch_usc - pay_balance_pkg.get_value (
7323: pay_ie_p35.get_defined_balance_id (
7324: l_dimension_name, --'_PER_PAYE_REF_YTD',--6633719
7325: 'IE USC Balance'
7326: ),
8187: temp_flag := null;
8188: END IF;
8189: IF l_supp_wk_tab.EXISTS(l_supp_run_class) THEN
8190: l_supp_wk_tab(l_supp_run_class) := l_supp_wk_tab(l_supp_run_class) +
8191: pay_balance_pkg.get_value (
8192: get_defined_balance_id ('_ASG_PTD', 'IE PRSI Insurable Weeks'),
8193: l_type_context_name_tab(p).assignment_action_id,
8194: l_segment4,
8195: NULL,
8198: NULL,
8199: NULL
8200: );
8201: Else
8202: l_supp_wk_tab(l_supp_run_class) := pay_balance_pkg.get_value (
8203: get_defined_balance_id ('_ASG_PTD', 'IE PRSI Insurable Weeks'),
8204: l_type_context_name_tab(p).assignment_action_id,
8205: l_segment4,
8206: NULL,
8212: End If;
8213: ELSE
8214: IF l_supp_wk_tab.EXISTS(l_supp_run_class) THEN
8215: l_supp_wk_tab(l_supp_run_class) := l_supp_wk_tab(l_supp_run_class) -
8216: pay_balance_pkg.get_value (
8217: get_defined_balance_id ('_ASG_RUN', 'IE PRSI Insurable Weeks'),
8218: l_type_context_name_tab(p).assignment_action_id,
8219: l_segment4,
8220: NULL,
8223: NULL,
8224: NULL
8225: );
8226: Else
8227: l_supp_wk_tab(l_supp_run_class) := - (pay_balance_pkg.get_value (
8228: get_defined_balance_id ('_ASG_RUN', 'IE PRSI Insurable Weeks'),
8229: l_type_context_name_tab(p).assignment_action_id,
8230: l_segment4,
8231: NULL,
8596:
8597: l_weeks := 0;
8598:
8599: l_weeks := l_weeks +
8600: pay_balance_pkg.get_value (
8601: l_defined_balance_id,
8602: t_asg_action_id,
8603: l_segment4,
8604: NULL,
8629: l_initial_weeks := 0;
8630: --FOR csr_action_rec IN 1..t_asg_action_id.count
8631: --LOOP -- Bug fix 4004470
8632: l_initial_weeks := l_initial_weeks +
8633: pay_balance_pkg.get_value (
8634: l_defined_balance_id,
8635: t_asg_action_id,
8636: l_segment4,
8637: NULL,
8669: l_weeks_at_second_class := 0; --Bug fix 4023794, flusing of variables
8670: --FOR csr_action_rec IN 1..t_asg_action_id.count
8671: --LOOP
8672: l_weeks_at_second_class := l_weeks_at_second_class +
8673: pay_balance_pkg.get_value (
8674: l_defined_balance_id,
8675: -- l_assignment_action_id,
8676: t_asg_action_id,
8677: l_segment4,
8705: l_weeks_at_third_class := 0; --Bug fix 4023794, flusing of variables
8706: --FOR csr_action_rec IN 1..t_asg_action_id.count
8707: --LOOP
8708: l_weeks_at_third_class := l_weeks_at_third_class +
8709: pay_balance_pkg.get_value (
8710: l_defined_balance_id,
8711: --l_assignment_action_id,
8712: t_asg_action_id,
8713: l_segment4,
8740: l_weeks_at_fourth_class := 0; --Bug fix 4023794, flusing of variables
8741: --FOR csr_action_rec IN 1..t_asg_action_id.count
8742: --LOOP
8743: l_weeks_at_fourth_class := l_weeks_at_fourth_class +
8744: pay_balance_pkg.get_value (
8745: l_defined_balance_id,
8746: -- l_assignment_action_id,
8747: t_asg_action_id,
8748: l_segment4,
8776: IF l_fifth_class IS NOT NULL
8777: THEN
8778: l_weeks_at_fifth_class := 0;
8779: l_weeks_at_fifth_class := l_weeks_at_fifth_class +
8780: pay_balance_pkg.get_value (
8781: l_defined_balance_id,
8782: t_asg_action_id,
8783: l_segment4,
8784: NULL,
8834:
8835: l_total_weeks := 0;
8836: --Bug fix 4004470
8837: l_total_weeks :=l_total_weeks +
8838: nvl(pay_balance_pkg.get_value (
8839: pay_ie_p35.get_defined_balance_id (
8840: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
8841: 'IE PRSI Insurable Weeks'
8842: ),
8850: null,
8851: 'TRUE'
8852: ),0)
8853: +
8854: nvl(pay_balance_pkg.get_value (
8855: pay_ie_p35.get_defined_balance_id (
8856: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
8857: 'IE PRSI K Term Insurable Weeks'
8858: ),
8865: null,
8866: null,
8867: 'TRUE'
8868: ),0)
8869: + nvl(pay_balance_pkg.get_value (
8870: pay_ie_p35.get_defined_balance_id (
8871: p_dimension_name, --'_PER_PAYE_REF_YTD', -- changes made --6633719
8872: 'IE PRSI M Term Insurable Weeks'
8873: ),