APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 6764: l_assignment_status_type_name per_assignment_status_types_tl.user_status%type := null;

6760: (
6761: p_assignment_status_type_id in number
6762: ) return varchar2 is
6763: --
6764: l_assignment_status_type_name per_assignment_status_types_tl.user_status%type := null;
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,

Line 6770: per_assignment_status_types_tl stl,

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
6774: and s.active_flag = 'Y'