[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pet.element_type_id
,pet.element_name
,pet.business_group_id
,pet.legislation_code
,pet.indirect_only_flag
,MIN(pet.effective_start_date) effective_date
FROM pay_element_types_f pet
,per_business_groups pbg
WHERE Nvl(pet.indirect_only_flag, 'N') = 'N'
AND pet.business_group_id = c_business_group_id
AND pbg.business_group_id = pet.business_group_id
AND pbg.legislation_code = 'ES'
AND pet.legislation_code IS NULL
GROUP BY pet.element_type_id
,pet.element_name
,pet.business_group_id
,pet.legislation_code
,pet.indirect_only_flag;
SELECT prt.run_type_id
,prt.shortname
FROM pay_run_types_f prt
WHERE legislation_code = 'ES'
AND prt.shortname = 'TAX_WITHHOLDING_RATE'
AND p_effective_date between effective_start_date and effective_end_date
AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
FROM pay_element_type_usages_f petu
WHERE petu.RUN_TYPE_ID = prt.RUN_TYPE_ID
AND petu.ELEMENT_TYPE_ID = p_ELEMENT_TYPE_ID
AND p_effective_date between petu.effective_start_date and petu.effective_end_date);
SELECT petl.element_name element_name
,pecl.classification_name classification_name
FROM pay_element_types_f pet
,pay_element_types_f_tl petl
,pay_element_classifications_tl pecl
WHERE pet.element_type_id = c_element_type_id
AND pet.element_type_id = petl.element_type_id
AND petl.language = USERENV('LANG')
AND pet.classification_id = pecl.classification_id
AND c_effective_date BETWEEN pet.effective_start_date and pet.effective_end_date;
SELECT prt.run_type_name run_type_name
FROM pay_run_types_f_tl prt
WHERE prt.run_type_id = c_run_type_id
AND prt.language = USERENV('LANG');