[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT to_number (
substr (
pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
1,
LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
)
) legal,
substr (
pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
1,
LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
) request_for,
(pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
(pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
eff_end_date,
effective_date effective_date, business_group_id bg_id
FROM pay_payroll_actions
WHERE payroll_action_id = p_payroll_action_id;
SELECT p_duration
+ (((substr (l_day_end_time, 1, 2) * 60 + substr (l_day_end_time, 4, 2))
- (substr (l_start_time, 1, 2) * 60 + substr (l_start_time, 4, 2))
)
/ 60
)
INTO p_duration
FROM dual;
SELECT p_duration
+ (((substr (l_end_time, 1, 2) * 60 + substr (l_end_time, 4, 2))
- (substr (l_day_start_time, 1, 2) * 60 + substr (l_day_start_time, 4, 2)) + 1
)
/ 60
)
INTO p_duration
FROM dual;
SELECT p_duration
+ ((trunc (l_schedule (l_idx).end_date_time) - trunc (l_schedule (l_idx).start_date_time) - 1)
* 24
)
INTO p_duration
FROM dual;
SELECT p_duration
+ (((substr (l_end_time, 1, 2) * 60 + substr (l_end_time, 4, 2))
- (substr (l_start_time, 1, 2) * 60 + substr (l_start_time, 4, 2))
)
/ 60
)
INTO p_duration
FROM dual;
SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
WHERE o1.business_group_id = g_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.organization_id
AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
SELECT papf.person_id, paaf.assignment_id, papf.date_of_birth, papf.sex, nvl (hsc.segment9, 100) work_percentage
FROM per_all_people_f papf,
per_all_assignments_f paaf,
hr_soft_coding_keyflex hsc,
per_assignment_status_types past,
hr_organization_information hoi,
per_person_types ppt,
per_all_people_f papfs,
per_all_assignments_f paafs
WHERE paaf.person_id = papf.person_id
AND paaf.business_group_id = papf.business_group_id
AND hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
AND hsc.segment2 = hoi.org_information1
AND hoi.organization_id = p_legal_employer_id
AND ppt.system_person_type LIKE 'EMP%'
AND ppt.person_type_id = papf.person_type_id
AND paaf.assignment_status_type_id = past.assignment_status_type_id
AND past.per_system_status = 'ACTIVE_ASSIGN'
AND paaf.primary_flag = 'Y'
AND paaf.assignment_id = paafs.assignment_id
AND papf.person_id = papfs.person_id
AND p_effective_end_date BETWEEN papfs.effective_start_date AND papfs.effective_end_date
AND p_effective_end_date BETWEEN papf.effective_start_date AND papf.effective_end_date
AND p_effective_end_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND p_effective_end_date BETWEEN paafs.effective_start_date AND paafs.effective_end_date;
SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
WHERE o1.business_group_id = g_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.organization_id
AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
SELECT org_information2 weekly_working_hours, org_information3 daily_working_hours,
org_information4
days_per_year, org_information5 hours_per_year
FROM hr_organization_information
WHERE organization_id = p_legal_employer_id
AND org_information_context = 'SE_STD_WORK_DETAILS'
AND org_information1 = p_year;
SELECT defined_balance_id
FROM pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb
WHERE pbt.balance_name = csr_v_balance_name
AND nvl (pbt.business_group_id, g_business_group_id) = g_business_group_id
AND pbt.balance_type_id = pdb.balance_type_id
AND pbd.database_item_suffix = '_ASG_YTD'
AND pbd.legislation_code = 'SE'
AND pbd.balance_dimension_id = pdb.balance_dimension_id;
SELECT element_type_id
FROM pay_element_types_f
WHERE element_name = p_element_name
AND legislation_code = 'SE'
AND business_group_id IS NULL
AND p_report_end_date BETWEEN effective_start_date AND effective_end_date;
SELECT input_value_id
FROM pay_input_values_f
WHERE element_type_id = p_element_type_id
AND p_report_end_date BETWEEN effective_start_date AND effective_end_date
AND NAME = p_input_value
AND legislation_code = 'SE'
AND business_group_id IS NULL;
SELECT prrv.result_value start_date
FROM pay_assignment_actions paa, pay_payroll_actions ppa, pay_run_results prr, pay_run_result_values prrv
WHERE ppa.effective_date BETWEEN p_report_start_date AND p_report_end_date
AND ppa.payroll_action_id = paa.payroll_action_id
AND paa.assignment_id = p_assignment_id
AND paa.assignment_action_id = prr.assignment_action_id
AND prr.element_type_id = p_element_type_id
AND prr.run_result_id = prrv.run_result_id
AND prrv.input_value_id = p_input_value_id
GROUP BY result_value;
SELECT sum (fnd_number.canonical_to_number (result_value))
FROM pay_run_result_values prrv
WHERE input_value_id = p_input_value_id
AND run_result_id IN (SELECT prr.run_result_id
FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,
pay_run_results prr
WHERE ppa.effective_date BETWEEN p_report_start_date AND p_report_end_date
AND ppa.payroll_action_id = paa.payroll_action_id
AND paa.assignment_id = p_assignment_id
and paa.assignment_action_id = prr.assignment_action_id
and prr.run_result_id = prrv1.run_result_id
and prrv1.result_value = p_group_start_date
) ;
'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
ORDER BY ppf.person_id';
p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';