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.SSP_SMP_PKG dependencies on FND_DATE

Line 765: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then

761: -- she is not entitled to SMP.
762: -- But the employee gets complete SMP according to the
763: -- new regulations (due date after 06-APR-2003)
764: --
765: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then
766: hr_utility.set_location(l_proc,3);
767: if l_termination_date < woman.qw then
768: hr_utility.set_location(l_proc,4);
769: create_stoppage(p_withhold_from => l_termination_date + 1

Line 908: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')

904: -- SMP ceases on the Saturday following death
905: --
906: -- Bug 2663899 start
907: /*
908: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')
909: then
910: mpp_pay_period_end := mpp_start_date + new_mpp_period;
911: else
912: mpp_pay_period_end := mpp_start_date + current_mpp_period;

Line 1518: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

1514: /*to_date (ssp_smp_support_pkg.value
1515: (entry.element_entry_id,
1516: ssp_smp_pkg.c_week_commencing_name),
1517: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1518: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1519: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1520: -- Start Bug Fix for 7680593
1521: /*
1522: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

Line 1820: p_entry_value2 => fnd_date.date_to_chardate(old_entry.week_commencing),

1816: p_input_value_id3=> g_SMP_correction_element.amount_id,
1817: p_input_value_id4=> g_SMP_correction_element.recoverable_amount_id,
1818: p_entry_value1=> old_entry.rate,
1819: --p_entry_value2 => to_char(old_entry.week_commencing,'DD-MON-YYYY'),
1820: p_entry_value2 => fnd_date.date_to_chardate(old_entry.week_commencing),
1821: p_entry_value3=> old_entry.amount * -1,
1822: p_entry_value4=> old_entry.recoverable_amount * -1);
1823: --
1824: --New entry will be created by brand_new_entries loop if not p_deleting

Line 2053: hr_utility.trace('p_MPP_start_date : '||fnd_date.date_to_canonical(p_MPP_start_date));

2049: -- the legislation-specified proportion of average earnings (rounded
2050: -- UP to the nearest penny)
2051: --
2052: hr_utility.trace('Calculate at high rate');
2053: hr_utility.trace('p_MPP_start_date : '||fnd_date.date_to_canonical(p_MPP_start_date));
2054: if p_MPP_start_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2055: hr_utility.trace('MPP start date after 06-APR-2003, therefore 90 percent of average earnings');
2056: hypothetical_entry.amount (p_week_number)
2057: := round((average_earnings * g_SMP_element.higher_SMP_rate)

Line 2054: if p_MPP_start_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then

2050: -- UP to the nearest penny)
2051: --
2052: hr_utility.trace('Calculate at high rate');
2053: hr_utility.trace('p_MPP_start_date : '||fnd_date.date_to_canonical(p_MPP_start_date));
2054: if p_MPP_start_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2055: hr_utility.trace('MPP start date after 06-APR-2003, therefore 90 percent of average earnings');
2056: hypothetical_entry.amount (p_week_number)
2057: := round((average_earnings * g_SMP_element.higher_SMP_rate)
2058: + 0.0049,2);

Line 2068: hr_utility.trace('Calculating for lower, therfore we need to find out if week commencing date is before or after 06-APR-2003, week_commencing : '||fnd_date.date_to_canonical(hypothetical_entry.week_commencing(p_week_number)));

2064: + 0.0049,2),
2065: g_SMP_element.lower_SMP_rate);
2066: end if;
2067: else
2068: hr_utility.trace('Calculating for lower, therfore we need to find out if week commencing date is before or after 06-APR-2003, week_commencing : '||fnd_date.date_to_canonical(hypothetical_entry.week_commencing(p_week_number)));
2069: if hypothetical_entry.week_commencing(p_week_number) <
2070: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2071: hr_utility.trace('Decided week commencing before 06-APR-2003');
2072: -- Any SMP weeks paid before 06-APR-2003 to be paid

Line 2070: fnd_date.canonical_to_date('2003/04/06 00:00:00') then

2066: end if;
2067: else
2068: hr_utility.trace('Calculating for lower, therfore we need to find out if week commencing date is before or after 06-APR-2003, week_commencing : '||fnd_date.date_to_canonical(hypothetical_entry.week_commencing(p_week_number)));
2069: if hypothetical_entry.week_commencing(p_week_number) <
2070: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
2071: hr_utility.trace('Decided week commencing before 06-APR-2003');
2072: -- Any SMP weeks paid before 06-APR-2003 to be paid
2073: -- at floored lower amount
2074: hypothetical_entry.amount (p_week_number)

Line 2077: fnd_date.canonical_to_date('2003/04/06 00:00:00') and

2073: -- at floored lower amount
2074: hypothetical_entry.amount (p_week_number)
2075: := g_SMP_element.lower_SMP_rate;
2076: elsif (hypothetical_entry.week_commencing(p_week_number) >=
2077: fnd_date.canonical_to_date('2003/04/06 00:00:00') and
2078: p_MPP_start_date < fnd_date.canonical_to_date('2003/04/06 00:00:00')) then
2079: -- For payments after 06-APR-2003 for maternities with MPP start date
2080: -- prior to 06-APR-2003, the payment must be underpinned by SMP
2081: -- lower rate

Line 2078: p_MPP_start_date < fnd_date.canonical_to_date('2003/04/06 00:00:00')) then

2074: hypothetical_entry.amount (p_week_number)
2075: := g_SMP_element.lower_SMP_rate;
2076: elsif (hypothetical_entry.week_commencing(p_week_number) >=
2077: fnd_date.canonical_to_date('2003/04/06 00:00:00') and
2078: p_MPP_start_date < fnd_date.canonical_to_date('2003/04/06 00:00:00')) then
2079: -- For payments after 06-APR-2003 for maternities with MPP start date
2080: -- prior to 06-APR-2003, the payment must be underpinned by SMP
2081: -- lower rate
2082: hr_utility.trace('Week commenicng is after 06-APR-2003, but MPP start date is before 06-APR-2003, therfore amount must be underpinned');