DBA Data[Home] [Help]

APPS.BEN_XCC_BUS dependencies on HR_LOOKUPS

Line 312: if hr_api.not_exists_in_hr_lookups

308: -- check if value of lookup falls within lookup type.
309: --
310: if p_business_group_id is not null then
311: /* BG is set, so use the existing call, with no modifications*/
312: if hr_api.not_exists_in_hr_lookups
313: (p_lookup_type => 'BEN_EXT_TTL_COND_OPER',
314: p_lookup_code => p_oper_cd,
315: p_effective_date => p_effective_date) then
316: --

Line 404: if hr_api.not_exists_in_hr_lookups

400: --
401: -- check if value of lookup falls within lookup type.
402: --
403: --
404: if hr_api.not_exists_in_hr_lookups
405: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
406: p_lookup_code => p_crit_typ_cd,
407: p_effective_date => p_effective_date) then
408: --

Line 557: hr_lookups where

553: --
554:
555: cursor c1 is
556: select 'x' from
557: hr_lookups where
558: lookup_type = 'BEN_EXT_CHG_EVT'
559: and lookup_code = p_val_1
560: ;
561: