APPS.BEN_XIC_BUS dependencies on HR_LOOKUPS

Line 14: -- |----------------------< not_exists_in_hr_lookups >------------------------|

10: -- |----------------------< set_security_group_id >--------------------------|
11: -- ---------------------------------------------------------------------------
12: --
13: -- ----------------------------------------------------------------------------
14: -- |----------------------< not_exists_in_hr_lookups >------------------------|
15: -- ----------------------------------------------------------------------------
16: --
17: function not_exists_in_hr_lookups
18: (p_effective_date in date

Line 17: function not_exists_in_hr_lookups

13: -- ----------------------------------------------------------------------------
14: -- |----------------------< not_exists_in_hr_lookups >------------------------|
15: -- ----------------------------------------------------------------------------
16: --
17: function not_exists_in_hr_lookups
18: (p_effective_date in date
19: ,p_lookup_type in varchar2
20: ,p_lookup_code in varchar2
21: ) return boolean is

Line 31: from hr_lookups

27: -- Declare Local cursors
28: --
29: cursor csr_hr_look is
30: select null
31: from hr_lookups
32: where lookup_code = p_lookup_code
33: and lookup_type = p_lookup_type
34: and p_effective_date between
35: nvl(start_date_active, p_effective_date)

Line 49: -- hr_lookups view. Just in case there has been a change to

45: if p_lookup_code = 'Y' or p_lookup_code = 'N' then
46: return false;
47: end if;
48: -- If the value is not known then go onto check against the
49: -- hr_lookups view. Just in case there has been a change to
50: -- the system defined lookup.
51: end if;
52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
53: --

Line 52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

48: -- If the value is not known then go onto check against the
49: -- hr_lookups view. Just in case there has been a change to
50: -- the system defined lookup.
51: end if;
52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
53: --
54: open csr_hr_look;
55: fetch csr_hr_look into l_exists;
56: if csr_hr_look%notfound then

Line 63: end not_exists_in_hr_lookups;

59: else
60: close csr_hr_look;
61: return false;
62: end if;
63: end not_exists_in_hr_lookups;
64: --
65: -- ----------------------------------------------------------------------------
66: -- |---------------------< not_exists_in_hrstanlookups >----------------------|
67: -- ----------------------------------------------------------------------------

Line 101: -- hr_lookups view. Just in case there has been a change to

97: if p_lookup_code = 'Y' or p_lookup_code = 'N' then
98: return false;
99: end if;
100: -- If the value is not known then go onto check against the
101: -- hr_lookups view. Just in case there has been a change to
102: -- the system defined lookup.
103: end if;
104: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
105: --

Line 464: if hr_api.not_exists_in_hr_lookups

460: -- check if value of lookup falls within lookup type.
461: --
462: if p_chg_evt_source is null or p_chg_evt_source = 'BEN' then
463: if p_business_group_id is not null then
464: if hr_api.not_exists_in_hr_lookups
465: (p_lookup_type => 'BEN_EXT_CHG_EVT',
466: p_lookup_code => p_chg_evt_cd,
467: p_effective_date => p_effective_date) then
468: --