APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_ASSIGNMENT_STATUS_TYPES

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

6759: (
6760: p_assignment_status_type_id in number
6761: ) return varchar2 is
6762: --
6763: l_assignment_status_type_name per_assignment_status_types_tl.user_status%type := null;
6764: --
6765: cursor c_assignment_status_type_name is
6766: select nvl(atl.user_status,stl.user_status) user_status
6767: from per_assignment_status_types s,

Line 6767: from per_assignment_status_types s,

6763: l_assignment_status_type_name per_assignment_status_types_tl.user_status%type := null;
6764: --
6765: cursor c_assignment_status_type_name is
6766: select nvl(atl.user_status,stl.user_status) user_status
6767: from per_assignment_status_types s,
6768: per_ass_status_type_amends a ,
6769: per_assignment_status_types_tl stl,
6770: per_ass_status_type_amends_tl atl
6771: where s.assignment_status_type_id = p_assignment_status_type_id

Line 6769: per_assignment_status_types_tl stl,

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