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_RU_PREVIOUS_EMPLOYER dependencies on PER_PREVIOUS_EMPLOYERS

Line 9: select 'x' from PER_PREVIOUS_EMPLOYERS

5: ,P_START_DATE DATE
6: ,P_END_DATE DATE
7: ,P_PEM_INFORMATION_CATEGORY VARCHAR2) is
8: CURSOR c_prev_employer_list is
9: select 'x' from PER_PREVIOUS_EMPLOYERS
10: WHERE business_group_id = p_business_group_id
11: AND person_id = p_person_id
12: AND (start_date BETWEEN P_START_DATE AND P_END_DATE
13: OR end_date BETWEEN P_START_DATE AND P_END_DATE

Line 18: select 'x' from per_previous_jobs ppj, per_previous_employers ppe

14: OR P_START_DATE BETWEEN start_date and end_date
15: OR P_END_DATE BETWEEN start_date and end_date);
16:
17: CURSOR c_prev_job_list is
18: select 'x' from per_previous_jobs ppj, per_previous_employers ppe
19: where ppe.business_group_id=p_business_group_id
20: AND ppe.person_id=p_person_id
21: AND ppe.PREVIOUS_EMPLOYER_ID=ppj.PREVIOUS_EMPLOYER_ID
22: AND (ppj.START_DATE between p_start_date and p_end_date

Line 85: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS WHERE

81: ,P_START_DATE DATE
82: ,P_END_DATE DATE
83: ,P_PEM_INFORMATION_CATEGORY VARCHAR2) is
84: CURSOR c_prev_employer_details is
85: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS WHERE
86: (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
87: AND previous_employer_id <> P_PREVIOUS_EMPLOYER_ID
88: AND (start_date BETWEEN P_START_DATE AND P_END_DATE
89: OR end_date BETWEEN P_START_DATE AND P_END_DATE

Line 86: (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)

82: ,P_END_DATE DATE
83: ,P_PEM_INFORMATION_CATEGORY VARCHAR2) is
84: CURSOR c_prev_employer_details is
85: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS WHERE
86: (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
87: AND previous_employer_id <> P_PREVIOUS_EMPLOYER_ID
88: AND (start_date BETWEEN P_START_DATE AND P_END_DATE
89: OR end_date BETWEEN P_START_DATE AND P_END_DATE
90: OR P_START_DATE BETWEEN start_date and end_date

Line 94: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE

90: OR P_START_DATE BETWEEN start_date and end_date
91: OR P_END_DATE BETWEEN start_date and end_date);
92:
93: CURSOR c_prev_job_details is
94: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE
95: (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
96: AND ppe.previous_employer_id=ppj.previous_employer_id
97: AND (ppj.start_date BETWEEN P_START_DATE AND P_END_DATE
98: OR ppj.end_date BETWEEN P_START_DATE AND P_END_DATE

Line 95: (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)

91: OR P_END_DATE BETWEEN start_date and end_date);
92:
93: CURSOR c_prev_job_details is
94: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE
95: (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
96: AND ppe.previous_employer_id=ppj.previous_employer_id
97: AND (ppj.start_date BETWEEN P_START_DATE AND P_END_DATE
98: OR ppj.end_date BETWEEN P_START_DATE AND P_END_DATE
99: OR P_START_DATE BETWEEN ppj.start_date and ppj.end_date

Line 104: where (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)

100: OR P_END_DATE BETWEEN ppj.start_date and ppj.end_date);
101:
102: CURSOR c_current_employer IS
103: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
104: where (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
105: and assignment_status_type_id <> '3'
106: and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
107: and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)
108: and (effective_start_date between p_start_date and p_end_date

Line 160: select 'x' from per_previous_jobs ppj, per_previous_employers ppe

156: ,P_END_DATE DATE) is
157:
158:
159: CURSOR c_get_job is
160: select 'x' from per_previous_jobs ppj, per_previous_employers ppe
161: where (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
162: AND ppe.previous_employer_id = ppj.previous_employer_id (+)
163:
164: AND (ppj.START_DATE between p_start_date and p_end_date

Line 161: where (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)

157:
158:
159: CURSOR c_get_job is
160: select 'x' from per_previous_jobs ppj, per_previous_employers ppe
161: where (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
162: AND ppe.previous_employer_id = ppj.previous_employer_id (+)
163:
164: AND (ppj.START_DATE between p_start_date and p_end_date
165: OR ppj.end_date between p_start_date and p_end_date

Line 175: where (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)

171: OR p_end_date between ppe.START_DATE and ppe.END_DATE );
172:
173: CURSOR c_current_employer IS
174: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
175: where (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
176: and assignment_status_type_id <> '3'
177: and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
178: and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)
179: and (effective_start_date between p_start_date and p_end_date

Line 225: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE

221: ,P_START_DATE DATE
222: ,P_END_DATE DATE) is
223:
224: CURSOR c_job_details is
225: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE
226: (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj
227: WHERE ppj.previous_job_id=p_previous_job_id and ppj.previous_employer_id = pee.previous_employer_id)
228: AND ppe.previous_employer_id = ppj.previous_employer_id (+)
229: AND ppj.previous_job_id <> p_previous_job_id

Line 226: (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj

222: ,P_END_DATE DATE) is
223:
224: CURSOR c_job_details is
225: SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE
226: (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj
227: WHERE ppj.previous_job_id=p_previous_job_id and ppj.previous_employer_id = pee.previous_employer_id)
228: AND ppe.previous_employer_id = ppj.previous_employer_id (+)
229: AND ppj.previous_job_id <> p_previous_job_id
230: AND (ppj.start_date BETWEEN P_START_DATE AND P_END_DATE

Line 241: where (person_id, business_group_id) = (SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj

237: OR P_END_DATE BETWEEN ppe.start_date and ppe.end_date);
238:
239: CURSOR c_current_employer IS
240: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
241: where (person_id, business_group_id) = (SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj
242: WHERE ppj.previous_job_id=p_previous_job_id and ppj.previous_employer_id = pee.previous_employer_id)
243: and assignment_status_type_id <> '3'
244: and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
245: and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)