22: --
23: FUNCTION get_job_details(p_person_id NUMBER
24: ,p_period_of_service_id NUMBER) RETURN VARCHAR2 IS
25: --
26: l_job_name1 per_jobs_tl.name%TYPE;
27: l_job_name2 per_jobs_tl.name%TYPE;
28: l_job_name3 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
23: FUNCTION get_job_details(p_person_id NUMBER
24: ,p_period_of_service_id NUMBER) RETURN VARCHAR2 IS
25: --
26: l_job_name1 per_jobs_tl.name%TYPE;
27: l_job_name2 per_jobs_tl.name%TYPE;
28: l_job_name3 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
24: ,p_period_of_service_id NUMBER) RETURN VARCHAR2 IS
25: --
26: l_job_name1 per_jobs_tl.name%TYPE;
27: l_job_name2 per_jobs_tl.name%TYPE;
28: l_job_name3 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
25: --
26: l_job_name1 per_jobs_tl.name%TYPE;
27: l_job_name2 per_jobs_tl.name%TYPE;
28: l_job_name3 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
26: l_job_name1 per_jobs_tl.name%TYPE;
27: l_job_name2 per_jobs_tl.name%TYPE;
28: l_job_name3 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
34: l_job_name8 per_jobs_tl.name%TYPE;
28: l_job_name3 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
34: l_job_name8 per_jobs_tl.name%TYPE;
35: l_job_name9 per_jobs_tl.name%TYPE;
36: l_job_name10 per_jobs_tl.name%TYPE;
29: l_job_name4 per_jobs_tl.name%TYPE;
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
34: l_job_name8 per_jobs_tl.name%TYPE;
35: l_job_name9 per_jobs_tl.name%TYPE;
36: l_job_name10 per_jobs_tl.name%TYPE;
37: --
30: l_job_name5 per_jobs_tl.name%TYPE;
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
34: l_job_name8 per_jobs_tl.name%TYPE;
35: l_job_name9 per_jobs_tl.name%TYPE;
36: l_job_name10 per_jobs_tl.name%TYPE;
37: --
38: l_job_start_date1 VARCHAR2(11);
31: --
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
34: l_job_name8 per_jobs_tl.name%TYPE;
35: l_job_name9 per_jobs_tl.name%TYPE;
36: l_job_name10 per_jobs_tl.name%TYPE;
37: --
38: l_job_start_date1 VARCHAR2(11);
39: l_job_start_date2 VARCHAR2(11);
32: l_job_name6 per_jobs_tl.name%TYPE;
33: l_job_name7 per_jobs_tl.name%TYPE;
34: l_job_name8 per_jobs_tl.name%TYPE;
35: l_job_name9 per_jobs_tl.name%TYPE;
36: l_job_name10 per_jobs_tl.name%TYPE;
37: --
38: l_job_start_date1 VARCHAR2(11);
39: l_job_start_date2 VARCHAR2(11);
40: l_job_start_date3 VARCHAR2(11);