DBA Data[Home] [Help]

APPS.BEN_OLA_BUS dependencies on HR_LOOKUPS

Line 104: from hr_lookups

100: -- created for the Person form - PERWSHRG.
101:
102: cursor c2 is
103: select null
104: from hr_lookups
105: where lookup_code = p_function_name
106: and lookup_type = 'BEN_ON_LINE_ACT'
107: and enabled_flag = 'Y'
108: and TRUNC(sysdate) between

Line 159: if hr_api.not_exists_in_hr_lookups

155:
156:
157: -- Bug 2382144 start
158: /*
159: if hr_api.not_exists_in_hr_lookups
160: (p_lookup_type => 'BEN_ON_LINE_ACT',
161: p_lookup_code => p_function_name,
162: p_effective_date => sysdate) then
163: --

Line 237: if hr_api.not_exists_in_hr_lookups

233: and p_function_type is not null then
234: --
235: -- check if value of lookup falls within lookup type.
236: --
237: if hr_api.not_exists_in_hr_lookups
238: (p_lookup_type => 'BEN_FUNCTION_TYPE',
239: p_lookup_code => p_function_type,
240: p_effective_date => sysdate) then
241: --