APPS.BEN_XCV_BUS dependencies on HR_LOOKUPS

Line 12: -- |----------------------< not_exists_in_hr_lookups >------------------------|

8: g_package varchar2(33) := ' ben_xcv_bus.'; -- Global package name
9:
10:
11: -- ----------------------------------------------------------------------------
12: -- |----------------------< not_exists_in_hr_lookups >------------------------|
13: -- ----------------------------------------------------------------------------
14: --
15: function not_exists_in_hr_lookups
16: (p_effective_date in date

Line 15: function not_exists_in_hr_lookups

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

Line 29: from hr_lookups

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

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

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

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

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

Line 61: end not_exists_in_hr_lookups;

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

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

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

Line 626: if hr_api.not_exists_in_hr_lookups

622: -- check if value of lookup falls within lookup type.
623: --
624: if p_business_group_id is not null then
625: /* BG is set, so use the existing call, with no modifications*/
626: if hr_api.not_exists_in_hr_lookups
627: (p_lookup_type => 'US_STATE',
628: p_lookup_code => p_val_1,
629: p_effective_date => p_effective_date) then
630: --

Line 713: if hr_api.not_exists_in_hr_lookups

709: -- check if value of lookup falls within lookup type.
710: --
711: if p_business_group_id is not null then
712: /* BG is set, so use the existing call, with no modifications*/
713: if hr_api.not_exists_in_hr_lookups
714: (p_lookup_type => 'BEN_EXT_CHG_TYP',
715: p_lookup_code => p_val_1,
716: p_effective_date => p_effective_date) then
717: --

Line 763: if hr_api.not_exists_in_hr_lookups

759: --
760: if p_val_2 is null or p_val_2 = 'BEN' then
761: if p_business_group_id is not null then
762: /* BG is set, so use the existing call, with no modifications*/
763: if hr_api.not_exists_in_hr_lookups
764: (p_lookup_type => 'BEN_EXT_CHG_EVT',
765: p_lookup_code => p_val_1,
766: p_effective_date => p_effective_date) then
767: --