eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_STATSR_PKG dependencies on PAY_DK_STATSR_PKG

Line 1: PACKAGE BODY PAY_DK_STATSR_PKG AS

1: PACKAGE BODY PAY_DK_STATSR_PKG AS
2: /* $Header: pydkstatsr.pkb 120.36 2012/01/19 09:10:45 rpahune ship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';

Line 5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';

1: PACKAGE BODY PAY_DK_STATSR_PKG AS
2: /* $Header: pydkstatsr.pkb 120.36 2012/01/19 09:10:45 rpahune ship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:

Line 94: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')

90: IS
91:
92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT
94: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date

Line 95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')

91:
92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT
94: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

Line 96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')

92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT
94: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id

Line 97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

93: SELECT
94: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id
101: FROM pay_payroll_actions

Line 99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id
101: FROM pay_payroll_actions
102: WHERE payroll_action_id = p_payroll_action_id;
103:

Line 427: PAY_DK_STATSR_PKG.GET_ALL_PARAMETERS(

423: AND ppa.business_group_id = ppf.business_group_id
424: ORDER BY ppf.person_id';
425:
426: -- Fetch the input parameter values
427: PAY_DK_STATSR_PKG.GET_ALL_PARAMETERS(
428: pactid
429: ,l_business_group_id
430: ,l_payroll_id
431: ,l_sender_id

Line 1142: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')

1138: IF g_debug THEN
1139: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
1140: END IF;
1141:
1142: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
1143: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE')) --8848543
1144: INTO l_span, l_pd_date_to --8848543
1145: FROM pay_payroll_actions
1146: WHERE payroll_action_id = p_payroll_action_id;

Line 1143: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE')) --8848543

1139: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
1140: END IF;
1141:
1142: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
1143: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE')) --8848543
1144: INTO l_span, l_pd_date_to --8848543
1145: FROM pay_payroll_actions
1146: WHERE payroll_action_id = p_payroll_action_id;
1147: --8848543

Line 1518: l_mkode0600 := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_mkode0600; -- l_date_to);

1514: /*Changes for Lunar Payroll */
1515:
1516: /*ELSIF csr_rec.payroll_period IN ('2','3','4') THEN*/
1517: ELSIF l_hourly_salaried = 'H' THEN
1518: l_mkode0600 := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_mkode0600; -- l_date_to);
1519: l_old_mkode0600 := l_mkode0600 + l_old_mkode0600;
1520:
1521: IF l_span = 'Q' THEN
1522: l_mkode0600 := l_mkode0600 / 13;

Line 1538: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));

1534: END IF; /* Bug 5030983 Fixes - End */
1535:
1536: /* Logic for selecting mkode0610 */
1537: IF( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '5DAY') THEN
1538: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1539: ELSIF ( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '6DAY') THEN
1540: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1541: /* Added new condition for bug fix 5003621 */
1542: ELSE

Line 1540: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));

1536: /* Logic for selecting mkode0610 */
1537: IF( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '5DAY') THEN
1538: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1539: ELSIF ( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '6DAY') THEN
1540: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1541: /* Added new condition for bug fix 5003621 */
1542: ELSE
1543: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1544: END IF;

Line 1543: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));

1539: ELSIF ( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '6DAY') THEN
1540: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1541: /* Added new condition for bug fix 5003621 */
1542: ELSE
1543: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1544: END IF;
1545:
1546: /* Logic for selecting l_mkode0620 */
1547: /*Changes for Lunar Payroll */

Line 1551: ,to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_PAY_LEGSL_PERCENTAGE', l_date_to))));

