APPS.BEN_OUR_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 155: -- HR_ALL_ORGANIZATION_UNITS table.

151: --
152: -- Description
153: -- This procedure is used to check that the foreign key for the table
154: -- is created properly. a corresponding record should exist in the
155: -- HR_ALL_ORGANIZATION_UNITS table.
156: --
157: -- Pre Conditions
158: -- None.
159: --

Line 161: -- organization_id FK of pointing to HR_ALL_ORGANIZATION_UNITS tables.

157: -- Pre Conditions
158: -- None.
159: --
160: -- In Parameters
161: -- organization_id FK of pointing to HR_ALL_ORGANIZATION_UNITS tables.
162: -- business_group_id or record being inserted or updated
163: -- effective_date Effective Date of session
164: --
165: -- Post Success

Line 181: from HR_ALL_ORGANIZATION_UNITS

177: --
178: l_proc varchar2(72) := g_package||'chk_organization_id';
179: l_dummy varchar2(1);
180: cursor c1 is select null
181: from HR_ALL_ORGANIZATION_UNITS
182: where organization_id = p_organization_id
183: and p_effective_date between nvl(date_from, p_effective_date)
184: and nvl(date_to, p_effective_date)
185: and business_group_id = p_business_group_id;