APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 155: per_all_assignments_f ass

151: g_eol varchar2(1) := fnd_global.local_chr(10);
152: cursor c_location is
153: select 'Y'
154: from
155: per_all_assignments_f ass
156: where
157: ass.person_id = person_id1
158: and report_date_end between ass.effective_start_date
159: and ass.effective_end_date

Line 172: per_all_assignments_f ass

168: ;
169: cursor c_assignment is
170: select 'Y'
171: from
172: per_all_assignments_f ass
173: where
174: ass.person_id = person_id1
175: and ass.business_group_id = P_BUSINESS_GROUP_ID
176: and report_date_end between ass.effective_start_date and ass.effective_end_date

Line 208: per_all_assignments_f ass

204: ;
205: cursor c_emp_category is
206: select 'Y'
207: from
208: per_all_assignments_f ass
209: where
210: ass.person_id = person_id1
211: and ass.business_group_id = P_BUSINESS_GROUP_ID
212: and report_date_end between ass.effective_start_date

Line 226: per_all_assignments_f ass

222: and hoi2.organization_id = P_BUSINESS_GROUP_ID);
223: cursor c_job_category is
224: select 'Y'
225: from
226: per_all_assignments_f ass
227: ,per_jobs job
228: where
229: ass.person_id = person_id1
230: and ass.business_group_id = P_BUSINESS_GROUP_ID

Line 261: ,per_all_assignments_f ass

257: ;
258: cursor c_job_cat is
259: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
260: from hr_lookups lup
261: ,per_all_assignments_f ass
262: ,per_jobs_vl job
263: ,per_jobs_tl jbt
264: where ass.person_id = person_id1
265:

Line 296: ,per_all_assignments_f ass

292: ;
293: cursor c_emp_cat is
294: select nvl(lup.meaning, 'Not Specified') emp_cat
295: from hr_lookups lup
296: ,per_all_assignments_f ass
297: where ass.person_id = person_id1
298: and ass.business_group_id = P_BUSINESS_GROUP_ID
299: and ass.employment_category = lup.lookup_code(+)
300: and lup.lookup_type(+) = 'EMP_CAT'

Line 308: from per_all_assignments_f ass

304: and ass.assignment_type = 'E'
305: and ass.primary_flag = 'Y';
306: cursor c_ass_type is
307: select past.user_status ustat
308: from per_all_assignments_f ass
309: ,per_assignment_status_types past
310: where ass.person_id = person_id1
311: and ass.business_group_id = P_BUSINESS_GROUP_ID
312:

Line 324: per_all_assignments_f ass

320: ;
321: cursor c_eeo1_extra_info is
322: select 'Y'
323: from
324: per_all_assignments_f ass
325: ,hr_location_extra_info hlei1
326: ,hr_location_extra_info hlei2
327: where
328: ass.person_id = person_id1