[Home] [Help]
1: PACKAGE BODY PAY_IE_P35 AS
2: /* $Header: pyiep35x.pkb 120.60.12020000.9 2013/02/12 05:31:48 rsahai ship $ */
3:
4: --
5: -- Constants
3:
4: --
5: -- Constants
6: --
7: l_package VARCHAR2 (31) := 'pay_ie_p35.';
8: --
9: -- Global Variables
10: --
11: -- Bug c_context_name - PRSI Context Balance Design Change
321: FETCH c1 into l_child_assignemnt_action;
322: CLOSE c1;
323:
324: p_insurable_weeks := to_char(p_tot_insurable_weeks - NVL (
325: pay_ie_p35.get_total_insurable_weeks (p_person_id
326: ,to_number(l_segment4)
327: ,p_assignment_action_id
328: ,p_Act_Context_id --6633719
329: ,p_Act_Context_value --6633719
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: ),
345: p_assignment_action_id,
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: ),
363: p_assignment_action_id,
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: ),
381: p_assignment_action_id,
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: ),
406: p_assignment_action_id,
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: ),
424: p_assignment_action_id,
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: ),
442: p_assignment_action_id,
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: ),
460: p_assignment_action_id,
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: ),
478: p_assignment_action_id,
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: ),
496: p_assignment_action_id,
685: FROM pay_payroll_actions ppa
686: WHERE ppa.report_type = 'IEP30_PRGLOCK'
687: AND ppa.action_status = 'C'
688: AND TO_DATE (
689: pay_ie_p35.get_parameter (
690: ppa.payroll_action_id,
691: 'END_DATE'
692: ),
693: 'YYYY/MM/DD'
697: BEGIN
698: --hr_utility.trace_on(null,'vikp35');
699:
700: hr_utility.set_location (l_proc_name, 1);
701: l_out_var := pay_ie_p35.get_parameter (
702: p_payroll_action_id=> p_payroll_action_id,
703: p_token_name=> 'END_DATE'
704: );
705: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
702: p_payroll_action_id=> p_payroll_action_id,
703: p_token_name=> 'END_DATE'
704: );
705: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
706: l_out_var := pay_ie_p35.get_parameter (
707: p_payroll_action_id=> p_payroll_action_id,
708: p_token_name=> 'START_DATE'
709: );
710: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
707: p_payroll_action_id=> p_payroll_action_id,
708: p_token_name=> 'START_DATE'
709: );
710: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
711: l_out_var := pay_ie_p35.get_parameter (
712: p_payroll_action_id=> p_payroll_action_id,
713: p_token_name=> 'BG_ID'
714: );
715: l_bg_id := TO_NUMBER (l_out_var);
922: pay_action_interlocks plock
923: WHERE ppa_p35.report_type = 'IEP35'
924: AND paa_p35.action_status = 'C'
925: AND TO_CHAR ( TO_DATE (
926: pay_ie_p35.get_parameter (
927: ppa_p35.payroll_action_id,
928: 'END_DATE'
929: ),'YYYY/MM/DD'),'YYYY') = TO_CHAR(l_end_date,'YYYY') --4641756
930: AND ppa_p35.payroll_action_id = paa_p35.payroll_action_id
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,
1027: l_segment4,
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,
1027: l_segment4,
1028: null,
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,
1051: l_segment4,
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,
1051: l_segment4,
1052: 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,
1065: l_segment4,
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,
1065: l_segment4,
1066: 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,
1079: l_segment4,
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,
1079: l_segment4,
1080: 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,
1093: l_segment4,
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,
1093: l_segment4,
1094: 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,
1107: l_segment4,
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,
1107: l_segment4,
1108: 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,
1121: l_segment4,
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,
1121: l_segment4,
1122: 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,
1135: l_segment4,
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,
1135: l_segment4,
1136: 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,
1149: l_segment4,
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,
1149: l_segment4,
1150: null,
1186:
1187: BEGIN
1188:
1189: --
1190: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> pactid,
1191: p_token_name=> 'EMP_NO');
1192: l_out_var := pay_ie_p35.get_parameter (
1193: p_payroll_action_id=> pactid,
1194: p_token_name=> 'ASSIGNMENT_SET_ID'
1188:
1189: --
1190: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> pactid,
1191: p_token_name=> 'EMP_NO');
1192: l_out_var := pay_ie_p35.get_parameter (
1193: p_payroll_action_id=> pactid,
1194: p_token_name=> 'ASSIGNMENT_SET_ID'
1195: );
1196: l_assignment_set_id := to_number(l_out_var);
1194: p_token_name=> 'ASSIGNMENT_SET_ID'
1195: );
1196: l_assignment_set_id := to_number(l_out_var);
1197:
1198: l_out_var := pay_ie_p35.get_parameter (
1199: p_payroll_action_id=> pactid,
1200: p_token_name=> 'PAYROLL'
1201: );
1202: l_payroll_id := to_number(l_out_var);
1200: p_token_name=> 'PAYROLL'
1201: );
1202: l_payroll_id := to_number(l_out_var);
1203:
1204: l_out_var := pay_ie_p35.get_parameter (
1205: p_payroll_action_id=> pactid,
1206: p_token_name=> 'END_DATE'
1207: );
1208: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
1205: p_payroll_action_id=> pactid,
1206: p_token_name=> 'END_DATE'
1207: );
1208: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
1209: l_out_var := pay_ie_p35.get_parameter (
1210: p_payroll_action_id=> pactid,
1211: p_token_name=> 'START_DATE'
1212: );
1213: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
1210: p_payroll_action_id=> pactid,
1211: p_token_name=> 'START_DATE'
1212: );
1213: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
1214: l_out_var := pay_ie_p35.get_parameter (
1215: p_payroll_action_id=> pactid,
1216: p_token_name=> 'BG_ID'
1217: );
1218: l_bg_id := TO_NUMBER (l_out_var);
1693: TO_DATE ('31-12-4712', 'DD-MM-YYYY')
1694: ),
1695: 'YYYY'
1696: ),
1697: TO_CHAR (pay_ie_p35.get_end_date, 'RRRR') --Bug fix 3745861
1698: , TO_CHAR (pps.actual_termination_date, 'dd-mm-yyyy'),
1699: '31-12-4712'
1700: ), -- TERM_DATE
1701: NVL (TRIM (RPAD (ppf.per_information1, 30)), ' '), -- MOTHERS_NAME
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: ),
1711: p_rr_action
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: ),
1726: p_rr_action
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: ),
1742: p_rr_action
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: ),
1757: p_rr_action
1788: (SELECT MAX (asg.effective_end_date)
1789: FROM per_assignments_f asg
1790: WHERE asg.assignment_id = paf.assignment_id
1791: AND asg.effective_start_date <=
1792: l_end_date --pay_ie_p35.get_start_date()
1793: AND asg.effective_end_date >=
1794: l_start_date -- pay_ie_p35.get_end_date()
1795: )
1796: AND paf.period_of_service_id = pps.period_of_service_id
1790: WHERE asg.assignment_id = paf.assignment_id
1791: AND asg.effective_start_date <=
1792: l_end_date --pay_ie_p35.get_start_date()
1793: AND asg.effective_end_date >=
1794: l_start_date -- pay_ie_p35.get_end_date()
1795: )
1796: AND paf.period_of_service_id = pps.period_of_service_id
1797: AND paf.person_id = pps.person_id
1798: AND ppf.person_id = paf.person_id
1800: (SELECT MAX (per.effective_end_date)
1801: FROM per_people_f per
1802: WHERE per.person_id = ppf.person_id
1803: AND per.effective_start_date <=
1804: l_end_date --pay_ie_p35.get_start_date()
1805: AND per.effective_end_date >=
1806: l_start_date --pay_ie_p35.get_end_date()
1807: );
1808:
1802: WHERE per.person_id = ppf.person_id
1803: AND per.effective_start_date <=
1804: l_end_date --pay_ie_p35.get_start_date()
1805: AND per.effective_end_date >=
1806: l_start_date --pay_ie_p35.get_end_date()
1807: );
1808:
1809: -- Prepayment cursor
1810: -- p_locked_action is pre-payments locked action.
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: ),
1834: p_rr_action, -- paa.assignment_action_id,
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: ),
1929: p_rr_action, --paa.assignment_action_id,
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: ),
1951: p_rr_action
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: ),
1966: p_rr_action
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: ),
1982: p_rr_action
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: ),
1997: p_rr_action
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: ),
2071: paa.assignment_action_id,
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: ),
2167: paa.assignment_action_id,
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: ),
2189: p_locked_action
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: ),
2204: p_locked_action
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: ),
2220: p_locked_action
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: ),
2235: p_locked_action
2702: */
2703: --6633719
2704:
2705: l_out_var :=
2706: pay_ie_p35.get_parameter (
2707: p_payroll_action_id=> v_payroll_action_id,
2708: p_token_name=> 'END_DATE'
2709: );
2710: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
2708: p_token_name=> 'END_DATE'
2709: );
2710: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
2711: l_out_var :=
2712: pay_ie_p35.get_parameter (
2713: p_payroll_action_id=> v_payroll_action_id,
2714: p_token_name=> 'START_DATE'
2715: );
2716: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
2714: p_token_name=> 'START_DATE'
2715: );
2716: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
2717: l_out_var :=
2718: pay_ie_p35.get_parameter (
2719: p_payroll_action_id=> v_payroll_action_id,
2720: p_token_name=> 'BG_ID'
2721: );
2722: l_bg_id := TO_NUMBER (l_out_var);
2720: p_token_name=> 'BG_ID'
2721: );
2722: l_bg_id := TO_NUMBER (l_out_var);
2723:
2724: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> v_payroll_action_id,
2725: p_token_name=> 'EMP_NO');
2726: l_out_var := pay_ie_p35.get_parameter (
2727: p_payroll_action_id=> v_payroll_action_id,
2728: p_token_name=> 'ASSIGNMENT_SET_ID'
2722: l_bg_id := TO_NUMBER (l_out_var);
2723:
2724: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> v_payroll_action_id,
2725: p_token_name=> 'EMP_NO');
2726: l_out_var := pay_ie_p35.get_parameter (
2727: p_payroll_action_id=> v_payroll_action_id,
2728: p_token_name=> 'ASSIGNMENT_SET_ID'
2729: );
2730: l_assignment_set_id := to_number(l_out_var);
2728: p_token_name=> 'ASSIGNMENT_SET_ID'
2729: );
2730: l_assignment_set_id := to_number(l_out_var);
2731:
2732: l_out_var := pay_ie_p35.get_parameter (
2733: p_payroll_action_id=> v_payroll_action_id,
2734: p_token_name=> 'PAYROLL'
2735: );
2736: l_payroll_id := to_number(l_out_var);
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: ),
2895: csr_interlocks.locked_action_id,
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: ),
2932: csr_interlocks.locked_action_id,
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: ),
2969: csr_interlocks.locked_action_id,
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: ),
3012: csr_interlocks.locked_action_id,
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: ),
3057: csr_interlocks.locked_action_id,
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: ),
3102: csr_interlocks.locked_action_id,
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: ),
3140: csr_interlocks.locked_action_id,
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: ),
3185: csr_interlocks.locked_action_id,
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: ),
3232: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3258: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3284: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3310: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3339: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3361: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3386: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3411: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3433: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3458: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3483: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3515: csr_interlocks.locked_action_id,
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: ),
3557: csr_interlocks.locked_action_id,
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: ),
3599: csr_interlocks.locked_action_id,
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: ),
3642: csr_interlocks.locked_action_id,
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: ),
3686: csr_interlocks.locked_action_id,
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: ),
3729: csr_interlocks.locked_action_id,
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: ),
3767: csr_interlocks.locked_action_id,
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: ),
3806: csr_interlocks.locked_action_id,
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: ),
3845: csr_interlocks.locked_action_id,
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: ),
3884: csr_interlocks.locked_action_id,
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: ),
3918: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
3946: csr_interlocks.locked_action_id,
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: ),
3996: csr_interlocks.locked_action_id,
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: ),
4038: csr_interlocks.locked_action_id,
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: ),
4080: csr_interlocks.locked_action_id,
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: ),
4123: csr_interlocks.locked_action_id,
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: ),
4168: csr_interlocks.locked_action_id,
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: ),
4214: csr_interlocks.locked_action_id,
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: ),
4259: csr_interlocks.locked_action_id,
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: ),
4302: csr_interlocks.locked_action_id,
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: ),
4340: csr_interlocks.locked_action_id,
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: ),
4379: csr_interlocks.locked_action_id,
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: ),
4499: csr_interlocks.locked_action_id,
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: ),
4524: csr_interlocks.locked_action_id,
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: ),
4542: csr_interlocks.locked_action_id,
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: ),
4560: csr_interlocks.locked_action_id,
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: ),
4585: csr_interlocks.locked_action_id,
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: ),
4603: csr_interlocks.locked_action_id,
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: ),
4621: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4639: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4657: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4675: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4700: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4725: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4751: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4777: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4803: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4830: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4852: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4877: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4902: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4924: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4949: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
4974: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
5003: csr_interlocks.locked_action_id,
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: ),
5029: csr_interlocks.locked_action_id,
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: ),
5053: csr_interlocks.locked_action_id,
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: ),
5080: csr_interlocks.locked_action_id,
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: ),
5106: csr_interlocks.locked_action_id,
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: ),
5133: csr_interlocks.locked_action_id,
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: ),
5159: csr_interlocks.locked_action_id,
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: ),
5185: csr_interlocks.locked_action_id,
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: ),
5214: csr_interlocks.locked_action_id,
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: ),
5241: csr_interlocks.locked_action_id,
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: ),
5266: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
5295: csr_interlocks.locked_action_id,
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: ),
5321: csr_interlocks.locked_action_id,
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: ),
5345: csr_interlocks.locked_action_id,
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: ),
5369: csr_interlocks.locked_action_id,
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: ),
5394: csr_interlocks.locked_action_id,
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: ),
5420: csr_interlocks.locked_action_id,
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: ),
5448: csr_interlocks.locked_action_id,
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: ),
5474: csr_interlocks.locked_action_id,
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: ),
5500: csr_interlocks.locked_action_id,
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: ),
5526: csr_interlocks.locked_action_id,
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: ),
5556: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
5633: l_arch_assmt_action_id_bal,
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: ),
5658: l_arch_assmt_action_id_bal,
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: ),
5676: l_arch_assmt_action_id_bal,
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: ),
5694: l_arch_assmt_action_id_bal,
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: ),
5720: l_arch_assmt_action_id_bal,
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: ),
5738: l_arch_assmt_action_id_bal,
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: ),
5756: l_arch_assmt_action_id_bal,
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: ),
5774: l_arch_assmt_action_id_bal,
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: ),
5792: l_arch_assmt_action_id_bal,
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: ),
5810: l_arch_assmt_action_id_bal,
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: ),
5835: l_arch_assmt_action_id_bal,
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: ),
5864: l_arch_assmt_action_id_bal,
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: ),
5890: l_arch_assmt_action_id_bal,
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: ),
5916: l_arch_assmt_action_id_bal,
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: ),
5942: l_arch_assmt_action_id_bal,
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: ),
5969: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
5991: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6016: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6041: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6063: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6088: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6113: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6142: csr_interlocks.locked_action_id,
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: ),
6168: csr_interlocks.locked_action_id,
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: ),
6192: csr_interlocks.locked_action_id,
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: ),
6219: csr_interlocks.locked_action_id,
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: ),
6245: csr_interlocks.locked_action_id,
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: ),
6272: csr_interlocks.locked_action_id,
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: ),
6298: csr_interlocks.locked_action_id,
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: ),
6324: csr_interlocks.locked_action_id,
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: ),
6353: csr_interlocks.locked_action_id,
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: ),
6380: csr_interlocks.locked_action_id,
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: ),
6405: csr_interlocks.locked_action_id, --l_arch_assmt_action_id_bal,
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: ),
6433: csr_interlocks.locked_action_id,
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: ),
6459: csr_interlocks.locked_action_id,
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: ),
6483: csr_interlocks.locked_action_id,
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: ),
6507: csr_interlocks.locked_action_id,
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: ),
6532: csr_interlocks.locked_action_id,
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: ),
6558: csr_interlocks.locked_action_id,
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: ),
6586: csr_interlocks.locked_action_id,
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: ),
6612: csr_interlocks.locked_action_id,
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: ),
6638: csr_interlocks.locked_action_id,
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: ),
6664: csr_interlocks.locked_action_id,
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: ),
6694: l_arch_assmt_action_id_bal,
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: ),
6750: csr_interlocks.locked_action_id
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: ),
6767: csr_interlocks.locked_action_id
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: ),
6785: csr_interlocks.locked_action_id
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: ),
6803: csr_interlocks.locked_action_id
6873: hr_utility.set_location ('Starting on other common values', 10);
6874: l_arch_totwks_insurble_emplmnt :=
6875: TO_CHAR (
6876: NVL (
6877: pay_ie_p35.get_total_insurable_weeks (l_arch_person_id
6878: ,to_number(l_segment4)
6879: ,l_max_action_id
6880: ,l_Act_Context_id --6633719
6881: ,l_Act_Context_value --6633719
6887: hr_utility.set_location('l_arch_totwks_insurble_emplmnt.'||l_arch_totwks_insurble_emplmnt,5001);
6888: --
6889:
6890: l_arch_initial_class :=
6891: NVL (pay_ie_p35.get_initial_class (l_max_action_id,to_number(l_segment4),l_ppsn_override), ' '); --6633719
6892: -- class A is displayed when PRSIable pay is zero.
6893: -- Eliminate class A.
6894: IF l_arch_pay = 0 or l_arch_initial_class = 'A' THEN
6895: l_arch_initial_class := NULL;
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: ),
7096: l_aact_id,
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: ),
7113: l_aact_id,
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: ),
7131: l_aact_id,
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: ),
7148: l_aact_id,
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: ),
7165: l_aact_id,
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: ),
7186: l_aact_id,
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: ),
7205: l_aact_id,
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: ),
7222: l_aact_id,
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: ),
7239: l_aact_id,
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: ),
7257: l_aact_id,
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: ),
7276: l_aact_id,
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: ),
7296: l_aact_id,
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: ),
7327: l_aact_id,
7603: hr_organization_information hoi2
7604: ,hr_organization_information hoi3 --12556436
7605: WHERE ppa.payroll_action_id = p_payroll_action_id
7606: AND hou.business_group_id = ppa.business_group_id
7607: AND hou.organization_id = pay_ie_p35.get_parameter (ppa.payroll_action_id, 'EMP_NO')
7608: AND hl.location_id(+) = hou.location_id
7609: AND hou.organization_id=hoi1.organization_id
7610: AND hoi2.organization_id(+)= hoi1.organization_id
7611: AND hoi1.org_information_context='CLASS'
7623: OPEN csr_check_payroll_action;
7624: FETCH csr_check_payroll_action into l_archived;
7625: CLOSE csr_check_payroll_action;
7626: IF l_archived = 0 THEN
7627: l_out_var := pay_ie_p35.get_parameter (
7628: p_payroll_action_id=> p_payroll_action_id,
7629: p_token_name=> 'END_DATE'
7630: );
7631: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
7628: p_payroll_action_id=> p_payroll_action_id,
7629: p_token_name=> 'END_DATE'
7630: );
7631: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
7632: l_out_var := pay_ie_p35.get_parameter (
7633: p_payroll_action_id=> p_payroll_action_id,
7634: p_token_name=> 'START_DATE'
7635: );
7636: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
7633: p_payroll_action_id=> p_payroll_action_id,
7634: p_token_name=> 'START_DATE'
7635: );
7636: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
7637: l_out_var := pay_ie_p35.get_parameter (
7638: p_payroll_action_id=> p_payroll_action_id,
7639: p_token_name=> 'BG_ID'
7640: );
7641: l_bg_id := TO_NUMBER (l_out_var);
8448: CURSOR c_p60_second_class
8449: IS
8450: SELECT SUBSTR (piw.combined_class, 1, 2),
8451: NVL (piw.insurable_weeks, 0)
8452: FROM pay_ie_p35_insurable_weeks_v piw
8453: WHERE piw.person_id =
8454: (SELECT asg.person_id
8455: FROM per_assignments_f asg
8456: WHERE asg.assignment_id = p_assignment_id
8460: WHERE asg.assignment_id =
8461: asg2.assignment_id))
8462: AND piw.insurable_weeks =
8463: (SELECT MAX (piw2.insurable_weeks)
8464: FROM pay_ie_p35_insurable_weeks_v piw2
8465: WHERE piw2.person_id = piw.person_id
8466: AND SUBSTR (piw2.combined_class, 1, 2) <>
8467: RPAD (l_initial_class, 2))
8468: AND piw.minimum_effective_date =
8466: AND SUBSTR (piw2.combined_class, 1, 2) <>
8467: RPAD (l_initial_class, 2))
8468: AND piw.minimum_effective_date =
8469: (SELECT MIN (piw3.minimum_effective_date)
8470: FROM pay_ie_p35_insurable_weeks_v piw3
8471: WHERE piw3.person_id = piw.person_id
8472: AND piw3.insurable_weeks = piw.insurable_weeks
8473: AND SUBSTR (piw3.combined_class, 1, 2) <>
8474: RPAD (l_initial_class, 2));
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: ),
8843: p_assignment_action_id, --paa.assignment_action_id,
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: ),
8859: p_assignment_action_id, --paa.assignment_action_id,
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: ),
8874: p_assignment_action_id, --paa.assignment_action_id,
8912: INTO l_start_date
8913: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
8914: WHERE fpo.profile_option_id = fpov.profile_option_id
8915: AND fpo.application_id = fpov.application_id
8916: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
8917: AND fpov.level_id = 10001
8918: AND fpov.level_value = 0;
8919:
8920: RETURN l_start_date;
8934: INTO l_end_date
8935: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
8936: WHERE fpo.profile_option_id = fpov.profile_option_id
8937: AND fpo.application_id = fpov.application_id
8938: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
8939: AND fpov.level_id = 10001
8940: AND fpov.level_value = 0;
8941:
8942: RETURN l_end_date;
9008: l_string := replace(l_string, '>', '>');
9009: l_string := replace(l_string, '''',''');
9010: l_string := replace(l_string, '"', '"');
9011: -- bug 6275544, called
9012: l_string := pay_ie_p35_magtape.test_XML(l_string);
9013: -- bug 5867343, special characters.
9014: /*l_string := replace(l_string, fnd_global.local_chr(193),'Á');
9015: l_string := replace(l_string, fnd_global.local_chr(201),'É');
9016: l_string := replace(l_string, fnd_global.local_chr(205),'Í');
9029: EXCEPTION when no_data_found then
9030: null;
9031: END replace_xml_symbols;
9032:
9033: END pay_ie_p35;