[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select et.element_name, entry.assignment_id
from pay_element_entries entry,
pay_element_links el,
pay_element_types_f_tl et
where entry.element_entry_id = p_ee_id
and et.element_type_id = el.element_type_id
and el.element_link_id = entry.element_link_id
and et.language = userenv('lang');
select plc.input_value_name
from ff_contexts ffc,
pay_legislation_contexts plc
where ffc.context_name = p_cxt_name
and ffc.context_id = plc.context_id
and plc.legislation_code = 'FR';
select SCREEN_ENTRY_VALUE from
pay_assignment_actions aa,
pay_payroll_actions pa,
pay_element_entries_f ee,
pay_element_entry_values_f eev,
pay_input_values_f iv,
pay_element_types_f et,
pay_element_links_f el
where aa.assignment_action_id = p_asg_act_id
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = ee.assignment_id
and iv.input_value_id = eev.input_value_id
and el.element_link_id = ee.element_link_id
and ee.element_entry_id = eev.element_entry_id
and et.element_name = 'FR_STATUTORY_DEDUCTIONS'
and iv.name = 'Process_Type'
and el.element_type_id = et.element_type_id
and pa.date_earned between
et.effective_start_date and et.effective_end_date
and pa.date_earned between
iv.effective_start_date and iv.effective_end_date
and pa.date_earned between
el.effective_start_date and el.effective_end_date
and pa.date_earned between
ee.effective_start_date and ee.effective_end_date
and pa.date_earned between
eev.effective_start_date and eev.effective_end_date;
select tax_unit_id
from pay_assignment_actions
where assignment_action_id = p_assignment_action_id;
select fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
from hr_organization_information hoi
where hoi.organization_id = g_estab_id
AND hoi.org_information_context = 'FR_ESTAB_INFO';
select ORG_PAYMENT_METHOD_ID
from pay_org_payment_methods_f
where ORG_PAYMENT_METHOD_ID = p_opm_id
and p_date between effective_start_date and effective_end_date;
select substrb(ORG_PAYMENT_METHOD_NAME,1,80)
from pay_org_payment_methods_f_tl
where ORG_PAYMENT_METHOD_ID = p_opm_id
and language = userenv('LANG');
select substrb(NAME,1,60), substrb(hrl.meaning,1,20)
from hr_all_organization_units_tl org,
hr_organization_information ori,
hr_lookups hrl
where org.ORGANIZATION_ID = p_org_id
and org.language = userenv('LANG')
and org.ORGANIZATION_ID = ori.ORGANIZATION_ID
and ori.org_information_context = 'CLASS'
and ori.ORG_INFORMATION1 = hrl.lookup_code
and hrl.lookup_type = 'ORG_CLASS';
SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
INTO p_org_method_id
FROM hr_organization_information hoi,
hr_all_organization_units org
WHERE hoi.organization_id = g_estab_id
AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
AND hoi.organization_id = org.organization_id
AND p_effective_date between org.date_from
AND nvl(org.date_to, hr_general.end_of_time);
SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
INTO p_org_method_id
FROM hr_organization_information hoi,
hr_all_organization_units org
WHERE hoi.organization_id = l_company_id
AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
AND hoi.organization_id = org.organization_id
AND p_effective_date between org.date_from
AND nvl(org.date_to, hr_general.end_of_time);
select epd1.source_element_type_id,
max(decode(piv.name,'Contribution_Code',eev1.screen_entry_value)) cc1,
max(decode(piv.name,'Contribution_Code',eev2.screen_entry_value)) cc2,
max(decode(piv.name,'Process_Type',eev1.screen_entry_value)) pt1,
max(decode(piv.name,'Process_Type',eev2.screen_entry_value)) pt2,
max(decode(piv.name,'Contribution_Usage_ID',eev1.screen_entry_value)) cui1,
max(decode(piv.name,'Contribution_Usage_ID',eev2.screen_entry_value)) cui2,
max(decode(piv.name,'Rate Type',eev1.screen_entry_value)) rt1,
max(decode(piv.name,'Rate Type',eev2.screen_entry_value)) rt2
from pay_element_entries_f pee1,
pay_element_entries_f pee2,
pay_entry_process_details epd1,
pay_entry_process_details epd2,
pay_element_entry_values_f eev1,
pay_element_entry_values_f eev2,
pay_input_values_f piv
where pee1.element_entry_id = p_element_entry_id
and pee2.element_link_id = pee1.element_link_id
and pee2.assignment_id = pee1.assignment_id
and pee2.effective_start_date = pee1.effective_start_date
and pee2.effective_end_date = pee1.effective_end_date
and pee2.creator_id = pee1.creator_id
and pee2.creator_type in ('EE','RR')
and pee2.element_entry_id <> pee1.element_entry_id
and epd1.element_entry_id = pee1.element_entry_id
and epd2.element_entry_id = pee2.element_entry_id
and epd2.retro_component_id = epd1.retro_component_id
and epd2.process_path = epd1.process_path
and epd2.source_asg_action_id = epd1.source_asg_action_id
and epd2.source_element_type_id = epd1.source_element_type_id
and (epd1.tax_unit_id is null or
epd2.tax_unit_id = epd1.tax_unit_id)
and epd2.source_entry_id = epd1.source_entry_id
and eev1.element_entry_id = pee1.element_entry_id
and eev2.element_entry_id = pee2.element_entry_id
and eev1.input_value_id = eev2.input_value_id
and piv.input_value_id = eev2.input_value_id
and piv.name in ('Contribution_Code','Process_Type',
'Contribution_Usage_ID','Rate Type')
group by epd1.source_element_type_id
having max(decode(piv.name,'Contribution_Code',eev1.screen_entry_value))
= max(decode(piv.name,'Contribution_Code',eev2.screen_entry_value))
and max(decode(piv.name,'Process_Type',eev1.screen_entry_value))
= max(decode(piv.name,'Process_Type',eev2.screen_entry_value))
and max(decode(piv.name,'Contribution_Usage_ID',eev1.screen_entry_value))
= max(decode(piv.name,'Contribution_Usage_ID',eev2.screen_entry_value))
and nvl(max(decode(piv.name,'Rate Type',eev1.screen_entry_value)),' ')
= nvl(max(decode(piv.name,'Rate Type',eev2.screen_entry_value)),' ');
select retro_contribution_code,contribution_type
from pay_fr_contribution_usages
where contribution_usage_id = p_cu_id
and retro_contribution_code <> contribution_code;