APPS.HR_PROCESS_PERSON_SS dependencies on HR_LOOKUPS

Line 201: -- Purpose: This procedure retrieves the lookup meaning from hr_lookups for the

197: --
198: -- ------------------------------------------------------------------------
199: -- -------------------------------------------------
200: -- ------------------------------------------------------------------------
201: -- Purpose: This procedure retrieves the lookup meaning from hr_lookups for the
202: -- lookup_type and lookup_code passed in.
203: -- ------------------------------------------------------------------------
204: Function get_hr_lookup_meaning(p_lookup_type in varchar2
205: ,p_lookup_code in varchar2)

Line 210: FROM hr_lookups

206: return varchar2 is
207: --
208: CURSOR csr_hr_lookup is
209: SELECT meaning
210: FROM hr_lookups
211: WHERE lookup_type = upper(p_lookup_type)
212: AND lookup_code = upper(p_lookup_code);
213: --
214: l_meaning varchar2(80) default null;

Line 772: l_title_meaning hr_lookups.meaning%type default null;

768:
769: l_title per_all_people_f.title%type default null;
770: l_marital_status per_all_people_f.marital_status%type
771: default null;
772: l_title_meaning hr_lookups.meaning%type default null;
773: l_marital_status_meaning hr_lookups.meaning%type default null;
774: l_proc varchar2(72) := g_package||'get_person_data_from_tt';
775:
776: BEGIN

Line 773: l_marital_status_meaning hr_lookups.meaning%type default null;

769: l_title per_all_people_f.title%type default null;
770: l_marital_status per_all_people_f.marital_status%type
771: default null;
772: l_title_meaning hr_lookups.meaning%type default null;
773: l_marital_status_meaning hr_lookups.meaning%type default null;
774: l_proc varchar2(72) := g_package||'get_person_data_from_tt';
775:
776: BEGIN
777: --