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 758: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then

754: -- she is not entitled to SMP.
755: -- But the employee gets complete SMP according to the
756: -- new regulations (due date after 06-APR-2003)
757: --
758: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then
759: hr_utility.set_location(l_proc,3);
760: if l_termination_date < woman.qw then
761: hr_utility.set_location(l_proc,4);
762: create_stoppage(p_withhold_from => l_termination_date + 1

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

897: -- SMP ceases on the Saturday following death
898: --
899: -- Bug 2663899 start
900: /*
901: if woman.due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')
902: then
903: mpp_pay_period_end := mpp_start_date + new_mpp_period;
904: else
905: mpp_pay_period_end := mpp_start_date + current_mpp_period;

Line 1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

1443: /*to_date (ssp_smp_support_pkg.value
1444: (entry.element_entry_id,
1445: ssp_smp_pkg.c_week_commencing_name),
1446: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1448: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1449: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1450: ssp_smp_pkg.c_amount_name)) AMOUNT,
1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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

1737: p_input_value_id3=> g_SMP_correction_element.amount_id,
1738: p_input_value_id4=> g_SMP_correction_element.recoverable_amount_id,
1739: p_entry_value1=> old_entry.rate,
1740: --p_entry_value2 => to_char(old_entry.week_commencing,'DD-MON-YYYY'),
1741: p_entry_value2 => fnd_date.date_to_chardate(old_entry.week_commencing),
1742: p_entry_value3=> old_entry.amount * -1,
1743: p_entry_value4=> old_entry.recoverable_amount * -1);
1744: --
1745: --New entry will be created by brand_new_entries loop if not p_deleting

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

1970: -- the legislation-specified proportion of average earnings (rounded
1971: -- UP to the nearest penny)
1972: --
1973: hr_utility.trace('Calculate at high rate');
1974: hr_utility.trace('p_MPP_start_date : '||fnd_date.date_to_canonical(p_MPP_start_date));
1975: if p_MPP_start_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then
1976: hr_utility.trace('MPP start date after 06-APR-2003, therefore 90 percent of average earnings');
1977: hypothetical_entry.amount (p_week_number)
1978: := round((average_earnings * g_SMP_element.higher_SMP_rate)

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

1971: -- UP to the nearest penny)
1972: --
1973: hr_utility.trace('Calculate at high rate');
1974: hr_utility.trace('p_MPP_start_date : '||fnd_date.date_to_canonical(p_MPP_start_date));
1975: if p_MPP_start_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') then
1976: hr_utility.trace('MPP start date after 06-APR-2003, therefore 90 percent of average earnings');
1977: hypothetical_entry.amount (p_week_number)
1978: := round((average_earnings * g_SMP_element.higher_SMP_rate)
1979: + 0.0049,2);

Line 1989: 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)));

1985: + 0.0049,2),
1986: g_SMP_element.lower_SMP_rate);
1987: end if;
1988: else
1989: 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)));
1990: if hypothetical_entry.week_commencing(p_week_number) <
1991: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
1992: hr_utility.trace('Decided week commencing before 06-APR-2003');
1993: -- Any SMP weeks paid before 06-APR-2003 to be paid

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

1987: end if;
1988: else
1989: 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)));
1990: if hypothetical_entry.week_commencing(p_week_number) <
1991: fnd_date.canonical_to_date('2003/04/06 00:00:00') then
1992: hr_utility.trace('Decided week commencing before 06-APR-2003');
1993: -- Any SMP weeks paid before 06-APR-2003 to be paid
1994: -- at floored lower amount
1995: hypothetical_entry.amount (p_week_number)

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

1994: -- at floored lower amount
1995: hypothetical_entry.amount (p_week_number)
1996: := g_SMP_element.lower_SMP_rate;
1997: elsif (hypothetical_entry.week_commencing(p_week_number) >=
1998: fnd_date.canonical_to_date('2003/04/06 00:00:00') and
1999: p_MPP_start_date < fnd_date.canonical_to_date('2003/04/06 00:00:00')) then
2000: -- For payments after 06-APR-2003 for maternities with MPP start date
2001: -- prior to 06-APR-2003, the payment must be underpinned by SMP
2002: -- lower rate

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

1995: hypothetical_entry.amount (p_week_number)
1996: := g_SMP_element.lower_SMP_rate;
1997: elsif (hypothetical_entry.week_commencing(p_week_number) >=
1998: fnd_date.canonical_to_date('2003/04/06 00:00:00') and
1999: p_MPP_start_date < fnd_date.canonical_to_date('2003/04/06 00:00:00')) then
2000: -- For payments after 06-APR-2003 for maternities with MPP start date
2001: -- prior to 06-APR-2003, the payment must be underpinned by SMP
2002: -- lower rate
2003: hr_utility.trace('Week commenicng is after 06-APR-2003, but MPP start date is before 06-APR-2003, therfore amount must be underpinned');