1547: /*Changes for Lunar Payroll */
1548: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1549: IF l_hourly_salaried = 'H' THEN
1550: l_mkode0620 := to_char(nvl(nvl(csr_rec.hourly_accr_rate,rec_get_hol_entit.hourly_accr_rate)
1551: ,to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_PAY_LEGSL_PERCENTAGE', l_date_to))));
1552: /*ELSIF(csr_rec.payroll_period = '1') THEN*/
1553: ELSIF l_hourly_salaried = 'S' THEN
1554: l_mkode0620 := to_char(nvl(nvl(csr_rec.sal_allow_rate,rec_get_hol_entit.sal_allow_rate)
1555: ,to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_ALLOWANCE_LEGSL_PERCENTAGE', l_date_to))));

Line 1555: ,to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_ALLOWANCE_LEGSL_PERCENTAGE', l_date_to))));

1551: ,to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_PAY_LEGSL_PERCENTAGE', l_date_to))));
1552: /*ELSIF(csr_rec.payroll_period = '1') THEN*/
1553: ELSIF l_hourly_salaried = 'S' THEN
1554: l_mkode0620 := to_char(nvl(nvl(csr_rec.sal_allow_rate,rec_get_hol_entit.sal_allow_rate)
1555: ,to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_ALLOWANCE_LEGSL_PERCENTAGE', l_date_to))));
1556: END IF;
1557:
1558: /************** Access the balance values for the ILTYPE balances **************/
1559:

Line 1561: l_iltype_0010_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Income',l_dimension ,l_bal_todate)

1557:
1558: /************** Access the balance values for the ILTYPE balances **************/
1559:
1560: /* Logic for fetching l_iltype_0010_bal */
1561: l_iltype_0010_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Income',l_dimension ,l_bal_todate)
1562: - l_old_iltype_0010_bal; -- l_date_to);
1563: l_old_iltype_0010_bal := l_old_iltype_0010_bal + l_iltype_0010_bal;
1564: /* Bug 5030983 Fixes - Start */
1565: IF csr_rec.SAL_BASIS_MKODE IN ('81','82','83','84') THEN

Line 1574: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total ATP Hours',l_dimension ,l_bal_todate)

1570: /*IF(csr_rec.payroll_period = '1') THEN*/
1571: IF l_hourly_salaried = 'S' THEN
1572: /* Changed this for bug fix 5034129 */
1573: /*l_iltype_0010_unit := ROUND(l_hours_rate * l_mul_factor * 22/5,2);*/
1574: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total ATP Hours',l_dimension ,l_bal_todate)
1575: - PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0010_unit;
1576: l_s_old_iltype_0010_unit := l_iltype_0010_unit + l_s_old_iltype_0010_unit;
1577: /*Changes for Lunar Payroll */
1578: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/

Line 1575: - PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0010_unit;

1571: IF l_hourly_salaried = 'S' THEN
1572: /* Changed this for bug fix 5034129 */
1573: /*l_iltype_0010_unit := ROUND(l_hours_rate * l_mul_factor * 22/5,2);*/
1574: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total ATP Hours',l_dimension ,l_bal_todate)
1575: - PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0010_unit;
1576: l_s_old_iltype_0010_unit := l_iltype_0010_unit + l_s_old_iltype_0010_unit;
1577: /*Changes for Lunar Payroll */
1578: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1579: ELSIF l_hourly_salaried = 'H' THEN

Line 1580: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0010_unit; -- l_date_to);

1576: l_s_old_iltype_0010_unit := l_iltype_0010_unit + l_s_old_iltype_0010_unit;
1577: /*Changes for Lunar Payroll */
1578: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1579: ELSIF l_hourly_salaried = 'H' THEN
1580: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0010_unit; -- l_date_to);
1581: l_h_old_iltype_0010_unit := l_h_old_iltype_0010_unit + l_iltype_0010_unit;
1582: END IF;
1583: END IF; /* Bug 5030983 Fixes - End */
1584: /* Logic for fetching l_iltype_0011_bal */

Line 1585: l_iltype_0011_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Special Pay',l_dimension ,l_bal_todate) - l_old_iltype_0011_bal; -- l_date_to);

1581: l_h_old_iltype_0010_unit := l_h_old_iltype_0010_unit + l_iltype_0010_unit;
1582: END IF;
1583: END IF; /* Bug 5030983 Fixes - End */
1584: /* Logic for fetching l_iltype_0011_bal */
1585: l_iltype_0011_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Special Pay',l_dimension ,l_bal_todate) - l_old_iltype_0011_bal; -- l_date_to);
1586: l_old_iltype_0011_bal := l_iltype_0011_bal + l_old_iltype_0011_bal;
1587: --l_iltype_0011_unit := 1; --9888286
1588: l_iltype_0011_unit := 0; --9888286
1589:

Line 1591: l_iltype_0013_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holidayable Pay',l_dimension ,l_bal_todate) - l_old_iltype_0013_bal; -- l_date_to);

1587: --l_iltype_0011_unit := 1; --9888286
1588: l_iltype_0011_unit := 0; --9888286
1589:
1590: /* Logic for fetching l_iltype_0013_bal */
1591: l_iltype_0013_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holidayable Pay',l_dimension ,l_bal_todate) - l_old_iltype_0013_bal; -- l_date_to);
1592: l_old_iltype_0013_bal := l_old_iltype_0013_bal + l_iltype_0013_bal;
1593: /* Added for bug 5050964*/
1594: l_iltype_0013_unit := l_iltype_0010_unit;
1595:

Line 1597: l_iltype_0015_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Benefits in Kind',l_dimension ,l_bal_todate) - l_old_iltype_0015_bal; -- l_date_to);

1593: /* Added for bug 5050964*/
1594: l_iltype_0013_unit := l_iltype_0010_unit;
1595:
1596: /* Logic for fetching l_iltype_0015_bal */
1597: l_iltype_0015_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Benefits in Kind',l_dimension ,l_bal_todate) - l_old_iltype_0015_bal; -- l_date_to);
1598: l_old_iltype_0015_bal := l_old_iltype_0015_bal + l_iltype_0015_bal;
1599: -- l_iltype_0015_unit := 1; --9888286
1600: l_iltype_0015_unit := 0; --9888286
1601:

Line 1604: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1600: l_iltype_0015_unit := 0; --9888286
1601:
1602: /* Logic for fetching l_iltype_0021_bal */
1603: /*
1604: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1605: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1606: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1607: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1608: - l_old_iltype_0021_bal; -- l_date_to);

Line 1605: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1601:
1602: /* Logic for fetching l_iltype_0021_bal */
1603: /*
1604: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1605: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1606: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1607: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1608: - l_old_iltype_0021_bal; -- l_date_to);
1609: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;

Line 1606: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1602: /* Logic for fetching l_iltype_0021_bal */
1603: /*
1604: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1605: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1606: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1607: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1608: - l_old_iltype_0021_bal; -- l_date_to);
1609: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;
1610: l_iltype_0021_unit := 1;*/

Line 1607: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)

1603: /*
1604: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1605: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1606: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1607: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1608: - l_old_iltype_0021_bal; -- l_date_to);
1609: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;
1610: l_iltype_0021_unit := 1;*/
1611: /* IL Type 0121 */

Line 1612: l_iltype_0121_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1608: - l_old_iltype_0021_bal; -- l_date_to);
1609: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;
1610: l_iltype_0021_unit := 1;*/
1611: /* IL Type 0121 */
1612: l_iltype_0121_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1613: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1614: - l_old_iltype_0121_bal; -- l_date_to);
1615: l_old_iltype_0121_bal := l_iltype_0121_bal + l_old_iltype_0121_bal;
1616: --l_iltype_0121_unit := 1; --9888286

