APPS.PER_PERRPRAA_XMLP_PKG SQL Statements

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

Line: 104

	select value
	into c_nls_language
	from nls_session_parameters
	where parameter = 'NLS_LANGUAGE';

Line: 121

SELECT  sum (fnd_number.canonical_to_number(target.screen_entry_value))
INTO    l_runtot
FROM   pay_element_entry_values_f target
,      pay_element_entries_f  ee
,      per_absence_attendance_types abtype
,      per_assignments_f ASS
WHERE  ASS.person_id = summ_person_id
AND    ASS.primary_flag = 'Y'
AND    P_SESSION_DATE
       BETWEEN ASS.effective_start_date AND ASS.effective_end_date
AND    ass.assignment_id = ee.assignment_id
AND    target.element_entry_id = EE.element_entry_id
AND    ABTYPE.absence_attendance_type_id = p_absence_attendance_type_id
AND    ABTYPE.input_value_id = target.input_value_id;