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.PA_JOB_UTILS dependencies on PER_JOB_EXTRA_INFO

Line 504: l_job_level per_job_extra_info.jei_information4%type;

500:
501: FUNCTION get_job_level(p_job_id IN NUMBER)
502: RETURN NUMBER
503: IS
504: l_job_level per_job_extra_info.jei_information4%type;
505: BEGIN
506:
507: SELECT jei_information4
508: INTO l_job_level

Line 509: FROM per_job_extra_info

505: BEGIN
506:
507: SELECT jei_information4
508: INTO l_job_level
509: FROM per_job_extra_info
510: WHERE job_id = p_job_id
511: AND information_type = 'Job Category'
512: AND jei_information4 IS NOT NULL; -- Bug 2898766
513:

Line 545: l_job_level per_job_extra_info.jei_information4%type;

541: (P_job_id IN per_jobs.job_id%type,
542: P_job_group_id IN per_job_groups.job_group_id%type)
543: RETURN NUMBER
544: IS
545: l_job_level per_job_extra_info.jei_information4%type;
546: l_job_info_type VARCHAR2(20) := 'Job Category';
547: l_master_job_id pa_job_relationships.to_job_id%type;
548: l_job_id per_jobs.job_id%type;
549: l_job_mapping NUMBER;