DBA Data[Home] [Help]

APPS.PER_FR_WORK_CERT dependencies on PER_JOBS_TL

Line 26: l_job_name1 per_jobs_tl.name%TYPE;

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;

Line 27: l_job_name2 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: --

Line 28: l_job_name3 per_jobs_tl.name%TYPE;

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;

Line 29: l_job_name4 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;

Line 30: l_job_name5 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;

Line 32: l_job_name6 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;

Line 33: l_job_name7 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: --

Line 34: l_job_name8 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: --
38: l_job_start_date1 VARCHAR2(11);

Line 35: l_job_name9 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);
39: l_job_start_date2 VARCHAR2(11);

Line 36: l_job_name10 per_jobs_tl.name%TYPE;

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);