APPS.PAY_CN_EXT dependencies on PER_JOB_EXTRA_INFO

Line 2334: ,per_job_extra_info pjei

2330: IS
2331: --
2332: SELECT hr_general.decode_lookup('JOB_CATEGORIES', pjei.jei_information1)
2333: FROM per_all_assignments_f paa
2334: ,per_job_extra_info pjei
2335: WHERE paa.assignment_id = p_assignment_id
2336: AND pjei.job_id = paa.job_id
2337: AND information_type = 'Job Category'
2338: AND jei_information_category = 'Job Category'