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_ALL_ASSIGNMENTS_F

Line 28: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s

24: OR P_START_DATE BETWEEN ppj.start_date and ppj.end_date
25: OR P_END_DATE BETWEEN ppj.start_date and ppj.end_date);
26:
27: CURSOR c_current_employer IS
28: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
29: where a.business_group_id=p_business_group_id
30: and a.person_id=p_person_id
31: and a.assignment_status_type_id <> '3'
32: and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)

Line 103: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s

99: OR P_START_DATE BETWEEN ppj.start_date and ppj.end_date
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)

Line 174: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s

170: OR p_start_date between ppe.START_DATE and ppe.END_DATE
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)

Line 240: select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s

236: OR P_START_DATE BETWEEN ppe.start_date and ppe.end_date
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(+)