DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 238: per_assignment_status_types_tl stl,

234: nvl(a.per_system_status ,s.per_system_status)
235: FROM
236: per_ass_status_type_amends_tl atl,
237: per_ass_status_type_amends a,
238: per_assignment_status_types_tl stl,
239: per_assignment_status_types s
240: WHERE
241: s.assignment_status_type_id= p_assignment_status_type_id and
242: a.assignment_status_type_id (+) = s.assignment_status_type_id and

Line 239: per_assignment_status_types s

235: FROM
236: per_ass_status_type_amends_tl atl,
237: per_ass_status_type_amends a,
238: per_assignment_status_types_tl stl,
239: per_assignment_status_types s
240: WHERE
241: s.assignment_status_type_id= p_assignment_status_type_id and
242: a.assignment_status_type_id (+) = s.assignment_status_type_id and
243: a.business_group_id (+) +0= p_business_group_id and