[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DATE_OF_BIRTH,PER_INFORMATION8
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID=p_person_id
AND p_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;
select SOFT_CODING_KEYFLEX_ID
from PER_ALL_ASSIGNMENTS_F
where assignment_id = p_assignment_id;
select lookups.meaning
from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
and lookups.lookup_type=l_information_code
and lookups.enabled_flag = 'Y'
and lookups.lookup_code = decode(l_information_code,'FI_EMPLOYMENT_TYPE',scl.segment3,
'FI_WORKING_TIME_TYPE',scl.segment4,
'FI_SHIFT_WORK_TYPE',scl.segment5,
'FI_SHIFT_WORK_TYPE_DAYS',scl.segment6,
'FI_COM_PRICE_CAT',scl.segment7,
'FI_EMPLOYEE_STATUS',scl.segment8,
'FI_PERSONNEL_GRP',scl.segment9,
'FI_INS_OCC_GRP',scl.segment10,
'FI_EMPR_OCC_GRP',scl.segment11,null);
select segment2
from hr_soft_coding_keyflex
where soft_coding_keyflex_id = l_scl_id;
select lookups.meaning
from hr_organization_information hoi , hr_lookups lookups
where hoi.organization_id = l_org_id
and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
and lookups.lookup_type = l_information_code
and lookups.enabled_flag = 'Y'
and lookups.lookup_code = decode(l_information_code,'FI_EMPLOYMENT_TYPE',hoi.org_information1,
'FI_WORKING_TIME_TYPE',hoi.org_information2,
'FI_SHIFT_WORK_TYPE',hoi.org_information3,
'FI_SHIFT_WORK_TYPE_DAYS',hoi.org_information4,
'FI_COM_PRICE_CAT',hoi.org_information5,null);
select hoi2.organization_id
from hr_organization_information hoi1 , hr_organization_information hoi2
where hoi1.org_information1 = to_char(l_local_unit) and hoi1.org_information_context = 'FI_LOCAL_UNITS'
and hoi2.org_information_context = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL_EMPLOYER'
and hoi2.organization_id = hoi1.organization_id;
select lookups.meaning
from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
where hou.organization_id = l_organization_id
and hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
and lookups.lookup_type = l_information_code
and lookups.enabled_flag = 'Y'
and lookups.lookup_code = decode(l_information_code,'FI_EMPLOYMENT_TYPE',hoi.org_information1,
'FI_WORKING_TIME_TYPE',hoi.org_information2,
'FI_SHIFT_WORK_TYPE',hoi.org_information3,
'FI_SHIFT_WORK_TYPE_DAYS',hoi.org_information4,
'FI_COM_PRICE_CAT',hoi.org_information5,null);
select business_group_id
from hr_organization_units
where organization_id = l_organization_id;
SELECT NVL(a.model_year,0)
, nvl(a.list_price,0)
+ nvl(a.accessory_value_at_startdate,0)
+ nvl(a.accessory_value_added_later ,0)
, a.engine_capacity_in_cc
, a.vehicle_type
FROM pqp_vehicle_repository_f a , pqp_vehicle_allocations_f b
WHERE a.VEHICLE_REPOSITORY_ID = b.VEHICLE_REPOSITORY_ID
AND p_effective_date between b.effective_start_date
AND b.effective_end_date
AND p_effective_date between a.effective_start_date
AND a.effective_end_date
AND b.assignment_id = p_assignment_id
AND b.business_group_id = p_business_group_id
AND b.vehicle_allocation_id = p_vehicle_allot_id;
SELECT COUNT(distinct(c.contact_person_id))
INTO l_dependent_number
FROM per_contact_relationships c
WHERE c.person_id = (SELECT b.person_id from per_all_assignments_f b
WHERE b.assignment_id = p_assignment_id
AND p_process_date between b.effective_start_date AND b.effective_end_date
)
AND c.dependent_flag = 'Y'
AND c.business_group_id = p_business_group_id;
SELECT eev1.screen_entry_value screen_entry_value
FROM per_all_assignments_f asg1
,per_all_assignments_f asg2
,per_all_people_f per
,pay_element_links_f el
,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
AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
AND per.person_id = asg1.person_id
AND asg2.person_id = per.person_id
AND asg2.primary_flag = 'Y'
AND et.element_name = 'Court Order Information'
AND et.legislation_code = 'FI'
AND iv1.element_type_id = et.element_type_id
AND iv1.name = p_input_value
AND el.business_group_id = per.business_group_id
AND el.element_type_id = et.element_type_id
AND ee.assignment_id = asg2.assignment_id
AND ee.element_link_id = el.element_link_id
AND eev1.element_entry_id = ee.element_entry_id
AND eev1.input_value_id = iv1.input_value_id;
select hoi2.org_information2,hoi2.org_information3,hoi2.org_information4,pap1.per_information11
, pap1.per_information12 , pap1.per_information13
from HR_ORGANIZATION_UNITS o1
, HR_ORGANIZATION_INFORMATION hoi1
, HR_ORGANIZATION_INFORMATION hoi2
, per_all_people_f pap1
, per_all_assignments_f paa
WHERE hoi1.organization_id = o1.organization_id
and hoi1.org_information1 = 'FI_TRADE_UNION'
and hoi1.org_information_context = 'CLASS'
and hoi2.ORG_INFORMATION_CONTEXT='FI_TRADE_UNION_DETAILS'
and o1.organization_id = pap1.per_information9
and hoi1.organization_id = hoi2.organization_id
AND pap1.person_id = paa.person_id
AND o1.business_group_id = paa.business_group_id
AND p_effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(pap1.per_information18),
hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),
hr_general.end_of_time)
AND paa.assignment_id = p_assignment_id;
SELECT tag
FROM fnd_lookup_values
WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
INSTR(USERENV('LANGUAGE'), '.') + 1)
AND language = 'US';