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 PAY_ELEMENT_ENTRY_VALUES_F

Line 666: -- FROM pay_element_entry_values_f eev

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
670: -- AND eev.input_value_id = p_date_from_iv_id

Line 674: -- FROM pay_element_entry_values_f eev

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
678: -- AND eev.input_value_id = p_date_to_iv_id

Line 682: -- FROM pay_element_entry_values_f eev

678: -- AND eev.input_value_id = p_date_to_iv_id
679: -- ) Date_To
680: ,fnd_number.canonical_to_number('0.0') Amount
681: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)
682: -- FROM pay_element_entry_values_f eev
683: -- WHERE eev.element_entry_id = ele.element_entry_id
684: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
685: -- AND eev.effective_end_date
686: -- AND eev.input_value_id = p_amount_iv_id

Line 690: -- FROM pay_element_entry_values_f eev

686: -- AND eev.input_value_id = p_amount_iv_id
687: -- ) Amount
688: ,fnd_number.canonical_to_number('0.0') Rate
689: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)
690: -- FROM pay_element_entry_values_f eev
691: -- WHERE eev.element_entry_id = ele.element_entry_id
692: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
693: -- AND eev.effective_end_date
694: -- AND eev.input_value_id = p_rate_iv_id

Line 698: -- FROM pay_element_entry_values_f eev

694: -- AND eev.input_value_id = p_rate_iv_id
695: -- ) Rate
696: ,fnd_number.canonical_to_number('0.0') Qualifying_days
697: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)
698: -- FROM pay_element_entry_values_f eev
699: -- WHERE eev.element_entry_id = ele.element_entry_id
700: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
701: -- AND eev.effective_end_date
702: -- AND eev.input_value_id = p_qualifying_days_iv_id

Line 706: -- FROM pay_element_entry_values_f eev

702: -- AND eev.input_value_id = p_qualifying_days_iv_id
703: -- ) Qualifying_days
704: ,fnd_number.canonical_to_number('0.0') SSP_days_due
705: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)
706: -- FROM pay_element_entry_values_f eev
707: -- WHERE eev.element_entry_id = ele.element_entry_id
708: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
709: -- AND eev.effective_end_date
710: -- AND eev.input_value_id = p_ssp_days_due_iv_id

Line 714: -- FROM pay_element_entry_values_f eev

710: -- AND eev.input_value_id = p_ssp_days_due_iv_id
711: -- ) SSP_days_due
712: ,fnd_number.canonical_to_number('0.0') Withheld_days
713: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)
714: -- FROM pay_element_entry_values_f eev
715: -- WHERE eev.element_entry_id = ele.element_entry_id
716: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
717: -- AND eev.effective_end_date
718: -- AND eev.input_value_id = p_withheld_days_iv_id

Line 722: -- FROM pay_element_entry_values_f eev

718: -- AND eev.input_value_id = p_withheld_days_iv_id
719: -- ) Withheld_days
720: -- ,fnd_number.canonical_to_number('0.0') SSP_weeks
721: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)
722: -- FROM pay_element_entry_values_f eev
723: -- WHERE eev.element_entry_id = ele.element_entry_id
724: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
725: -- AND eev.effective_end_date
726: -- AND eev.input_value_id = p_ssp_week_iv_id

Line 750: -- FROM pay_element_entry_values_f piv

746: ,ele.effective_start_date
747: ,ele.effective_end_date
748: ,fnd_number.canonical_to_number('0.0') amount
749: -- ,(SELECT fnd_number.canonical_to_number(piv.screen_entry_value)
750: -- FROM pay_element_entry_values_f piv
751: -- WHERE piv.element_entry_id = ele.element_entry_id
752: -- AND ele.effective_start_date
753: -- BETWEEN piv.effective_start_date
754: -- AND piv.effective_end_date

Line 759: -- FROM pay_element_entry_values_f piv

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
763: -- AND piv.effective_end_date

Line 768: -- FROM pay_element_entry_values_f piv

764: -- AND piv.input_value_id = p_week_commencing_iv_id -- g_smp_input_values(2).id
765: -- ) week_commencing
766: -- ,rpad(' ',60,' ') rate
767: -- ,(SELECT piv.screen_entry_value rate /* text */
768: -- FROM pay_element_entry_values_f piv
769: -- WHERE piv.element_entry_id = ele.element_entry_id
770: -- AND ele.effective_start_date
771: -- BETWEEN piv.effective_start_date
772: -- AND piv.effective_end_date

Line 777: -- FROM pay_element_entry_values_f piv

773: -- AND piv.input_value_id = p_rate_iv_id -- g_smp_input_values(3).id
774: -- )
775: -- ,fnd_number.canonical_to_number(piv.screen_entry_value) recoverable_amount
776: -- ,(SELECT fnd_number.canonical_to_number(piv.screen_entry_value) recoverable_amount
777: -- FROM pay_element_entry_values_f piv
778: -- WHERE piv.element_entry_id = ele.element_entry_id
779: -- AND ele.effective_start_date
780: -- BETWEEN piv.effective_start_date
781: -- AND piv.effective_end_date

Line 798: FROM pay_element_entry_values_f eev

794: ,p_effective_date IN DATE
795: ,p_input_value_id IN NUMBER
796: ) IS
797: SELECT eev.screen_entry_value
798: FROM pay_element_entry_values_f eev
799: WHERE eev.element_entry_id = p_element_entry_id
800: AND p_effective_date
801: BETWEEN eev.effective_start_date
802: AND eev.effective_end_date