DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

Line 258: per_ass_status_type_amends_tl btl,

254: select nvl(btl.user_status,atl.user_status),
255: a.assignment_status_type_id
256: from per_assignment_status_types_tl atl,
257: per_assignment_status_types a,
258: per_ass_status_type_amends_tl btl,
259: per_ass_status_type_amends b
260: where atl.assignment_status_type_id = a.assignment_status_type_id
261: and atl.language = userenv('LANG')
262: and btl.ass_status_type_amend_id (+) = b.ass_status_type_amend_id