DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 236: per_ass_status_type_amends_tl atl,

232: SELECT
233: nvl(atl.user_status ,stl.user_status),
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

Line 237: per_ass_status_type_amends a,

233: nvl(atl.user_status ,stl.user_status),
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