DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 1466: from per_assignment_status_types_tl atl

1462: cursor c2 is
1463: select a.assignment_status_type_id
1464: , nvl(btl.user_status,atl.user_status)
1465: , a.per_system_status
1466: from per_assignment_status_types_tl atl
1467: , per_assignment_status_types a
1468: , per_ass_status_type_amends_tl btl
1469: , per_ass_status_type_amends b
1470: where b.assignment_status_type_id(+) = a.assignment_status_type_id