[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pet.element_name,
pet.element_information4,
pet.business_group_id
from pay_element_entries_f pee,
pay_element_links_f pel,
pay_element_types_f pet,
pay_element_classifications pec,
per_assignments_f paf,
per_time_periods ptp
where paf.assignment_id = p_assignment_id
and pee.assignment_id = paf.assignment_id
and ptp.payroll_id = paf.payroll_id
and p_effective_start_date between ptp.start_date and ptp.end_date
and ptp.start_date < pee.effective_end_date
and pee.element_link_id = pel.element_link_id
and pel.element_link_id <> p_element_link_id
and pel.element_type_id = pet.element_type_id
and pet.classification_id = pec.classification_id
and pec.classification_name = 'Involuntary Deductions';
select pet.element_name,
pet.element_information4,
pet.business_group_id
from pay_element_links_f pel,
pay_element_types_f pet,
pay_element_classifications pec
where pel.element_link_id = p_element_link_id
and pel.element_type_id = pet.element_type_id
and pet.classification_id = pec.classification_id
and pec.classification_name = 'Involuntary Deductions';
select pset.template_id
from pay_shadow_element_types pset,
pay_element_templates pet
where pet.template_id = pset.template_id
and pet.template_type = 'U'
and pset.element_name = cp_element_name
and pet.business_group_id = cp_business_group_id;
ln_architecture_flag := -1; /* No architecture selected currently */