[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_warning BOOLEAN := FALSE;
SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
FROM hr_organization_units o1
, hr_organization_information hoi1
, hr_organization_information hoi2
WHERE o1.business_group_id =p_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = csr_v_legal_emp_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='DK_LEGAL_ENTITY_DETAILS' ;
SELECT * FROM hr_organization_information
WHERE org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
AND organization_id IN (
SELECT organization_id FROM hr_organization_units
WHERE business_group_id= p_business_group_id);
select pap.person_id, paa.assignment_id, pap.NATIONAL_IDENTIFIER, paa.assignment_number, to_char(pap.date_of_birth,'yyyymmdd') dob,
first_name||' '||middle_names||' '||last_name pname, pap.effective_start_date
from per_all_assignments_f paa,
per_all_people_f pap, hr_soft_coding_keyflex scl where
paa.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
and scl.segment1 = p_le_id
and paa.business_group_id = p_bg_id
and paa.PRIMARY_FLAG='Y'
and pap.person_id=paa.person_id
and pap.effective_start_date = (SELECT MAX(date_start) lhd FROM per_periods_of_service
WHERE person_id=pap.person_id)
and pap.effective_start_date >= fnd_date.canonical_to_date(p_start_date)
and pap.effective_start_date = paa.effective_start_date;
SELECT ee.effective_start_date, eev1.screen_entry_value, ee.element_entry_id, ee.object_version_number, iv1.input_value_id
FROM --per_all_assignments_f asg1
pay_element_types_f et
,pay_input_values_f iv1
,pay_element_entries_f ee
,pay_element_entry_values_f eev1
WHERE -- asg1.assignment_id = p_assignment_id
et.element_name = 'Tax Card'
AND et.legislation_code = 'DK'
AND iv1.element_type_id = et.element_type_id
AND iv1.name = p_input_value
AND ee.element_type_id = et.element_type_id
AND ee.assignment_id = p_assignment_id--asg1.assignment_id
AND eev1.element_entry_id = ee.element_entry_id
AND eev1.input_value_id = iv1.input_value_id
and eev1.effective_start_date = ee.effective_start_date
and p_hire_date between ee.effective_start_date and ee.effective_end_date
and p_hire_date between et.effective_start_date and et.effective_end_Date
and p_hire_date between iv1.effective_start_date and iv1.effective_end_date;
SELECT *
FROM per_addresses_v
WHERE person_id =pid
and primary_flag='Y'
and business_group_id=p_business_group_id;
SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;
SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;
/* Update the tax requisition status to - REQUEST COMPLETE*/
py_element_entry_api.update_element_entry
(p_validate => FALSE
,p_datetrack_update_mode => 'CORRECTION' --p_datetrack_update_mode
,p_effective_date => rg_csr_get_person_id.effective_start_date --p_effective_date
,p_business_group_id => p_business_group_id
,p_element_entry_id => rg_csr_get_tax_card_details.element_entry_id
,p_object_version_number => rg_csr_get_tax_card_details.object_version_number --p_object_version_number
,p_input_value_id1 => l_input_value_id
,p_entry_value1 => 'REQUEST COMPLETE'
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_update_warning => l_update_warning
);
select decode(mod(substr(l_cpr_number,10),2),0,'2','1') into l_sex from dual;