APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 326: ,per_assignment_status_types past
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:
330: and report_date_end between ass.effective_start_date