DBA Data[Home] [Help]

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