Line 1613: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1609: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;
1610: l_iltype_0021_unit := 1;*/
1611: /* IL Type 0121 */
1612: l_iltype_0121_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1613: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1614: - l_old_iltype_0121_bal; -- l_date_to);
1615: l_old_iltype_0121_bal := l_iltype_0121_bal + l_old_iltype_0121_bal;
1616: --l_iltype_0121_unit := 1; --9888286
1617: l_iltype_0121_unit := 0; --9888286

Line 1619: l_iltype_0122_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1615: l_old_iltype_0121_bal := l_iltype_0121_bal + l_old_iltype_0121_bal;
1616: --l_iltype_0121_unit := 1; --9888286
1617: l_iltype_0121_unit := 0; --9888286
1618: /* IL Type 0122 */
1619: l_iltype_0122_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1620: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1621: - l_old_iltype_0122_bal; -- l_date_to);
1622: l_old_iltype_0122_bal := l_iltype_0122_bal + l_old_iltype_0122_bal;
1623: --l_iltype_0122_unit := 1; --9888286

Line 1620: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)

1616: --l_iltype_0121_unit := 1; --9888286
1617: l_iltype_0121_unit := 0; --9888286
1618: /* IL Type 0122 */
1619: l_iltype_0122_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1620: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1621: - l_old_iltype_0122_bal; -- l_date_to);
1622: l_old_iltype_0122_bal := l_iltype_0122_bal + l_old_iltype_0122_bal;
1623: --l_iltype_0122_unit := 1; --9888286
1624: l_iltype_0122_unit := 0; --9888286

Line 1630: l_iltype_0021_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_iltype_0021_unit; -- l_date_to);

1626: /* Added condition for bug fix 4998238 */
1627: /*Changes for Lunar Payroll */
1628: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1629: /* IF l_hourly_salaried = 'H' THEN
1630: l_iltype_0021_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_iltype_0021_unit; -- l_date_to);
1631: l_old_iltype_0021_unit := l_iltype_0021_unit + l_old_iltype_0021_unit;
1632: END IF;*/
1633:
1634: /* Logic for fetching l_iltype_0022_bal */

Line 1635: l_iltype_0022_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Pay',l_dimension ,l_bal_todate) - l_old_iltype_0022_bal; -- l_date_to);

