[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT scl.segment2 work_center
FROM per_all_assignments_f paaf
,hr_soft_coding_keyflex scl
WHERE paaf.assignment_id = p_assignment_id
AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT hoi.organization_id le_id
FROM hr_organization_information hoi
WHERE hoi.org_information1 = p_wc_organization_id
AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
SELECT eev.screen_entry_value payment_key
FROM pay_element_entries_f pee
,pay_element_entry_values_f eev
,pay_input_values_f piv
,pay_element_types_f pet
,pay_assignment_actions paa
,pay_payroll_actions ppa
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND pee.element_entry_id = eev.element_entry_id
AND eev.input_value_id + 0 = piv.input_value_id
AND piv.name = 'Payment Key'
AND piv.element_type_id = pet.element_type_id
AND ppa.effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date
AND pee.assignment_id = paa.assignment_id
AND pet.element_name = 'Tax Details'
AND pet.legislation_code = 'ES'
AND ppa.effective_date BETWEEN pee.effective_start_date
AND pee.effective_end_date
AND ppa.effective_date BETWEEN eev.effective_start_date
AND eev.effective_end_date
AND ppa.effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
SELECT eev.screen_entry_value epigraph_code
FROM pay_element_entries_f pee
,pay_element_entry_values_f eev
,pay_input_values_f piv
,pay_element_types_f pet
,pay_assignment_actions paa
,pay_payroll_actions ppa
,per_time_periods ptp
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND ppa.payroll_id = ptp.payroll_id
AND ppa.time_period_id = ptp.time_period_id
AND pee.element_entry_id = eev.element_entry_id
AND eev.input_value_id + 0 = piv.input_value_id
AND piv.name = 'SS Epigraph Code'
AND piv.element_type_id = pet.element_type_id
AND ppa.effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date
AND pee.assignment_id = paa.assignment_id
AND pet.element_name = 'Social Security Details'
AND pet.legislation_code = 'ES'
AND pee.effective_end_date = eev.effective_end_date
AND eev.effective_end_date >= ptp.start_date
AND ppa.effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
ORDER BY eev.effective_start_date;
SELECT eev.screen_entry_value sec_cac
FROM pay_element_entries_f pee
,pay_element_entry_values_f eev
,pay_input_values_f piv
,pay_element_types_f pet
,pay_assignment_actions paa
,pay_payroll_actions ppa
,per_time_periods ptp
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND ppa.payroll_id = ptp.payroll_id
AND ppa.time_period_id = ptp.time_period_id
AND pee.element_entry_id = eev.element_entry_id
AND eev.input_value_id + 0 = piv.input_value_id
AND piv.name = 'Work Center CAC'
AND piv.element_type_id = pet.element_type_id
AND ppa.effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date
AND pee.assignment_id = paa.assignment_id
AND pet.element_name = 'Multiple Employment Details'
AND pet.legislation_code = 'ES'
AND pee.effective_end_date = eev.effective_end_date
AND eev.effective_end_date >= ptp.start_date
AND ppa.effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
ORDER BY eev.effective_start_date;