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

Line 97: AND fnd_date.canonical_to_date(peev2.screen_entry_value) <= nvl(l_benefit_end_date,to_date('31-12-4712','DD-MM-YYYY'))

93: and pee.element_entry_id =peev2.element_entry_id
94: AND peev2.input_value_id = p_input_value_id_start
95: and pee.element_entry_id =peev3.element_entry_id
96: AND peev3.input_value_id = p_input_value_id_end
97: AND fnd_date.canonical_to_date(peev2.screen_entry_value) <= nvl(l_benefit_end_date,to_date('31-12-4712','DD-MM-YYYY'))
98: AND nvl(fnd_date.canonical_to_date(peev3.screen_entry_value),to_date('31-12-4712','DD-MM-YYYY')) >= l_benefit_start_date
99: AND pee.element_entry_id <> p_element_entry_id -- Bugfix 4049484
100: AND p_effective_date BETWEEN pee.effective_start_date and pee.effective_end_date
101: AND p_effective_date BETWEEN peev1.effective_start_date and peev1.effective_end_date

Line 98: AND nvl(fnd_date.canonical_to_date(peev3.screen_entry_value),to_date('31-12-4712','DD-MM-YYYY')) >= l_benefit_start_date

94: AND peev2.input_value_id = p_input_value_id_start
95: and pee.element_entry_id =peev3.element_entry_id
96: AND peev3.input_value_id = p_input_value_id_end
97: AND fnd_date.canonical_to_date(peev2.screen_entry_value) <= nvl(l_benefit_end_date,to_date('31-12-4712','DD-MM-YYYY'))
98: AND nvl(fnd_date.canonical_to_date(peev3.screen_entry_value),to_date('31-12-4712','DD-MM-YYYY')) >= l_benefit_start_date
99: AND pee.element_entry_id <> p_element_entry_id -- Bugfix 4049484
100: AND p_effective_date BETWEEN pee.effective_start_date and pee.effective_end_date
101: AND p_effective_date BETWEEN peev1.effective_start_date and peev1.effective_end_date
102: AND p_effective_date BETWEEN peev2.effective_start_date and peev2.effective_end_date

Line 721: l_benefit_start_date :=fnd_Date.canonical_to_date(l_benefit_start);

717: if g_debug then
718: pay_in_utils.trace('l_benefit_end : ',l_benefit_end);
719: end if;
720:
721: l_benefit_start_date :=fnd_Date.canonical_to_date(l_benefit_start);
722: l_benefit_end_date :=fnd_Date.canonical_to_date(l_benefit_end);
723:
724: if g_debug then
725: pay_in_utils.trace('l_benefit_start_date : ',l_benefit_start_date);

Line 722: l_benefit_end_date :=fnd_Date.canonical_to_date(l_benefit_end);

718: pay_in_utils.trace('l_benefit_end : ',l_benefit_end);
719: end if;
720:
721: l_benefit_start_date :=fnd_Date.canonical_to_date(l_benefit_start);
722: l_benefit_end_date :=fnd_Date.canonical_to_date(l_benefit_end);
723:
724: if g_debug then
725: pay_in_utils.trace('l_benefit_start_date : ',l_benefit_start_date);
726: pay_in_utils.trace('l_benefit_end_date : ',l_benefit_end_date);