1631: l_old_iltype_0021_unit := l_iltype_0021_unit + l_old_iltype_0021_unit;
1632: END IF;*/
1633:
1634: /* Logic for fetching l_iltype_0022_bal */
1635: l_iltype_0022_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Pay',l_dimension ,l_bal_todate) - l_old_iltype_0022_bal; -- l_date_to);
1636: l_old_iltype_0022_bal := l_iltype_0022_bal + l_old_iltype_0022_bal;
1637: /* After FS changes, now for both salaried and non-salaried, to report Total G_Dage_Days_ASG_XXX as units
1638: , earlier was Total G_Dage Hours for non-salaried */
1639: /* Commenting code below and re-writing to achieve this */

Line 1641: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);

1637: /* After FS changes, now for both salaried and non-salaried, to report Total G_Dage_Days_ASG_XXX as units
1638: , earlier was Total G_Dage Hours for non-salaried */
1639: /* Commenting code below and re-writing to achieve this */
1640: /*IF(csr_rec.payroll_period = '1') THEN
1641: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);
1642: ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1643: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);
1644: END IF;*/
1645: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);

Line 1643: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);

1639: /* Commenting code below and re-writing to achieve this */
1640: /*IF(csr_rec.payroll_period = '1') THEN
1641: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);
1642: ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1643: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);
1644: END IF;*/
1645: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);
1646: l_old_iltype_0022_unit := l_iltype_0022_unit + l_old_iltype_0022_unit;
1647: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display

Line 1645: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);

1641: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);
1642: ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1643: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);
1644: END IF;*/
1645: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);
1646: l_old_iltype_0022_unit := l_iltype_0022_unit + l_old_iltype_0022_unit;
1647: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display
1648: the negative values*/
1649: -- IF(l_iltype_0022_unit <0) THEN

Line 1658: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0023_unit; -- l_date_to);

1654:
1655: /* Logic for fetching l_iltype_0023_bal */
1656: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1657: IF l_hourly_salaried = 'S' THEN
1658: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0023_unit; -- l_date_to);
1659: l_s_old_iltype_0023_unit := l_s_old_iltype_0023_unit + l_iltype_0023_unit;
1660:
1661: /* Calculate Hourly Rate Modified with if clause to avoid zero divide error */
1662: if l_iltype_0010_unit <> 0 then

Line 1663: l_iltype_0023_hr_rate := ROUND((PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate) - l_old_iltype_0023_hr_rate)/l_iltype_0010_unit,2);

1659: l_s_old_iltype_0023_unit := l_s_old_iltype_0023_unit + l_iltype_0023_unit;
1660:
1661: /* Calculate Hourly Rate Modified with if clause to avoid zero divide error */
1662: if l_iltype_0010_unit <> 0 then
1663: l_iltype_0023_hr_rate := ROUND((PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate) - l_old_iltype_0023_hr_rate)/l_iltype_0010_unit,2);
1664: l_old_iltype_0023_hr_rate := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate);
1665: end if;
1666:
1667: l_iltype_0023_bal := l_iltype_0023_hr_rate*l_iltype_0023_unit;

Line 1664: l_old_iltype_0023_hr_rate := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate);

1660:
1661: /* Calculate Hourly Rate Modified with if clause to avoid zero divide error */
1662: if l_iltype_0010_unit <> 0 then
1663: l_iltype_0023_hr_rate := ROUND((PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate) - l_old_iltype_0023_hr_rate)/l_iltype_0010_unit,2);
1664: l_old_iltype_0023_hr_rate := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate);
1665: end if;
1666:
1667: l_iltype_0023_bal := l_iltype_0023_hr_rate*l_iltype_0023_unit;
1668: /*Changes for Lunar Payroll */

Line 1671: l_iltype_0023_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Pay',l_dimension ,l_bal_todate) - l_old_iltype_0023_bal; -- l_date_to);

1667: l_iltype_0023_bal := l_iltype_0023_hr_rate*l_iltype_0023_unit;
1668: /*Changes for Lunar Payroll */
1669: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1670: ELSIF l_hourly_salaried = 'H' THEN
1671: l_iltype_0023_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Pay',l_dimension ,l_bal_todate) - l_old_iltype_0023_bal; -- l_date_to);
1672: l_old_iltype_0023_bal := l_iltype_0023_bal + l_old_iltype_0023_bal;
1673: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0023_unit; -- l_date_to);
1674: l_h_old_iltype_0023_unit := l_iltype_0023_unit + l_h_old_iltype_0023_unit;
1675: END IF;

Line 1673: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0023_unit; -- l_date_to);

