eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_FR_WORK_CERT dependencies on PER_JOBS

Line 13: FROM per_jobs job,

9: SELECT job.job_id,
10: job.job_definition_id,
11: to_char(asg.effective_start_date, 'DD-MON-YYYY'),
12: to_char(asg.effective_end_date, 'DD-MON-YYYY')
13: FROM per_jobs job,
14: per_all_assignments_f asg
15: WHERE asg.person_id = p_person_id
16: AND asg.job_id = job.job_id
17: AND asg.period_of_service_id = p_period_of_service_id

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

Line 62: l_job_id1 per_jobs.job_id%TYPE;

58: l_job_end_date8 VARCHAR2(11);
59: l_job_end_date9 VARCHAR2(11);
60: l_job_end_date10 VARCHAR2(11);
61: -- 3815632
62: l_job_id1 per_jobs.job_id%TYPE;
63: l_job_id2 per_jobs.job_id%TYPE;
64: l_job_id3 per_jobs.job_id%TYPE;
65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;

Line 63: l_job_id2 per_jobs.job_id%TYPE;

59: l_job_end_date9 VARCHAR2(11);
60: l_job_end_date10 VARCHAR2(11);
61: -- 3815632
62: l_job_id1 per_jobs.job_id%TYPE;
63: l_job_id2 per_jobs.job_id%TYPE;
64: l_job_id3 per_jobs.job_id%TYPE;
65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;
67: --

Line 64: l_job_id3 per_jobs.job_id%TYPE;

60: l_job_end_date10 VARCHAR2(11);
61: -- 3815632
62: l_job_id1 per_jobs.job_id%TYPE;
63: l_job_id2 per_jobs.job_id%TYPE;
64: l_job_id3 per_jobs.job_id%TYPE;
65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;
67: --
68: l_job_id6 per_jobs.job_id%TYPE;

Line 65: l_job_id4 per_jobs.job_id%TYPE;

61: -- 3815632
62: l_job_id1 per_jobs.job_id%TYPE;
63: l_job_id2 per_jobs.job_id%TYPE;
64: l_job_id3 per_jobs.job_id%TYPE;
65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;
67: --
68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;

Line 66: l_job_id5 per_jobs.job_id%TYPE;

62: l_job_id1 per_jobs.job_id%TYPE;
63: l_job_id2 per_jobs.job_id%TYPE;
64: l_job_id3 per_jobs.job_id%TYPE;
65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;
67: --
68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;
70: l_job_id8 per_jobs.job_id%TYPE;

Line 68: l_job_id6 per_jobs.job_id%TYPE;

64: l_job_id3 per_jobs.job_id%TYPE;
65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;
67: --
68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;
70: l_job_id8 per_jobs.job_id%TYPE;
71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;

Line 69: l_job_id7 per_jobs.job_id%TYPE;

65: l_job_id4 per_jobs.job_id%TYPE;
66: l_job_id5 per_jobs.job_id%TYPE;
67: --
68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;
70: l_job_id8 per_jobs.job_id%TYPE;
71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;
73: --

Line 70: l_job_id8 per_jobs.job_id%TYPE;

66: l_job_id5 per_jobs.job_id%TYPE;
67: --
68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;
70: l_job_id8 per_jobs.job_id%TYPE;
71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;
73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;

Line 71: l_job_id9 per_jobs.job_id%TYPE;

67: --
68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;
70: l_job_id8 per_jobs.job_id%TYPE;
71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;
73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;

Line 72: l_job_id10 per_jobs.job_id%TYPE;

68: l_job_id6 per_jobs.job_id%TYPE;
69: l_job_id7 per_jobs.job_id%TYPE;
70: l_job_id8 per_jobs.job_id%TYPE;
71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;
73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;
76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;

Line 74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;

70: l_job_id8 per_jobs.job_id%TYPE;
71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;
73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;
76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;
77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;

Line 75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;

71: l_job_id9 per_jobs.job_id%TYPE;
72: l_job_id10 per_jobs.job_id%TYPE;
73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;
76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;
77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --

Line 76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;

72: l_job_id10 per_jobs.job_id%TYPE;
73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;
76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;
77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;

Line 77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;

73: --
74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;
76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;
77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;

Line 78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;

74: l_job_definition_id1 per_jobs.job_definition_id%TYPE;
75: l_job_definition_id2 per_jobs.job_definition_id%TYPE;
76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;
77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;
82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;

Line 80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;

76: l_job_definition_id3 per_jobs.job_definition_id%TYPE;
77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;
82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;
83: l_job_definition_id9 per_jobs.job_definition_id%TYPE;
84: l_job_definition_id10 per_jobs.job_definition_id%TYPE;

Line 81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;

77: l_job_definition_id4 per_jobs.job_definition_id%TYPE;
78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;
82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;
83: l_job_definition_id9 per_jobs.job_definition_id%TYPE;
84: l_job_definition_id10 per_jobs.job_definition_id%TYPE;
85: -- 3815632

Line 82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;

78: l_job_definition_id5 per_jobs.job_definition_id%TYPE;
79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;
82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;
83: l_job_definition_id9 per_jobs.job_definition_id%TYPE;
84: l_job_definition_id10 per_jobs.job_definition_id%TYPE;
85: -- 3815632
86:

Line 83: l_job_definition_id9 per_jobs.job_definition_id%TYPE;

79: --
80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;
82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;
83: l_job_definition_id9 per_jobs.job_definition_id%TYPE;
84: l_job_definition_id10 per_jobs.job_definition_id%TYPE;
85: -- 3815632
86:
87: l_concat_job_details VARCHAR2(3000);

Line 84: l_job_definition_id10 per_jobs.job_definition_id%TYPE;

80: l_job_definition_id6 per_jobs.job_definition_id%TYPE;
81: l_job_definition_id7 per_jobs.job_definition_id%TYPE;
82: l_job_definition_id8 per_jobs.job_definition_id%TYPE;
83: l_job_definition_id9 per_jobs.job_definition_id%TYPE;
84: l_job_definition_id10 per_jobs.job_definition_id%TYPE;
85: -- 3815632
86:
87: l_concat_job_details VARCHAR2(3000);
88: l_prev_job_end_date DATE;