APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 160: per_all_assignments_f ass

156:
157: cursor c_location is
158: select 'Y'
159: from
160: per_all_assignments_f ass
161: where
162: ass.person_id = person_id1
163: and report_date_end between ass.effective_start_date
164: and ass.effective_end_date

Line 178: per_all_assignments_f ass

174:
175: cursor c_assignment is
176: select 'Y'
177: from
178: per_all_assignments_f ass
179: where
180: ass.person_id = person_id1
181: and ass.business_group_id = P_BUSINESS_GROUP_ID
182: and report_date_end between ass.effective_start_date and ass.effective_end_date

Line 218: per_all_assignments_f ass

214:
215: cursor c_emp_category is
216: select 'Y'
217: from
218: per_all_assignments_f ass
219: where
220: ass.person_id = person_id1
221: and ass.business_group_id = P_BUSINESS_GROUP_ID
222: and report_date_end between ass.effective_start_date

Line 237: per_all_assignments_f ass

233:
234: cursor c_job_category is
235: select 'Y'
236: from
237: per_all_assignments_f ass
238: ,per_jobs job
239: where
240: ass.person_id = person_id1
241: and ass.business_group_id = P_BUSINESS_GROUP_ID

Line 273: ,per_all_assignments_f ass

269:
270: cursor c_job_cat is
271: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
272: from hr_lookups lup
273: ,per_all_assignments_f ass
274: ,per_jobs_vl job
275: ,per_jobs_tl jbt
276: where ass.person_id = person_id1
277:

Line 312: ,per_all_assignments_f ass

308:
309: cursor c_emp_cat is
310: select nvl(lup.meaning, 'Not Specified') emp_cat
311: from hr_lookups lup
312: ,per_all_assignments_f ass
313: where ass.person_id = person_id1
314: and ass.business_group_id = P_BUSINESS_GROUP_ID
315: and ass.employment_category = lup.lookup_code(+)
316: and lup.lookup_type(+) = 'EMP_CAT'

Line 325: from per_all_assignments_f ass

321: and ass.primary_flag = 'Y';
322:
323: cursor c_ass_type is
324: select past.user_status ustat
325: from per_all_assignments_f ass
326: ,per_assignment_status_types past
327: where ass.person_id = person_id1
328: and ass.business_group_id = P_BUSINESS_GROUP_ID
329:

Line 342: per_all_assignments_f ass

338:
339: cursor c_eeo1_extra_info is
340: select 'Y'
341: from
342: per_all_assignments_f ass
343: ,hr_location_extra_info hlei1
344: ,hr_location_extra_info hlei2
345: where
346: ass.person_id = person_id1