1669: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1670: ELSIF l_hourly_salaried = 'H' THEN
1671: l_iltype_0023_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Pay',l_dimension ,l_bal_todate) - l_old_iltype_0023_bal; -- l_date_to);
1672: l_old_iltype_0023_bal := l_iltype_0023_bal + l_old_iltype_0023_bal;
1673: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0023_unit; -- l_date_to);
1674: l_h_old_iltype_0023_unit := l_iltype_0023_unit + l_h_old_iltype_0023_unit;
1675: END IF;
1676: /* Logic for fetching l_iltype_0024_bal */
1677: /* After FS changes, it is now valid only for non-salaried ppl with balance Holiday_Accrual_Amount_ASG_XXX

Line 1683: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_date_to);

1679: and Holiday Absence Days as units.*/
1680: /* Commenting code below and re-writing to achieve this */
1681: /*
1682: IF(csr_rec.payroll_period = '1' ) THEN
1683: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_date_to);
1684: l_iltype_0024_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_date_to);
1685: */
1686: /*Changes for Lunar Payroll */
1687: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/

Line 1684: l_iltype_0024_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_date_to);

1680: /* Commenting code below and re-writing to achieve this */
1681: /*
1682: IF(csr_rec.payroll_period = '1' ) THEN
1683: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_date_to);
1684: l_iltype_0024_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_date_to);
1685: */
1686: /*Changes for Lunar Payroll */
1687: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1688: IF l_hourly_salaried = 'H' THEN

Line 1690: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_bal_todate) - l_old_iltype_0024_bal; -- l_date_to);

1686: /*Changes for Lunar Payroll */
1687: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1688: IF l_hourly_salaried = 'H' THEN
1689: /* Changed for bug 5012411*/
1690: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_bal_todate) - l_old_iltype_0024_bal; -- l_date_to);
1691: l_old_iltype_0024_bal := l_iltype_0024_bal + l_old_iltype_0024_bal;
1692: --l_iltype_0024_unit := 1; --9888286
1693: l_iltype_0024_unit := 0; --9888286
1694: END IF;

Line 1703: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_date_to);

1699: and units Holiday Absence Hours */
1700: /* Commenting code below and re-writing to achieve this */
1701: /*
1702: IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1703: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_date_to);
1704: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);
1705: */
1706: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1707: IF l_hourly_salaried = 'S' THEN

Line 1704: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);

1700: /* Commenting code below and re-writing to achieve this */
1701: /*
1702: IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1703: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_date_to);
1704: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);
1705: */
1706: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1707: IF l_hourly_salaried = 'S' THEN
1708: --l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to); --9888286

Line 1708: --l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to); --9888286

1704: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);
1705: */
1706: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1707: IF l_hourly_salaried = 'S' THEN
1708: --l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to); --9888286
1709: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_bal_todate) --9888286
1710: + PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Holiday Payments',l_dimension ,l_bal_todate) --9888286
1711: - l_old_iltype_0025_bal; -- l_date_to); --9888286
1712: l_old_iltype_0025_bal := l_old_iltype_0025_bal + l_iltype_0025_bal;

Line 1709: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_bal_todate) --9888286

1705: */
1706: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1707: IF l_hourly_salaried = 'S' THEN
1708: --l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to); --9888286
1709: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_bal_todate) --9888286
1710: + PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Holiday Payments',l_dimension ,l_bal_todate) --9888286
1711: - l_old_iltype_0025_bal; -- l_date_to); --9888286
1712: l_old_iltype_0025_bal := l_old_iltype_0025_bal + l_iltype_0025_bal;
1713: --l_iltype_0025_unit := 1; --9888286

Line 1710: + PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Holiday Payments',l_dimension ,l_bal_todate) --9888286

1706: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1707: IF l_hourly_salaried = 'S' THEN
1708: --l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to); --9888286
1709: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_bal_todate) --9888286
1710: + PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Holiday Payments',l_dimension ,l_bal_todate) --9888286
1711: - l_old_iltype_0025_bal; -- l_date_to); --9888286
1712: l_old_iltype_0025_bal := l_old_iltype_0025_bal + l_iltype_0025_bal;
1713: --l_iltype_0025_unit := 1; --9888286
1714: l_iltype_0025_unit := 0; --9888286

Line 1722: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);

1718: l_iltype_0026_bal := 0;
1719: /* For Bug 9072985 . Bug 9278107
1720: Currently 0026 field is been archived with the unpaid holiday days available rather than the unpaid holidays spent
1721: Changed the balance name, such that it reported the Unpaid holidays taken rather than those available */
1722: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1723: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1724: l_iltype_0026_unit := trunc(PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days Taken',l_dimension ,l_bal_todate)) - l_old_iltype_0026_unit; -- l_date_to);
1725: l_old_iltype_0026_unit := l_iltype_0026_unit + l_old_iltype_0026_unit;
1726:

Line 1723: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);

