APPS.BEN_WLR_BUS dependencies on HR_LOCATIONS

Line 160: -- loaction_id FK pointing to HR_LOCATIONS table.

156: -- Pre Conditions
157: -- None.
158: --
159: -- In Parameters
160: -- loaction_id FK pointing to HR_LOCATIONS table.
161: -- effective_date or current transaction
162: --
163: -- Post Success
164: -- Processing continues

Line 178: from hr_locations

174: --
175: l_proc varchar2(72) := g_package||'chk_location_id';
176: l_dummy varchar2(1);
177: cursor c1 is select null
178: from hr_locations
179: where location_id = p_location_id
180: and p_effective_date <= nvl(inactive_date, p_effective_date);
181: --
182: Begin