APPS.GHR_PAY_CAPS dependencies on PER_JOBS

Line 65: l_job_name per_jobs.name%TYPE;

61: FUNCTION get_job_from_pos(p_effective_date IN DATE
62: ,p_position_id IN NUMBER)
63: RETURN VARCHAR2 IS
64: l_job_id hr_all_positions_f.job_id%TYPE;
65: l_job_name per_jobs.name%TYPE;
66: CURSOR cur_pos IS
67: SELECT job_id
68: FROM hr_all_positions_f pos
69: WHERE pos.position_id = p_position_id

Line 73: FROM per_jobs

69: WHERE pos.position_id = p_position_id
70: AND p_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
71: CURSOR cur_job IS
72: SELECT name
73: FROM per_jobs
74: WHERE job_id = l_job_id;
75:
76: BEGIN
77: FOR cur_pos_rec IN cur_pos