APPS.HRI_BPL_ASG_STATUS_TYPES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

    SELECT
	DECODE(y1.per_system_status,
	        'TERM_APL',
	        y1T.user_status,
	        DECODE(p_current_employee_flag ,
	               'Y',
	               p_user_status,
	               x1T.user_status
	        )
	) appl_user_status,
	DECODE(y1.per_system_status,
		'TERM_ASSIGN',
		y1T.user_status,
		x1T.user_status
	) emp_user_status
    FROM
	per_ass_status_type_amends_tl y1T ,
	 (select *
	  from   per_ass_status_type_amends
	  where  business_group_id = hr_bis.get_sec_profile_bg_id) y1,
	per_assignment_status_types_tl x1T,
	per_assignment_status_types x1
    WHERE
	x1.per_system_status = c_per_system_status AND
	x1.default_flag = 'Y' AND
	x1.business_group_id is null AND
	x1.assignment_status_type_id = x1T.assignment_status_type_id AND
	x1T.language = userenv('LANG') AND
	x1.assignment_status_type_id = y1.assignment_status_type_id(+) AND
	y1.ass_status_type_amend_id = y1T.ass_status_type_amend_id(+) AND
	y1T.language (+) = userenv('LANG');