APPS.GHR_BEN_VALIDATION SQL Statements

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

Line: 45

		SELECT rei_information3 payroll_id
		  FROM   ghr_pa_request_extra_info
		  WHERE  pa_request_id       =   c_pa_request_id
		  AND    information_type    =   'GHR_US_PAR_PAYROLL_TYPE';

Line: 51

		SELECT min(start_date) start_date
	   FROM per_time_periods
	   WHERE payroll_id = c_payroll_id
	   AND TO_CHAR(start_date,'YYYY') = c_year
	   AND TO_CHAR(start_date,'MM') = c_month;

Line: 70

			SELECT 1
				FROM pay_element_entries_f ele
				WHERE ele.assignment_id = c_assignment_id
				AND c_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date
				AND element_type_id = c_element_type_id;

Line: 80

			SELECT elt.element_type_id
			FROM pay_element_links eli, pay_element_types_f elt
			WHERE elt.element_type_id = eli.element_type_id
			AND eli.business_group_id = c_business_group_id
			AND elt.element_name = c_element_name;

Line: 568

SELECT a.element_name element_name,
        b.name           ipv_name,
       f.input_value_id           input_value_id,
       e.effective_start_date     effective_start_date,
       e.effective_end_date       effective_end_date,
       e.element_entry_id         element_entry_id,
       e.assignment_id            assignment_id,
       e.object_version_number    object_version_number,
       f.element_entry_value_id   element_entry_value_id,
       f.screen_entry_value       screen_entry_value
FROM   pay_element_types_f        a,
       pay_input_values_f         b,
       pay_element_entries_f      e,
	   pay_element_entry_values_f f,
	   pay_element_links_f        g
WHERE  a.element_type_id      = b.element_type_id
AND	   e.element_type_id	  = a.element_type_id
AND    f.element_entry_id     = e.element_entry_id
AND    f.input_value_id       = b.input_value_id
AND    g.element_type_id      = a.element_type_id
AND    c_effective_date between g.effective_start_date and g.effective_end_date
AND    c_effective_date between a.effective_start_date and a.effective_end_date
AND    c_effective_date between b.effective_start_date and b.effective_end_date
AND    g.business_group_id = c_business_group_id
--and    e.effective_start_date = f.effective_start_date
--and    e.effective_end_date   = f.effective_end_date
and e.assignment_id         =  c_assignment_id
and a.element_name = c_element_name
AND c_effective_date BETWEEN e.effective_start_date AND e.effective_end_date;

Line: 601

SELECT person_id
FROM per_all_assignments_f asg
WHERE asg.assignment_id = c_assignment_id
AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line: 609

	SELECT element_name
	FROM pay_element_types_f pet, pay_element_links_f pel
	where pet.element_type_id = pel.element_type_id
	and c_effective_date between pel.effective_start_date and pel.effective_end_date
	and pel.business_group_id = c_business_group_id
	and pel.element_link_id = c_element_link_id;

Line: 738

PROCEDURE validate_update_element(
  p_effective_date               in date
  ,P_ASSIGNMENT_ID_O                in number     default null
  ,p_validation_start_date        in date
  ,p_validation_end_date          in date
  ,p_element_entry_id             in number
  ,p_effective_start_date         in date
  ,p_effective_end_date           in date
  ,P_ELEMENT_LINK_ID_O              in number    default null
  ,P_ELEMENT_TYPE_ID_O              in number	   default null
  ) IS
BEGIN
	IF g_debug = TRUE THEN
		hr_utility.set_location('Entering validate_update_element',110);

Line: 765

END validate_update_element;

Line: 774

SELECT assignment_type, assignment_id
FROM per_all_assignments_f asg
WHERE asg.person_id = c_person_id
AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line: 781

SELECT effective_date
FROM fnd_sessions
WHERE session_id = c_session_id;

Line: 787

SELECT *
FROM per_people_extra_info ppei
WHERE ppei.person_extra_info_id = c_per_extra_info_id
AND ppei.information_type = c_information_type;

Line: 813

SELECT noa_family_code
FROM ghr_noa_families
WHERE nature_of_action_id = c_noa_id
AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))
AND NVL(end_date_active,to_date('31/12/4712','dd/mm/yyyy'));