APPS.HR_PROCESS_PERSON_SS dependencies on HR_LOOKUPS

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

203: --
204: -- ------------------------------------------------------------------------
205: -- -------------------------------------------------
206: -- ------------------------------------------------------------------------
207: -- Purpose: This procedure retrieves the lookup meaning from hr_lookups for the
208: -- lookup_type and lookup_code passed in.
209: -- ------------------------------------------------------------------------
210: Function get_hr_lookup_meaning(p_lookup_type in varchar2
211: ,p_lookup_code in varchar2)

Line 216: FROM hr_lookups

212: return varchar2 is
213: --
214: CURSOR csr_hr_lookup is
215: SELECT meaning
216: FROM hr_lookups
217: WHERE lookup_type = upper(p_lookup_type)
218: AND lookup_code = upper(p_lookup_code);
219: --
220: l_meaning varchar2(80) default null;

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

774:
775: l_title per_all_people_f.title%type default null;
776: l_marital_status per_all_people_f.marital_status%type
777: default null;
778: l_title_meaning hr_lookups.meaning%type default null;
779: l_marital_status_meaning hr_lookups.meaning%type default null;
780: l_proc varchar2(72) := g_package||'get_person_data_from_tt';
781:
782: BEGIN

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

775: l_title per_all_people_f.title%type default null;
776: l_marital_status per_all_people_f.marital_status%type
777: default null;
778: l_title_meaning hr_lookups.meaning%type default null;
779: l_marital_status_meaning hr_lookups.meaning%type default null;
780: l_proc varchar2(72) := g_package||'get_person_data_from_tt';
781:
782: BEGIN
783: --

Line 1516: , hr_lookups hrl

1512: , doc.file_name
1513: , doc.description
1514: , hrl.meaning
1515: FROM irc_documents doc
1516: , hr_lookups hrl
1517: WHERE hrl.lookup_type = 'IRC_DOCUMENT_TYPE'
1518: AND doc.type = hrl.lookup_code
1519: AND doc.end_date IS NULL
1520: AND person_id = irc_utilities_pkg.get_recruitment_person_id (x_person_id, sysdate);