DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on STANDARD

Line 108: 17-DEC-2003 RMakhija 115.25 Added detection of SMP/SAP/SPP standard rate

104: 24-OCT-2003 ABlinko 115.22 Replaced hardcoded SATURDAY and SUNDAY references
105: 08-DEC-2003 RMakhija 115.24 Uncommented SMP element entry update when rate
106: changes in next tax year. Also added similar
107: Functionality for SAP, SPP Birth and SPP Adoption.
108: 17-DEC-2003 RMakhija 115.25 Added detection of SMP/SAP/SPP standard rate
109: changes and SMP Higher Rate changes to auto
110: update element entries in next tax year.
111: 12-FEB-2004 RMakhija 115.26 Bug 3437026. Updated csr_affected_leave
112: cursor in update_ssp_smp_entries procedure.

Line 1274: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);

1270: close csr_new_smp_rate;
1271: --
1272: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
1273: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
1274: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
1275: --
1276: /* Find SMP rate for current tax year */
1277: open csr_old_smp_rate;
1278: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;

Line 1283: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);

1279: close csr_old_smp_rate;
1280: --
1281: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
1282: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
1283: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
1284: --
1285: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
1286: then
1287: return false;

Line 2324: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);

2320: close csr_new_smp_rate;
2321: --
2322: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
2323: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
2324: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
2325: --
2326: /* Find SMP rate for current tax year */
2327: open csr_old_smp_rate;
2328: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;

Line 2333: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);

2329: close csr_old_smp_rate;
2330: --
2331: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
2332: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
2333: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
2334: --
2335: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
2336: then
2337: return false;