1719: /* For Bug 9072985 . Bug 9278107
1720: Currently 0026 field is been archived with the unpaid holiday days available rather than the unpaid holidays spent
1721: Changed the balance name, such that it reported the Unpaid holidays taken rather than those available */
1722: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1723: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1724: l_iltype_0026_unit := trunc(PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days Taken',l_dimension ,l_bal_todate)) - l_old_iltype_0026_unit; -- l_date_to);
1725: l_old_iltype_0026_unit := l_iltype_0026_unit + l_old_iltype_0026_unit;
1726:
1727: /* IL Type 0027 */

Line 1724: l_iltype_0026_unit := trunc(PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days Taken',l_dimension ,l_bal_todate)) - l_old_iltype_0026_unit; -- l_date_to);

1720: Currently 0026 field is been archived with the unpaid holiday days available rather than the unpaid holidays spent
1721: Changed the balance name, such that it reported the Unpaid holidays taken rather than those available */
1722: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1723: -- l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1724: l_iltype_0026_unit := trunc(PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days Taken',l_dimension ,l_bal_todate)) - l_old_iltype_0026_unit; -- l_date_to);
1725: l_old_iltype_0026_unit := l_iltype_0026_unit + l_old_iltype_0026_unit;
1726:
1727: /* IL Type 0027 */
1728: l_iltype_0027_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Amount',l_dimension ,l_bal_todate) - l_old_iltype_0027_bal; -- l_date_to);

Line 1728: l_iltype_0027_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Amount',l_dimension ,l_bal_todate) - l_old_iltype_0027_bal; -- l_date_to);

1724: l_iltype_0026_unit := trunc(PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days Taken',l_dimension ,l_bal_todate)) - l_old_iltype_0026_unit; -- l_date_to);
1725: l_old_iltype_0026_unit := l_iltype_0026_unit + l_old_iltype_0026_unit;
1726:
1727: /* IL Type 0027 */
1728: l_iltype_0027_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Amount',l_dimension ,l_bal_todate) - l_old_iltype_0027_bal; -- l_date_to);
1729: l_old_iltype_0027_bal := l_old_iltype_0027_bal + l_iltype_0027_bal;
1730: l_iltype_0027_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0027_unit;
1731: l_old_iltype_0027_unit := l_old_iltype_0027_unit + l_iltype_0027_unit;
1732:

Line 1730: l_iltype_0027_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0027_unit;

1726:
1727: /* IL Type 0027 */
1728: l_iltype_0027_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Amount',l_dimension ,l_bal_todate) - l_old_iltype_0027_bal; -- l_date_to);
1729: l_old_iltype_0027_bal := l_old_iltype_0027_bal + l_iltype_0027_bal;
1730: l_iltype_0027_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0027_unit;
1731: l_old_iltype_0027_unit := l_old_iltype_0027_unit + l_iltype_0027_unit;
1732:
1733: /* IL Type 0029 */
1734: l_iltype_0029_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Elective Scheme Amount',l_dimension ,l_bal_todate) - l_old_iltype_0029_bal; -- l_date_to);

Line 1734: l_iltype_0029_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Elective Scheme Amount',l_dimension ,l_bal_todate) - l_old_iltype_0029_bal; -- l_date_to);

1730: l_iltype_0027_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Absence Days',l_dimension ,l_bal_todate) - l_old_iltype_0027_unit;
1731: l_old_iltype_0027_unit := l_old_iltype_0027_unit + l_iltype_0027_unit;
1732:
1733: /* IL Type 0029 */
1734: l_iltype_0029_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Elective Scheme Amount',l_dimension ,l_bal_todate) - l_old_iltype_0029_bal; -- l_date_to);
1735: l_old_iltype_0029_bal := l_old_iltype_0029_bal + l_iltype_0029_bal;
1736: --l_iltype_0029_unit := 1; --9888286
1737: l_iltype_0029_unit := 0; --9888286
1738:

Line 1741: l_iltype_0032_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Other Pay',l_dimension ,l_bal_todate) - l_old_iltype_0032_bal; -- l_date_to);

1737: l_iltype_0029_unit := 0; --9888286
1738:
1739: /* Logic for fetching l_iltype_0032_bal */
1740: /*
1741: l_iltype_0032_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Other Pay',l_dimension ,l_bal_todate) - l_old_iltype_0032_bal; -- l_date_to);
1742: l_old_iltype_0032_bal := l_old_iltype_0032_bal + l_iltype_0032_bal;
1743: l_iltype_0032_unit := 1;
1744: */
1745: /* Logic for fetching l_iltype_0132_bal */

Line 1746: l_iltype_0132_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Performance Irregular Payments',l_dimension ,l_bal_todate) - l_old_iltype_0132_bal; -- l_date_to);

1742: l_old_iltype_0032_bal := l_old_iltype_0032_bal + l_iltype_0032_bal;
1743: l_iltype_0032_unit := 1;
1744: */
1745: /* Logic for fetching l_iltype_0132_bal */
1746: l_iltype_0132_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Performance Irregular Payments',l_dimension ,l_bal_todate) - l_old_iltype_0132_bal; -- l_date_to);
1747: l_old_iltype_0132_bal := l_old_iltype_0132_bal + l_iltype_0132_bal;
1748: --l_iltype_0132_unit := 1; --9888286
1749: l_iltype_0132_unit := 0; --9888286
1750:

Line 1752: l_iltype_0232_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Compensation Irregular Payments',l_dimension ,l_bal_todate) - l_old_iltype_0232_bal; -- l_date_to);

1748: --l_iltype_0132_unit := 1; --9888286
1749: l_iltype_0132_unit := 0; --9888286
1750:
1751: /* Logic for fetching l_iltype_0232_bal */
1752: l_iltype_0232_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Compensation Irregular Payments',l_dimension ,l_bal_todate) - l_old_iltype_0232_bal; -- l_date_to);
1753: l_old_iltype_0232_bal := l_old_iltype_0232_bal + l_iltype_0232_bal;
1754: -- l_iltype_0232_unit := 1; --9888286
1755: l_iltype_0232_unit := 0; --9888286
1756:

Line 1758: l_iltype_0332_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Irregular Payments',l_dimension ,l_bal_todate) - l_old_iltype_0332_bal; -- l_date_to);

1754: -- l_iltype_0232_unit := 1; --9888286
1755: l_iltype_0232_unit := 0; --9888286
1756:
1757: /* Logic for fetching l_iltype_0332_bal */
1758: l_iltype_0332_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Other Irregular Payments',l_dimension ,l_bal_todate) - l_old_iltype_0332_bal; -- l_date_to);
1759: l_old_iltype_0332_bal := l_old_iltype_0332_bal + l_iltype_0332_bal;
1760: --l_iltype_0332_unit := 1; --9888286
1761: l_iltype_0332_unit := 0; --9888286
1762:

Line 1772: -- l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);

1768: l_iltype_0034_bal := 0;
1769: /* For Bug 9072985
1770: IL0034 absence with payment (except holiday) should report in days and not in hours and Holidays should not be included.
1771: A seeded balance is now provided and user can feed the elements accordingly */
1772: -- l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);
1773: l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Salaried Paid Absence Balance',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);
1774: l_old_iltype_0034_unit := l_iltype_0034_unit + l_old_iltype_0034_unit;
1775: END IF;
1776:

Line 1773: l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Salaried Paid Absence Balance',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);

1769: /* For Bug 9072985
1770: IL0034 absence with payment (except holiday) should report in days and not in hours and Holidays should not be included.
1771: A seeded balance is now provided and user can feed the elements accordingly */
1772: -- l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);
1773: l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Salaried Paid Absence Balance',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);
1774: l_old_iltype_0034_unit := l_iltype_0034_unit + l_old_iltype_0034_unit;
1775: END IF;
1776:
1777: /* IL Type 0035 */

Line 1778: l_iltype_0035_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Nuisance Pay',l_dimension ,l_bal_todate) - l_old_iltype_0035_bal; -- l_date_to);

1774: l_old_iltype_0034_unit := l_iltype_0034_unit + l_old_iltype_0034_unit;
1775: END IF;
1776:
1777: /* IL Type 0035 */
1778: l_iltype_0035_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Nuisance Pay',l_dimension ,l_bal_todate) - l_old_iltype_0035_bal; -- l_date_to);
1779: l_old_iltype_0035_bal := l_old_iltype_0035_bal + l_iltype_0035_bal;
1780: -- l_iltype_0035_unit := 1; --9888286
1781: l_iltype_0035_unit := 0; --9888286
1782:

Line 1786: /l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);/

