APPS.POR_LOAD_EMPLOYEE_ASSIGNMENT dependencies on PER_JOBS

Line 225: SELECT job_id INTO l_job_id FROM per_jobs job

221: FUNCTION get_job_id (p_job_name IN VARCHAR2, p_business_group_id IN NUMBER) RETURN NUMBER IS
222: l_job_id NUMBER;
223: BEGIN
224:
225: SELECT job_id INTO l_job_id FROM per_jobs job
226: WHERE job.name = p_job_name
227: AND job.business_group_id = p_business_group_id;
228:
229: RETURN l_job_id;