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_NUMBER

Line 109: AND petei.eei_information1 = fnd_number.number_to_canonical(bpl.pl_id)

105: AND petei.information_type = p_information_type
106: --'PQP_GB_ABSENCE_PLAN_INFO'
107: AND bpl.pl_typ_id = bpty.pl_typ_id
108: AND bpty.opt_typ_cd = 'ABS'
109: AND petei.eei_information1 = fnd_number.number_to_canonical(bpl.pl_id)
110: AND bpl.pl_id = p_pl_id;
111:
112: -- Cursor to get Plan Id from Plan Tables for a given Plan Name.
113: CURSOR csr_plan_id(

Line 680: ,fnd_number.canonical_to_number('0.0') Amount

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
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

Line 681: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)

677: -- AND eev.effective_end_date
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

Line 688: ,fnd_number.canonical_to_number('0.0') Rate

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
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

Line 689: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)

685: -- AND eev.effective_end_date
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

Line 696: ,fnd_number.canonical_to_number('0.0') Qualifying_days

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
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

Line 697: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)

693: -- AND eev.effective_end_date
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

Line 704: ,fnd_number.canonical_to_number('0.0') SSP_days_due

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
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

Line 705: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)

701: -- AND eev.effective_end_date
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

Line 712: ,fnd_number.canonical_to_number('0.0') Withheld_days

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
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

Line 713: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)

709: -- AND eev.effective_end_date
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

Line 720: -- ,fnd_number.canonical_to_number('0.0') SSP_weeks

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
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

Line 721: -- ,( SELECT fnd_number.canonical_to_number(eev.screen_entry_value)

717: -- AND eev.effective_end_date
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

Line 748: ,fnd_number.canonical_to_number('0.0') amount

744: ) IS
745: SELECT ele.element_entry_id
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

Line 749: -- ,(SELECT fnd_number.canonical_to_number(piv.screen_entry_value)

745: SELECT ele.element_entry_id
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

Line 775: -- ,fnd_number.canonical_to_number(piv.screen_entry_value) recoverable_amount

771: -- BETWEEN piv.effective_start_date
772: -- AND piv.effective_end_date
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

Line 776: -- ,(SELECT fnd_number.canonical_to_number(piv.screen_entry_value) recoverable_amount

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

Line 829: SELECT (fnd_number.canonical_to_number(element_information1) * 7) max_value

825: CURSOR csr_max_ssp_period
826: (p_element_type_id IN NUMBER
827: ,p_effective_date IN DATE
828: ) IS
829: SELECT (fnd_number.canonical_to_number(element_information1) * 7) max_value
830: FROM pay_element_types_f
831: WHERE element_type_id = p_element_type_id
832: AND p_effective_date
833: BETWEEN effective_start_date

Line 875: SELECT fnd_number.canonical_to_number(elt.element_information1) earliest_start_mpp

871: CURSOR csr_smp_info
872: (p_smp_element_type_id IN NUMBER
873: ,p_effective_date IN DATE
874: ) IS
875: SELECT fnd_number.canonical_to_number(elt.element_information1) earliest_start_mpp
876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week
877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate

Line 876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week

872: (p_smp_element_type_id IN NUMBER
873: ,p_effective_date IN DATE
874: ) IS
875: SELECT fnd_number.canonical_to_number(elt.element_information1) earliest_start_mpp
876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week
877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate
880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate

Line 877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks

873: ,p_effective_date IN DATE
874: ) IS
875: SELECT fnd_number.canonical_to_number(elt.element_information1) earliest_start_mpp
876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week
877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate
880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate
881: FROM pay_element_types_f elt

Line 878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate

874: ) IS
875: SELECT fnd_number.canonical_to_number(elt.element_information1) earliest_start_mpp
876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week
877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate
880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate
881: FROM pay_element_types_f elt
882: WHERE elt.element_type_id = p_smp_element_type_id

Line 879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate

875: SELECT fnd_number.canonical_to_number(elt.element_information1) earliest_start_mpp
876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week
877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate
880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate
881: FROM pay_element_types_f elt
882: WHERE elt.element_type_id = p_smp_element_type_id
883: AND p_effective_date

Line 880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate

876: ,fnd_number.canonical_to_number(elt.element_information2) qualifying_week
877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate
880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate
881: FROM pay_element_types_f elt
882: WHERE elt.element_type_id = p_smp_element_type_id
883: AND p_effective_date
884: BETWEEN elt.effective_start_date

Line 893: SELECT (fnd_number.canonical_to_number(element_information4) * 7) max_value

889: CURSOR csr_max_smp_period
890: (p_element_type_id IN NUMBER
891: ,p_effective_date IN DATE
892: ) IS
893: SELECT (fnd_number.canonical_to_number(element_information4) * 7) max_value
894: FROM pay_element_types_f
895: WHERE element_type_id = p_element_type_id
896: AND p_effective_date
897: BETWEEN effective_start_date