APPS.BEN_APR_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 119: from hr_all_organization_units org,

115: l_dummy varchar2(1);
116: --
117: cursor c1 is
118: select null
119: from hr_all_organization_units org,
120: ben_popl_org_f pop
121: where org.organization_id = p_organization_id
122: and pop.organization_id = org.organization_id
123: and pop.pl_id = p_pl_id

Line 134: from hr_all_organization_units org,

130: and org.business_group_id = p_business_group_id;
131: --
132: cursor c2 is
133: select null
134: from hr_all_organization_units org,
135: ben_popl_org_f pop,
136: ben_oipl_f cop
137: where org.organization_id = p_organization_id
138: and pop.organization_id = org.organization_id

Line 166: -- check if organization_id value exists in hr_all_organization_units

162: and nvl(p_organization_id,hr_api.g_number)
163: <> nvl(ben_apr_shd.g_old_rec.organization_id,hr_api.g_number)
164: or not l_api_updating) and p_organization_id is not null then
165: --
166: -- check if organization_id value exists in hr_all_organization_units
167: -- table
168: --
169: if p_pl_id is not null then
170: --

Line 179: -- hr_all_organization_units table.

175: --
176: close c1;
177: --
178: -- raise error as FK does not relate to PK in
179: -- hr_all_organization_units table.
180: --
181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');
182: fnd_message.set_token('PL_ID',to_char(p_pl_id));
183: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 201: -- hr_all_organization_units table.

197: --
198: close c2;
199: --
200: -- raise error as FK does not relate to PK in
201: -- hr_all_organization_units table.
202: --
203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');
204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
205: fnd_message.set_token('BG_ID',to_char(p_business_group_id));