DBA Data[Home] [Help]

APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_JOBS

Line 238: ,per_jobs job

234: cursor c_job_category is
235: select 'Y'
236: from
237: per_all_assignments_f ass
238: ,per_jobs job
239: where
240: ass.person_id = person_id1
241: and ass.business_group_id = P_BUSINESS_GROUP_ID
242: and job.business_group_id = P_BUSINESS_GROUP_ID

Line 274: ,per_jobs_vl job

270: cursor c_job_cat is
271: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
272: from hr_lookups lup
273: ,per_all_assignments_f ass
274: ,per_jobs_vl job
275: ,per_jobs_tl jbt
276: where ass.person_id = person_id1
277:
278: and report_date_end between ass.effective_start_date

Line 275: ,per_jobs_tl jbt

271: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
272: from hr_lookups lup
273: ,per_all_assignments_f ass
274: ,per_jobs_vl job
275: ,per_jobs_tl jbt
276: where ass.person_id = person_id1
277:
278: and report_date_end between ass.effective_start_date
279: and ass.effective_end_date