DBA Data[Home] [Help]

APPS.PYUSDAR_PKG dependencies on HR_GENERAL2

Line 158: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then

154: l_payroll_id := pyusdar_pkg.get_parameter('PAYROLL_ID', leg_param);
155: --
156: --Database Version --Bug 3331028
157:
158: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
159: l_db_version := '/*+ RULE */';
160: else
161: l_db_version := '/* NO RULE*/';
162: end if;

Line 363: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then

359: --hr_utility.trace_on(null, 'DAR');
360: hr_utility.set_location('procdar',1);
361:
362: -- Database Version --Bug 3331028
363: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
364: l_db_version := '/*+ RULE */';
365: else
366: l_db_version := '/* NO RULE*/';
367: end if;

Line 959: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then

955: begin
956: -- go through each of the sql sub strings and see if
957: -- they are needed.
958: -- Databse Version --Bug 3331028
959: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
960: l_db_version := '/*+ RULE */';
961: else
962: l_db_version := '/* NO RULE*/';
963: end if;