[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT to_number (
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
)
) legal,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
) request_for,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'DIVISION'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'DIVISION')) - 1
) division,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'REQUEST_FOR_DIV'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'REQUEST_FOR_DIV')) - 1
) request_for_div,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'AGREEMENT_AREA'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'AGREEMENT_AREA')) - 1
) agreement_area,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'REQUEST_FOR_AGREEMENT'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'REQUEST_FOR_AGREEMENT')) - 1
)
request_for_agreement,
(pay_se_trna_archive.get_parameter (legislative_parameters, 'REPORT_DATE')) report_date,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'PRECEDENCE_END_DATE'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'PRECEDENCE_END_DATE')) - 1
)
precedence_end_date1,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'EMP_CATG'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'EMP_CATG')) - 1
) emp_catg,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'ASG_CATG'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'ASG_CATG')) - 1
) asg_catg,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'EMP_SEC'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'EMP_SEC')) - 1
) requesting_emp_sec,
substr (
pay_se_trna_archive.get_parameter (legislative_parameters, 'SORT_ORDER'),
1,
LENGTH (pay_se_trna_archive.get_parameter (legislative_parameters, 'SORT_ORDER')) - 1
) sort_order,
(pay_se_trna_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
(pay_se_trna_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
eff_end_date,
(pay_se_trna_archive.get_parameter (legislative_parameters, 'PRECEDENCE_END_DATE')) precedence_end_date,
(pay_se_trna_archive.get_parameter (legislative_parameters, 'START_DATE_OF_BIRTH'))
start_date_of_birth,
(pay_se_trna_archive.get_parameter (legislative_parameters, 'END_DATE_OF_BIRTH')) end_date_of_birth,
effective_date
effective_date, business_group_id bg_id
FROM pay_payroll_actions
WHERE payroll_action_id = p_payroll_action_id;
SELECT decode (lr_parameter_info.emp_catg, 'B', 'BC', 'W', 'WC', NULL)
INTO p_emp_catg
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 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';
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.full_name, papf.national_identifier, paaf.assignment_number,
paaf.employment_category, hsck.segment15 div_code, hsck.segment14 area_code
FROM per_all_assignments_f paaf,
hr_soft_coding_keyflex hsck,
hr_organization_units hou,
hr_organization_information hoi,
per_all_people_f papf
WHERE papf.person_id BETWEEN p_start_person AND p_end_person
AND g_report_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND paaf.effective_start_date BETWEEN papf.effective_start_date AND papf.effective_end_date
AND papf.person_id = paaf.person_id
AND hou.business_group_id = g_business_group_id
AND papf.date_of_birth BETWEEN nvl (g_start_date_of_birth, TO_DATE ('01/01/0001', 'dd/mm/yyyy'))
AND nvl (g_end_date_of_birth, TO_DATE ('31/12/4712', 'dd/mm/yyyy'))
AND paaf.employee_category IN ('WC', 'BC')
AND paaf.employee_category = nvl (g_emp_catg, paaf.employee_category)
AND nvl (paaf.employment_category, '-1') = nvl (g_asg_catg, nvl (paaf.employment_category, '-1'))
AND hsck.segment15 IS NOT NULL
AND hsck.segment15 = nvl (g_div_code, hsck.segment15)
AND hsck.segment14 IS NOT NULL
AND hsck.segment14 = nvl (g_agreement_area, hsck.segment14)
AND primary_flag = 'Y'
AND hou.organization_id = hoi.organization_id
AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
AND hoi.organization_id = nvl (p_legal_employer_id, hoi.organization_id)
AND hoi.org_information_context = 'SE_LOCAL_UNITS'
AND hoi.org_information1 = hsck.segment2
AND nvl(fnd_date.canonical_to_date (hsck.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy')) <= nvl (
g_precedence_end_date,
TO_DATE ('31/12/4712', 'dd/mm/yyyy')
);
SELECT min (effective_start_date)
FROM per_all_assignments_f paaf, per_assignment_status_types past
WHERE assignment_id = p_assignment_id
AND paaf.assignment_status_type_id = past.assignment_status_type_id
AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
AND effective_start_date BETWEEN g_start_date AND g_end_date;
SELECT fnd_date.canonical_to_date (hsck.segment6) termination_date,
fnd_date.canonical_to_date (hsck.segment16)
precedence_date
FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
WHERE paaf.assignment_id = p_assignment_id
AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
SELECT start_date, end_date, end_date - start_date prev_emp_days
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 ASC;
SELECT pay_assignment_actions_s.NEXTVAL
INTO l_actid
FROM dual;