APPS.PER_PERUSEOX_XMLP_PKG dependencies on HR_LOOKUPS

Line 193: from hr_lookups

189: (
190: (peo.per_information1 is not null
191: and exists
192: (select null
193: from hr_lookups
194: where peo.per_information1 = lookup_code
195: and lookup_type = 'US_ETHNIC_GROUP'
196: )
197: )

Line 244: from hr_lookups

240: and report_date_end between job.date_from
241: and nvl(job.date_to, report_date_end)
242: and job.job_information1 in
243: (select lookup_code
244: from hr_lookups
245: where lookup_type = 'US_EEO1_JOB_CATEGORIES')
246: ;
247: cursor c_person_name is
248: select substr(peo.full_name,1,150) emp_name,

Line 260: from hr_lookups lup

256:
257: ;
258: cursor c_job_cat is
259: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
260: from hr_lookups lup
261: ,per_all_assignments_f ass
262: ,per_jobs_vl job
263: ,per_jobs_tl jbt
264: where ass.person_id = person_id1

Line 282: from hr_lookups lup

278: and lup.lookup_type(+) = 'US_EEO1_JOB_CATEGORIES'
279: and job.job_information_category(+) = 'US' ;
280: cursor c_eth_cat is
281: select nvl(lup.meaning, 'Not Specified') ethnic
282: from hr_lookups lup
283: ,per_all_people_f peo
284: where peo.person_id = person_id1
285: and peo.business_group_id = P_BUSINESS_GROUP_ID
286: and peo.per_information_category(+) = 'US'

Line 295: from hr_lookups lup

291:
292: ;
293: cursor c_emp_cat is
294: select nvl(lup.meaning, 'Not Specified') emp_cat
295: from hr_lookups lup
296: ,per_all_assignments_f ass
297: where ass.person_id = person_id1
298: and ass.business_group_id = P_BUSINESS_GROUP_ID
299: and ass.employment_category = lup.lookup_code(+)