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

Line 664: ,fnd_date.canonical_to_date('3712/12/31 00:00:00') Date_From

660: ) IS
661: SELECT ele.element_entry_id
662: ,ele.effective_start_date
663: ,ele.effective_end_date
664: ,fnd_date.canonical_to_date('3712/12/31 00:00:00') Date_From
665: -- ,( SELECT fnd_date.canonical_to_date(eev.screen_entry_value)
666: -- FROM pay_element_entry_values_f eev
667: -- WHERE eev.element_entry_id = ele.element_entry_id
668: -- AND ele.effective_start_date BETWEEN eev.effective_start_date

Line 665: -- ,( SELECT fnd_date.canonical_to_date(eev.screen_entry_value)

661: SELECT ele.element_entry_id
662: ,ele.effective_start_date
663: ,ele.effective_end_date
664: ,fnd_date.canonical_to_date('3712/12/31 00:00:00') Date_From
665: -- ,( SELECT fnd_date.canonical_to_date(eev.screen_entry_value)
666: -- FROM pay_element_entry_values_f eev
667: -- WHERE eev.element_entry_id = ele.element_entry_id
668: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
669: -- AND eev.effective_end_date

Line 672: ,fnd_date.canonical_to_date('3712/12/31 00:00:00') Date_To

668: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
669: -- AND eev.effective_end_date
670: -- AND eev.input_value_id = p_date_from_iv_id
671: -- ) Date_From
672: ,fnd_date.canonical_to_date('3712/12/31 00:00:00') Date_To
673: -- ,( SELECT fnd_date.canonical_to_date(eev.screen_entry_value)
674: -- FROM pay_element_entry_values_f eev
675: -- WHERE eev.element_entry_id = ele.element_entry_id
676: -- AND ele.effective_start_date BETWEEN eev.effective_start_date

Line 673: -- ,( SELECT fnd_date.canonical_to_date(eev.screen_entry_value)

669: -- AND eev.effective_end_date
670: -- AND eev.input_value_id = p_date_from_iv_id
671: -- ) Date_From
672: ,fnd_date.canonical_to_date('3712/12/31 00:00:00') Date_To
673: -- ,( SELECT fnd_date.canonical_to_date(eev.screen_entry_value)
674: -- FROM pay_element_entry_values_f eev
675: -- WHERE eev.element_entry_id = ele.element_entry_id
676: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
677: -- AND eev.effective_end_date

Line 757: ,fnd_date.canonical_to_date('3712/12/31 00:00:00')week_commencing

753: -- BETWEEN piv.effective_start_date
754: -- AND piv.effective_end_date
755: -- AND piv.input_value_id = p_amount_iv_id -- g_smp_input_values(1).id
756: -- ) amount
757: ,fnd_date.canonical_to_date('3712/12/31 00:00:00')week_commencing
758: -- ,(SELECT fnd_date.canonical_to_date(piv.screen_entry_value)
759: -- FROM pay_element_entry_values_f piv
760: -- WHERE piv.element_entry_id = ele.element_entry_id
761: -- AND ele.effective_start_date

Line 758: -- ,(SELECT fnd_date.canonical_to_date(piv.screen_entry_value)

754: -- AND piv.effective_end_date
755: -- AND piv.input_value_id = p_amount_iv_id -- g_smp_input_values(1).id
756: -- ) amount
757: ,fnd_date.canonical_to_date('3712/12/31 00:00:00')week_commencing
758: -- ,(SELECT fnd_date.canonical_to_date(piv.screen_entry_value)
759: -- FROM pay_element_entry_values_f piv
760: -- WHERE piv.element_entry_id = ele.element_entry_id
761: -- AND ele.effective_start_date
762: -- BETWEEN piv.effective_start_date