DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

Line 254: per_ass_status_type_amends_tl btl,

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