APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 309: ,per_assignment_status_types past

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:
313: and report_date_end between ass.effective_start_date