DBA Data[Home] [Help]

APPS.PER_DPF_BUS dependencies on FND_TERRITORIES

Line 483: -- FND_TERRITORIES.

479: -- ----------------------------------------------------------------------------
480: --
481: -- Description
482: -- This procedure is used to check that the country code exists in
483: -- FND_TERRITORIES.
484: --
485: -- Pre Conditions
486: -- None.
487: --

Line 523: from fnd_territories per

519: l_dummy varchar2(1);
520: --
521: cursor c1(p_code varchar2) is
522: select null
523: from fnd_territories per
524: where per.territory_code = p_code;
525: --
526: Begin
527: --

Line 549: -- Check if country code exists in FND_TERRITORIES.

545: or nvl(p_no_country3,hr_api.g_varchar2)
546: <> per_dpf_shd.g_old_rec.no_country3)
547: or not l_api_updating) then
548: --
549: -- Check if country code exists in FND_TERRITORIES.
550: --
551: if p_country1 is not null then
552: --
553: if nvl(p_country1,hr_api.g_varchar2) <>