DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 6769: per_ass_status_type_amends a ,

6765: --
6766: cursor c_assignment_status_type_name is
6767: select nvl(atl.user_status,stl.user_status) user_status
6768: from per_assignment_status_types s,
6769: per_ass_status_type_amends a ,
6770: per_assignment_status_types_tl stl,
6771: per_ass_status_type_amends_tl atl
6772: where s.assignment_status_type_id = p_assignment_status_type_id
6773: and a.assignment_status_type_id (+) = s.assignment_status_type_id

Line 6771: per_ass_status_type_amends_tl atl

6767: select nvl(atl.user_status,stl.user_status) user_status
6768: from per_assignment_status_types s,
6769: per_ass_status_type_amends a ,
6770: per_assignment_status_types_tl stl,
6771: per_ass_status_type_amends_tl atl
6772: where s.assignment_status_type_id = p_assignment_status_type_id
6773: and a.assignment_status_type_id (+) = s.assignment_status_type_id
6774: and s.active_flag = 'Y'
6775: and a.active_flag(+) = 'Y'