1782:
1783: /* Logic for fetching l_iltype_0036_bal */
1784: /* After FS changes, now applicable to non-salaried Payrolls only now, earlier was for all*/
1785: /* Commenting code and putting everything into the first IF condition, to achieve this */
1786: /*l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1787: /*Changes for Lunar Payroll */
1788: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1789: IF l_hourly_salaried = 'H' THEN
1790: /*l_iltype_0036_bal := 0;

Line 1794: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);

1790: /*l_iltype_0036_bal := 0;
1791: ELSIF(csr_rec.payroll_period = '1' ) THEN */
1792: /*Bug 5020527 fix - Assigning the 'Hourly Overtime Hours' balance value to l_iltype_0036_unit
1793: and 'Hourly Overtime Pay' balance value to l_iltype_0036_bal*/
1794: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);
1795: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1796:
1797: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1798: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;

Line 1795: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/

1791: ELSIF(csr_rec.payroll_period = '1' ) THEN */
1792: /*Bug 5020527 fix - Assigning the 'Hourly Overtime Hours' balance value to l_iltype_0036_unit
1793: and 'Hourly Overtime Pay' balance value to l_iltype_0036_bal*/
1794: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);
1795: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1796:
1797: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1798: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;
1799: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);

Line 1797: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);

1793: and 'Hourly Overtime Pay' balance value to l_iltype_0036_bal*/
1794: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);
1795: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1796:
1797: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1798: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;
1799: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);
1800: l_old_iltype_0036_bal := l_old_iltype_0036_bal + l_iltype_0036_bal;
1801: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display

