DBA Data[Home] [Help]

APPS.PER_ABV_BUS dependencies on HR_LOOKUPS

Line 220: -- This procedure is used to ensure that the budget unit exists in hr_lookups

216: -- ----------------------------------------------------------------------------
217: -- {Start Of Comments}
218: --
219: -- Description:
220: -- This procedure is used to ensure that the budget unit exists in hr_lookups
221: --
222: procedure chk_unit(p_unit in varchar2
223: ,p_effective_date in date)
224: is

Line 227: from hr_lookups

223: ,p_effective_date in date)
224: is
225: cursor c is
226: select 'x'
227: from hr_lookups
228: where p_unit = lookup_code
229: and lookup_type='BUDGET_MEASUREMENT_TYPE'
230: and enabled_flag = 'Y'
231: and p_effective_date between nvl(start_date_active,hr_api.g_sot) and nvl(start_date_active,hr_api.g_eot);