DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_ORGANIZATION_UNITS

Line 6705: from per_organization_units

6701: and internal_external_flag = 'INT';
6702: --
6703: cursor csr_valid_per_org is
6704: select null
6705: from per_organization_units
6706: where organization_id = p_organization_id;
6707: --
6708: begin
6709: if g_debug then

Line 6818: -- Check that the organization exists in PER_ORGANIZATION_UNITS.

6814: -- Check for a primary assignment
6815: --
6816: if p_primary_flag = 'Y' then
6817: --
6818: -- Check that the organization exists in PER_ORGANIZATION_UNITS.
6819: --
6820: open csr_valid_per_org;
6821: fetch csr_valid_per_org into l_exists;
6822: if csr_valid_per_org%notfound then