Line 1799: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);

1795: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1796:
1797: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1798: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;
1799: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);
1800: l_old_iltype_0036_bal := l_old_iltype_0036_bal + l_iltype_0036_bal;
1801: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display
1802: the negative values*/
1803: -- IF(l_iltype_0036_unit <0) THEN

Line 1815: l_iltype_0037_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0037_bal; -- l_date_to);

1811: /* After FS changes, now applicable to Salaried Payrolls only now, earlier was for all*/
1812: /* Adding new condition, to achieve this */
1813: /*IF(csr_rec.payroll_period = '1') THEN*/
1814: IF l_hourly_salaried = 'S' THEN
1815: l_iltype_0037_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0037_bal; -- l_date_to);
1816: l_old_iltype_0037_bal := l_old_iltype_0037_bal + l_iltype_0037_bal;
1817: l_iltype_0037_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0037_unit; -- l_date_to);
1818: l_old_iltype_0037_unit := l_old_iltype_0037_unit + l_iltype_0037_unit;
1819: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display

Line 1817: l_iltype_0037_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0037_unit; -- l_date_to);

1813: /*IF(csr_rec.payroll_period = '1') THEN*/
1814: IF l_hourly_salaried = 'S' THEN
1815: l_iltype_0037_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0037_bal; -- l_date_to);
1816: l_old_iltype_0037_bal := l_old_iltype_0037_bal + l_iltype_0037_bal;
1817: l_iltype_0037_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0037_unit; -- l_date_to);
1818: l_old_iltype_0037_unit := l_old_iltype_0037_unit + l_iltype_0037_unit;
1819: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display
1820: the negative values*/
1821: --IF(l_iltype_0037_unit <0) THEN

Line 1829: l_iltype_0091_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Gross Deduction',l_dimension ,l_bal_todate) - l_old_iltype_0091_bal;

1825: END IF;
1826: END IF;
1827:
1828: /* IL Type 0091 */
1829: l_iltype_0091_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Gross Deduction',l_dimension ,l_bal_todate) - l_old_iltype_0091_bal;
1830: l_old_iltype_0091_bal := l_old_iltype_0091_bal + l_iltype_0091_bal;
1831: --l_iltype_0091_unit := 1; --9888286
1832: l_iltype_0091_unit := 0; --9888286
1833:

Line 1836: l_iltype_0210_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Paid Work Hours',l_dimension ,l_bal_todate) - l_old_iltype_0210_unit;

1832: l_iltype_0091_unit := 0; --9888286
1833:
1834: /* IL Type 0210 */
1835: l_iltype_0210_bal := 0;
1836: l_iltype_0210_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Paid Work Hours',l_dimension ,l_bal_todate) - l_old_iltype_0210_unit;
1837: l_old_iltype_0210_unit := l_old_iltype_0210_unit + l_iltype_0210_unit;
1838:
1839: /* Added to fix issues due to varying numeric formats */
1840: /* Commented the below code as the below conversion fails if the application numeric format

Line 3001: END PAY_DK_STATSR_PKG;

2997: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
2998: HR_UTILITY.RAISE_ERROR;
2999: END WritetoCLOB;
3000:
3001: END PAY_DK_STATSR_PKG;