DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

Line 1468: , per_ass_status_type_amends_tl btl

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
1471: and b.business_group_id(+) + 0 = p_business_group_id
1472: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id