APPS.PAY_SE_ARCHIVE_TETA SQL Statements

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

Line: 84

		SELECT PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'PERSON_ID')
		,fnd_date.canonical_to_date(PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'DATE_REPORT'))
		,PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
		,effective_date
		,business_group_id
		FROM  pay_payroll_actions
		WHERE payroll_action_id = p_payroll_action_id;

Line: 131

			SELECT  *
			FROM  per_all_people_f  ppf
			WHERE ppf.person_id = csr_v_person_id
			AND csr_v_effective_date BETWEEN ppf.effective_start_date
			AND ppf.effective_end_date;

Line: 146

			 p_sql := 'SELECT DISTINCT person_id
			FROM  per_people_f ppf
			,pay_payroll_actions ppa
			WHERE ppa.payroll_action_id = :payroll_action_id
			AND   ppa.business_group_id = ppf.business_group_id
			AND ROWNUM < 2
			ORDER BY ppf.person_id';

Line: 173

				SELECT count(*)
				INTO l_count
				FROM   pay_action_information
				WHERE  action_information_category = 'EMEA REPORT DETAILS'
				AND    action_information1             = 'PYSETETA'
				AND    action_context_id           = p_payroll_action_id;

Line: 257

		SELECT assign.assignment_id
		FROM
		per_all_assignments_f             assign
		,hr_soft_coding_keyflex		scl
		,hr_organization_units		o1
		,hr_organization_information	hoi1
		,hr_organization_information	hoi2
		,hr_organization_information	hoi3
		WHERE assign.person_id= csr_v_person_id
		AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
		AND o1.business_group_id = csr_v_business_group_id
		AND hoi1.organization_id = o1.organization_id
		AND hoi1.organization_id = TO_CHAR(scl.segment2)
		AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
		AND hoi1.org_information_context = 'CLASS'
		AND o1.organization_id = hoi2.org_information1
		AND hoi2.org_information_context='SE_LOCAL_UNITS'
		AND hoi2.organization_id =  hoi3.organization_id
		AND hoi3.org_information_context='CLASS'
		AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
		AND primary_flag   ='Y'
                AND assign.effective_start_date < =csr_v_effective_date
		GROUP BY assign.assignment_id;

Line: 312

					SELECT pay_assignment_actions_s.NEXTVAL
					INTO   l_actid
					FROM   dual;

Line: 375

		SELECT assign.assignment_id
		 ,hoi3.organization_id, assign.employment_category
		 , trunc(assign.effective_start_date) effective_start_date
		,trunc(decode(assign.effective_end_date,to_date('31/12/4712','dd/mm/yyyy'), g_date_report ,assign.effective_end_date) ) effective_end_date
		FROM
		per_all_assignments_f             assign
		,hr_soft_coding_keyflex		scl
		,hr_organization_units		o1
		,hr_organization_information	hoi1
		,hr_organization_information	hoi2
		,hr_organization_information	hoi3
		WHERE assign.assignment_id = csr_v_assign_id
		AND assign.person_id = csr_v_person_id
		AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
		AND o1.business_group_id = csr_v_business_group_id
		AND hoi1.organization_id = o1.organization_id
		AND hoi1.organization_id = TO_CHAR(scl.segment2)
		AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
		AND hoi1.org_information_context = 'CLASS'
		AND o1.organization_id = hoi2.org_information1
		AND hoi2.org_information_context='SE_LOCAL_UNITS'
		AND hoi2.organization_id =  hoi3.organization_id
		AND hoi3.org_information_context='CLASS'
		AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
		AND primary_flag   ='Y'
                AND assign.effective_start_date < =csr_v_effective_date
		ORDER BY assign.effective_start_date DESC;

Line: 411

		SELECT assign.assignment_id
		 ,hoi3.organization_id, assign.employment_category
		,sum(decode(assign.effective_end_date,to_date('31/12/4712','dd/mm/yyyy'), g_date_report ,assign.effective_end_date) - assign.effective_start_date ) days_worked
		FROM
		per_all_assignments_f             assign
		,hr_soft_coding_keyflex		scl
		,hr_organization_units		o1
		,hr_organization_information	hoi1
		,hr_organization_information	hoi2
		,hr_organization_information	hoi3
		WHERE assign.assignment_id = csr_v_assign_id
		AND assign.person_id = csr_v_person_id
		AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
		AND o1.business_group_id = csr_v_business_group_id
		AND hoi1.organization_id = o1.organization_id
		AND hoi1.organization_id = TO_CHAR(scl.segment2)
		AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
		AND hoi1.org_information_context = 'CLASS'
		AND o1.organization_id = hoi2.org_information1
		AND hoi2.org_information_context='SE_LOCAL_UNITS'
		AND hoi2.organization_id =  hoi3.organization_id
		AND hoi3.org_information_context='CLASS'
		AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
		AND primary_flag   ='Y'
                AND assign.effective_start_date < =csr_v_effective_date
		GROUP BY assign.assignment_id ,hoi3.organization_id, assign.employment_category;

Line: 447

		SELECT  hou.NAME
		FROM hr_organization_units hou
		WHERE hou.organization_id=csr_v_employer_id;

Line: 459

		SELECT l.meaning employment_category
		FROM hr_leg_lookups l
		WHERE l.lookup_type = 'EMP_CAT'
		AND l.enabled_flag = 'Y'
		AND l.lookup_code = csr_v_lookup_code
		AND csr_v_effective_date
		BETWEEN nvl(start_date_active,csr_v_effective_date)
		AND nvl(end_date_active,csr_v_effective_date) ;

Line: 473

		SELECT  paa.assignment_id
		FROM pay_assignment_actions paa
		WHERE paa.assignment_action_id = p_assignment_action_id;

Line: 495

				SELECT 1
				INTO l_flag
				FROM pay_action_information
				WHERE action_information_category = 'EMEA REPORT INFORMATION'
				AND action_information1 = 'PYSETETA'
				AND action_information2 = 'PER'
				AND action_context_id = p_assignment_action_id;

Line: 659

		SELECT  *
		FROM per_previous_employers_v ppev
		WHERE ppev.person_id= csr_v_person_id
		AND ppev.business_group_id = csr_v_business_group_id
                AND ppev.start_date <= csr_v_effective_date
		ORDER BY ppev.start_date DESC;

Line: 669

	SELECT  sum(action_information10) total_days_worked
	FROM pay_action_information
	WHERE action_information_category = 'EMEA REPORT INFORMATION'
	AND action_information1 = 'PYSETETA'
	AND action_information2 = to_char(p_payroll_action_id)
	AND action_information11 IN ('PH','CH');