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 1638: --Change Description: Modified the cursor to use fnd_number.canonical_to_number instead of to_number

1634: --
1635: -- define cursor to get ele/link min/max values
1636: --
1637: --Bug: 3026239
1638: --Change Description: Modified the cursor to use fnd_number.canonical_to_number instead of to_number
1639: --Changed by: kgowripe
1640: Cursor csr_get_ele_values is
1641: select iv.warning_or_error,
1642: fnd_number.canonical_to_number(iv.min_value),

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

1638: --Change Description: Modified the cursor to use fnd_number.canonical_to_number instead of to_number
1639: --Changed by: kgowripe
1640: Cursor csr_get_ele_values is
1641: select iv.warning_or_error,
1642: fnd_number.canonical_to_number(iv.min_value),
1643: fnd_number.canonical_to_number(iv.max_value),
1644: liv.warning_or_error,
1645: fnd_number.canonical_to_number(liv.min_value),
1646: fnd_number.canonical_to_number(liv.max_value)

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

1639: --Changed by: kgowripe
1640: Cursor csr_get_ele_values is
1641: select iv.warning_or_error,
1642: fnd_number.canonical_to_number(iv.min_value),
1643: fnd_number.canonical_to_number(iv.max_value),
1644: liv.warning_or_error,
1645: fnd_number.canonical_to_number(liv.min_value),
1646: fnd_number.canonical_to_number(liv.max_value)
1647: from pay_link_input_values_f liv,

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

1641: select iv.warning_or_error,
1642: fnd_number.canonical_to_number(iv.min_value),
1643: fnd_number.canonical_to_number(iv.max_value),
1644: liv.warning_or_error,
1645: fnd_number.canonical_to_number(liv.min_value),
1646: fnd_number.canonical_to_number(liv.max_value)
1647: from pay_link_input_values_f liv,
1648: pay_input_values_f iv,
1649: pay_element_links_f el,

Line 1646: fnd_number.canonical_to_number(liv.max_value)

1642: fnd_number.canonical_to_number(iv.min_value),
1643: fnd_number.canonical_to_number(iv.max_value),
1644: liv.warning_or_error,
1645: fnd_number.canonical_to_number(liv.min_value),
1646: fnd_number.canonical_to_number(liv.max_value)
1647: from pay_link_input_values_f liv,
1648: pay_input_values_f iv,
1649: pay_element_links_f el,
1650: per_pay_bases ppb

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

1667: --
1668: Cursor csr_get_min_max_values is
1669: select p_normal_hours,
1670: p_frequency,
1671: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1672: O2.ORG_INFORMATION4 frequency,
1673: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1674: O2.ORG_INFORMATION4 frequency,
1675: fnd_number.canonical_to_number(pgr.minimum),

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

1669: select p_normal_hours,
1670: p_frequency,
1671: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1672: O2.ORG_INFORMATION4 frequency,
1673: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1674: O2.ORG_INFORMATION4 frequency,
1675: fnd_number.canonical_to_number(pgr.minimum),
1676: fnd_number.canonical_to_number(pgr.maximum)
1677: from

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

1671: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1672: O2.ORG_INFORMATION4 frequency,
1673: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1674: O2.ORG_INFORMATION4 frequency,
1675: fnd_number.canonical_to_number(pgr.minimum),
1676: fnd_number.canonical_to_number(pgr.maximum)
1677: from
1678: hr_all_organization_units bus, HR_ORGANIZATION_INFORMATION b2 ,
1679: hr_all_organization_units org, HR_ORGANIZATION_INFORMATION O2 ,

Line 1676: fnd_number.canonical_to_number(pgr.maximum)

1672: O2.ORG_INFORMATION4 frequency,
1673: fnd_number.canonical_to_number(O2.ORG_INFORMATION3) working_hours,
1674: O2.ORG_INFORMATION4 frequency,
1675: fnd_number.canonical_to_number(pgr.minimum),
1676: fnd_number.canonical_to_number(pgr.maximum)
1677: from
1678: hr_all_organization_units bus, HR_ORGANIZATION_INFORMATION b2 ,
1679: hr_all_organization_units org, HR_ORGANIZATION_INFORMATION O2 ,
1680: pay_grade_rules_f pgr,