DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 265: per_ass_status_type_amends_tl atl,

261: SELECT
262: nvl(atl.user_status ,stl.user_status),
263: nvl(a.per_system_status ,s.per_system_status)
264: FROM
265: per_ass_status_type_amends_tl atl,
266: per_ass_status_type_amends a,
267: per_assignment_status_types_tl stl,
268: per_assignment_status_types s
269: WHERE

Line 266: per_ass_status_type_amends a,

262: nvl(atl.user_status ,stl.user_status),
263: nvl(a.per_system_status ,s.per_system_status)
264: FROM
265: per_ass_status_type_amends_tl atl,
266: per_ass_status_type_amends a,
267: per_assignment_status_types_tl stl,
268: per_assignment_status_types s
269: WHERE
270: s.assignment_status_type_id= p_assignment_status_type_id and