APPS.BEN_LGL_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 87: -- HR_ALL_ORGANIZATION_UNITS table.

83: --
84: -- Description
85: -- This procedure is used to check that the foreign key for the table
86: -- is created properly. a corresponding record should exist in the
87: -- HR_ALL_ORGANIZATION_UNITS table.
88: --
89: -- Pre Conditions
90: -- None.
91: --

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

89: -- Pre Conditions
90: -- None.
91: --
92: -- In Parameters
93: -- organization_id FK of pointing to HR_ALL_ORGANIZATION_UNITS tables.
94: -- business_group_id or record being inserted or updated
95: -- effective_date Effective Date of session
96: --
97: -- Post Success

Line 113: from HR_ALL_ORGANIZATION_UNITS

109: --
110: l_proc varchar2(72) := g_package||'chk_organization_id';
111: l_dummy varchar2(1);
112: cursor c1 is select null
113: from HR_ALL_ORGANIZATION_UNITS
114: where organization_id = p_organization_id
115: and p_effective_date between nvl(date_from, p_effective_date)
116: and nvl(date_to, p_effective_date)
117: and business_group_id = p_business_group_id;