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.PAY_NL_WW_ADJUSTMENTS dependencies on FND_NUMBER

Line 96: SELECT fnd_number.canonical_to_number(hoi.org_information6) ee_perc,

92: RETURN VARCHAR2 IS
93:
94: -- Cursor to return contribution_percentages
95: CURSOR csr_get_cont_perc(c_si_type VARCHAR2, c_si_provider VARCHAR2, c_date_earned DATE) IS
96: SELECT fnd_number.canonical_to_number(hoi.org_information6) ee_perc,
97: fnd_number.canonical_to_number(hoi.org_information7) er_perc,
98: fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,
99: fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,
100: hoi.org_information3 si_type_name

Line 97: fnd_number.canonical_to_number(hoi.org_information7) er_perc,

93:
94: -- Cursor to return contribution_percentages
95: CURSOR csr_get_cont_perc(c_si_type VARCHAR2, c_si_provider VARCHAR2, c_date_earned DATE) IS
96: SELECT fnd_number.canonical_to_number(hoi.org_information6) ee_perc,
97: fnd_number.canonical_to_number(hoi.org_information7) er_perc,
98: fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,
99: fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,
100: hoi.org_information3 si_type_name
101: FROM

Line 98: fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,

94: -- Cursor to return contribution_percentages
95: CURSOR csr_get_cont_perc(c_si_type VARCHAR2, c_si_provider VARCHAR2, c_date_earned DATE) IS
96: SELECT fnd_number.canonical_to_number(hoi.org_information6) ee_perc,
97: fnd_number.canonical_to_number(hoi.org_information7) er_perc,
98: fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,
99: fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,
100: hoi.org_information3 si_type_name
101: FROM
102: hr_organization_information hoi

Line 99: fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,

95: CURSOR csr_get_cont_perc(c_si_type VARCHAR2, c_si_provider VARCHAR2, c_date_earned DATE) IS
96: SELECT fnd_number.canonical_to_number(hoi.org_information6) ee_perc,
97: fnd_number.canonical_to_number(hoi.org_information7) er_perc,
98: fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,
99: fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,
100: hoi.org_information3 si_type_name
101: FROM
102: hr_organization_information hoi
103: WHERE