APPS.BEN_CBS_BUS dependencies on HR_LOOKUPS

Line 215: if hr_api.not_exists_in_hr_lookups

211: --
212: -- check if value of lookup falls within lookup type.
213: --
214: --
215: if hr_api.not_exists_in_hr_lookups
216: (p_lookup_type => 'BEN_SGMT_CSTG_MTHD',
217: p_lookup_code => p_sgmt_cstg_mthd_cd,
218: p_effective_date => p_effective_date) then
219: --

Line 370: l_prem_asnmt_lvl_cd hr_lookups.lookup_code%TYPE; -- UTF8varchar2(30);

366: p_business_group_id in number) is
367: --
368: l_proc varchar2(72) := g_package||'chk_sgmt_cstg_asnmt_lvl' ;
369: l_api_updating boolean;
370: l_prem_asnmt_lvl_cd hr_lookups.lookup_code%TYPE; -- UTF8varchar2(30);
371: --
372: cursor c1 is
373: select prem_asnmt_lvl_cd from ben_actl_prem_f a
374: where a.business_group_id +0 = p_business_group_id

Line 443: l_prem_asnmt_cd hr_lookups.lookup_code%TYPE; -- UTF8 varchar2(30);

439: -- bug 5376303
440: p_effective_date in date ) is
441:
442: l_proc varchar2(72) := g_package||'chk_parent_data' ;
443: l_prem_asnmt_cd hr_lookups.lookup_code%TYPE; -- UTF8 varchar2(30);
444: l_cost_alloc_cd number(15);
445: --
446: cursor c1 is
447: select a.prem_asnmt_cd,a.cost_allocation_keyflex_id from ben_actl_prem_f a