DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

Line 1344: , per_ass_status_type_amends_tl btl

1340: , nvl(btl.user_status,atl.user_status)
1341: , a.per_system_status
1342: from per_assignment_status_types_tl atl
1343: , per_assignment_status_types a
1344: , per_ass_status_type_amends_tl btl
1345: , per_ass_status_type_amends b
1346: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1347: and b.business_group_id(+) + 0 = p_business_group_id
1348: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id