eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRBISOFO dependencies on PER_JOBS

Line 32: v_job_id per_jobs.job_id%TYPE; -- job ID

28: --
29: FUNCTION primary_sales_job
30: (p_person_id in NUMBER) return NUMBER is
31:
32: v_job_id per_jobs.job_id%TYPE; -- job ID
33:
34: cursor c_job is
35: select job.job_id
36: from per_people_x peo

Line 37: , per_jobs job

33:
34: cursor c_job is
35: select job.job_id
36: from per_people_x peo
37: , per_jobs job
38: , per_assignments_x asg
39: , per_job_extra_info inf
40: , hr_lookups lkp
41: where lkp.lookup_type = 'JOB_CATEGORIES'