APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on HR_GENERAL2

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

248: ,p_payroll_id => ln_payroll_id
249: ,p_consolidation_set_id => ln_consolidation_set_id);
250:
251: --Database Version --Bug 3331028
252: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
253: l_db_version := '/*+ RULE */';
254: else
255: l_db_version := '/* NO RULE*/';
256: end if;

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

668: l_db_version varchar2(20);
669:
670: BEGIN
671: -- Databse Version --Bug 3331028
672: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
673: l_db_version := '/*+ RULE */';
674: else
675: l_db_version := '/* NO RULE*/';
676: end if;

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

870: BEGIN
871: hr_utility.set_location('procdar',1);
872:
873: -- Database Version --Bug 3331028
874: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
875: l_db_version := '/*+ RULE */';
876: else
877: l_db_version := '/* NO RULE*/';
878: end if;

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

1475: --
1476: --
1477:
1478: --Database Version --Bug 3331028
1479: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
1480: l_db_version := '/*+ RULE */';
1481: else
1482: l_db_version := '/* NO RULE*/';
1483: end if;