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_PYP_BUS dependencies on FND_NUMBER

Line 1749: --Change Description: Modified the cursor to use fnd_number.canonical_to_number instead of to_number

1745: --
1746: -- define cursor to get ele/link min/max values
1747: --
1748: --Bug: 3026239
1749: --Change Description: Modified the cursor to use fnd_number.canonical_to_number instead of to_number
1750: --Changed by: kgowripe
1751: Cursor csr_get_ele_values is
1752: select iv.warning_or_error,
1753: fnd_number.canonical_to_number(iv.min_value),

Line 1753: fnd_number.canonical_to_number(iv.min_value),

1749: --Change Description: Modified the cursor to use fnd_number.canonical_to_number instead of to_number
1750: --Changed by: kgowripe
1751: Cursor csr_get_ele_values is
1752: select iv.warning_or_error,
1753: fnd_number.canonical_to_number(iv.min_value),
1754: fnd_number.canonical_to_number(iv.max_value),
1755: liv.warning_or_error,
1756: fnd_number.canonical_to_number(liv.min_value),
1757: fnd_number.canonical_to_number(liv.max_value)

Line 1754: fnd_number.canonical_to_number(iv.max_value),

1750: --Changed by: kgowripe
1751: Cursor csr_get_ele_values is
1752: select iv.warning_or_error,
1753: fnd_number.canonical_to_number(iv.min_value),
1754: fnd_number.canonical_to_number(iv.max_value),
1755: liv.warning_or_error,
1756: fnd_number.canonical_to_number(liv.min_value),
1757: fnd_number.canonical_to_number(liv.max_value)
1758: from pay_link_input_values_f liv,

Line 1756: fnd_number.canonical_to_number(liv.min_value),

1752: select iv.warning_or_error,
1753: fnd_number.canonical_to_number(iv.min_value),
1754: fnd_number.canonical_to_number(iv.max_value),
1755: liv.warning_or_error,
1756: fnd_number.canonical_to_number(liv.min_value),
1757: fnd_number.canonical_to_number(liv.max_value)
1758: from pay_link_input_values_f liv,
1759: pay_input_values_f iv,
1760: pay_element_links_f el,

Line 1757: fnd_number.canonical_to_number(liv.max_value)

1753: fnd_number.canonical_to_number(iv.min_value),
1754: fnd_number.canonical_to_number(iv.max_value),
1755: liv.warning_or_error,
1756: fnd_number.canonical_to_number(liv.min_value),
1757: fnd_number.canonical_to_number(liv.max_value)
1758: from pay_link_input_values_f liv,
1759: pay_input_values_f iv,
1760: pay_element_links_f el,
1761: per_pay_bases ppb

Line 1782: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,

1778: --
1779: Cursor csr_get_min_max_values is
1780: select p_normal_hours,
1781: p_frequency,
1782: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1783: O2.ORG_INFORMATION4 frequency,
1784: fnd_number.canonical_to_number(b2.ORG_INFORMATION3) working_hours,
1785: b2.ORG_INFORMATION4 frequency,
1786: fnd_number.canonical_to_number(pgr.minimum),

Line 1784: fnd_number.canonical_to_number(b2.ORG_INFORMATION3) working_hours,

1780: select p_normal_hours,
1781: p_frequency,
1782: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1783: O2.ORG_INFORMATION4 frequency,
1784: fnd_number.canonical_to_number(b2.ORG_INFORMATION3) working_hours,
1785: b2.ORG_INFORMATION4 frequency,
1786: fnd_number.canonical_to_number(pgr.minimum),
1787: fnd_number.canonical_to_number(pgr.maximum)
1788: from

Line 1786: fnd_number.canonical_to_number(pgr.minimum),

1782: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1783: O2.ORG_INFORMATION4 frequency,
1784: fnd_number.canonical_to_number(b2.ORG_INFORMATION3) working_hours,
1785: b2.ORG_INFORMATION4 frequency,
1786: fnd_number.canonical_to_number(pgr.minimum),
1787: fnd_number.canonical_to_number(pgr.maximum)
1788: from
1789: hr_all_organization_units bus, HR_ORGANIZATION_INFORMATION b2 ,
1790: hr_all_organization_units org, HR_ORGANIZATION_INFORMATION O2 ,

Line 1787: fnd_number.canonical_to_number(pgr.maximum)

1783: O2.ORG_INFORMATION4 frequency,
1784: fnd_number.canonical_to_number(b2.ORG_INFORMATION3) working_hours,
1785: b2.ORG_INFORMATION4 frequency,
1786: fnd_number.canonical_to_number(pgr.minimum),
1787: fnd_number.canonical_to_number(pgr.maximum)
1788: from
1789: hr_all_organization_units bus, HR_ORGANIZATION_INFORMATION b2 ,
1790: hr_all_organization_units org, HR_ORGANIZATION_INFORMATION O2 ,
1791: pay_grade_rules_f pgr,