[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pivtl.name Name,
peev.screen_entry_value value ,
piv.lookup_type lookup_type,
piv.value_set_id ,
hr_bis.bis_decode_lookup('PROCESSING_TYPE',pet.PROCESSING_TYPE) Recurring,
pettl.element_name element_name,
pectl.classification_name classification
FROM pay_element_entries_f pee,
pay_element_types_f pet,
pay_element_types_f_tl pettl,
pay_element_entry_values_f peev,
pay_input_values_f piv,
pay_input_values_f_tl pivtl ,
pay_element_classifications pec,
pay_element_classifications_tl pectl
WHERE pet.element_type_id = pee.element_type_id
and pet.element_type_id = pettl.element_type_id
and pettl.language = userenv('LANG')
and pec.classification_id = pectl.classification_id
and pectl.language = userenv('LANG')
and pet.classification_id = pec.classification_id
AND piv.input_value_id = pivtl.input_value_id
AND pivtl.language = userenv('LANG')
AND peev.input_value_id = piv.input_value_id
AND pet.element_type_id = piv.element_type_id
AND pee.element_entry_id = peev.element_entry_id
AND pee.creator_type <> 'UT'
AND cp_start_date between pet.effective_start_date
and pet.effective_end_date
AND cp_start_date between piv.effective_start_date
and piv.effective_end_date
AND pee.effective_start_date = cp_ele_start_date
AND pee.effective_end_date = cp_ele_end_date
AND peev.effective_start_date = cp_ele_start_date
AND peev.effective_end_date = cp_ele_end_date
AND pee.element_entry_id = cp_element_entry_id
ORDER BY piv.display_sequence ;
select territory_short_name
from fnd_territories_vl
where territory_code = nvl(p_territory_code, hr_api.return_legislation_code(p_business_group_id));
select name
from fnd_currencies_vl
where currency_code = p_currency_code;
select event_group_name
from pay_event_groups
where event_group_id = p_event_group_id;
select pettl.element_name
from pay_element_types_f pet,
pay_element_types_f_tl pettl
where pet.element_type_id = pettl.element_type_id
and pettl.language = userenv('LANG')
and pet.element_type_id = p_element_type_id
and p_effective_date between pet.effective_start_date and pet.effective_end_date;
select exa.id_flex_num,
exa.segment1,
exa.segment2,
exa.segment3,
exa.segment4,
exa.segment5,
exa.segment6,
exa.segment7,
exa.segment8,
exa.segment9,
exa.segment10,
exa.segment11,
exa.segment12,
exa.segment13,
exa.segment14,
exa.segment15,
exa.segment16,
exa.segment17,
exa.segment18,
exa.segment19,
exa.segment20,
exa.segment21,
exa.segment22,
exa.segment23,
exa.segment24,
exa.segment25,
exa.segment26,
exa.segment27,
exa.segment28,
exa.segment29,
exa.segment30
from pay_external_accounts exa
where exa.external_account_id = p_external_account_id;
SELECT REPLACE(fs.APPLICATION_COLUMN_NAME,column_name,'')
FROM FND_ID_FLEX_SEGMENTS fs,
FND_APPLICATION fap
WHERE fs.id_flex_num = flex_context_or_struct
and fs.id_flex_code = flex_name
and fs.enabled_flag = 'Y'
and fs.application_id = fap.application_id
and fap.APPLICATION_SHORT_NAME = app_short_name
order by fs.SEGMENT_NUM;
SELECT pro.proposed_salary_n
FROM per_pay_proposals pro
WHERE pro.assignment_id = c_assignment_id
AND pro.change_date =(SELECT max(pro2.change_date)
FROM per_pay_proposals pro2
WHERE pro2.assignment_id = c_assignment_id
AND pro2.change_date < c_date)
AND pro.change_date < c_date ;
SELECT max(pro.change_date)
FROM per_pay_proposals pro
WHERE pro.assignment_id = c_assignment_id
AND pro.change_date < c_period_end_date;
SELECT count(*) INTO v_count
FROM per_pay_proposals
WHERE assignment_id = p_assignment_id
AND change_date between p_start_date and p_end_date;
SELECT 'Y'
FROM hr_assignment_sets aset
WHERE aset.assignment_set_name = c_assignmentset_name
and nvl(aset.payroll_id,c_payroll_id) = c_payroll_id
and aset.business_group_id = c_business_group_id
and (not exists
(select 1
from hr_assignment_set_amendments hasa
where hasa.assignment_set_id = aset.assignment_set_id
and hasa.include_or_exclude = 'I')
or exists
(select 1
from hr_assignment_set_amendments hasa
where hasa.assignment_set_id = aset.assignment_set_id
and hasa.assignment_id = c_assignment_id
and hasa.include_or_exclude = 'I'))
and not exists
(select 1
from hr_assignment_set_amendments hasa
where hasa.assignment_set_id = aset.assignment_set_id
and hasa.assignment_id = c_assignment_id
and hasa.include_or_exclude = 'E') ;
SELECT pba.defined_balance_id
FROM pay_balance_attributes pba,
pay_bal_attribute_definitions pbad
WHERE pba.attribute_id = pbad.attribute_id
AND pba.defined_balance_id = c_defined_balance_id
AND pbad.attribute_name = c_attribute_name
AND ((pba.business_group_id = c_business_group_id and pba.legislation_code is null) or
(pba.legislation_code = hr_bis.get_legislation_code and pba.business_group_id is null));
SELECT pbv.balance_load_date
FROM pay_balance_validation pbv
WHERE pbv.business_group_id = p_business_group_id
AND pbv.defined_balance_id = p_defined_balance_id
AND pbv.run_balance_status = 'V' ;
SELECT max(balance_load_date) balance_load_date
FROM pay_balance_validation pbv,
pay_balance_attributes pba,
pay_bal_attribute_definitions pbad,
pay_defined_balances pdb,
pay_balance_dimensions pbd
WHERE pbv.defined_balance_id = pdb.defined_balance_id
AND pdb.defined_balance_id = pba.defined_balance_id
AND pba.attribute_id = pbad.attribute_id
AND pdb.balance_dimension_id = pbd.balance_dimension_id
AND pbv.business_group_id = c_business_group_id
AND pbad.attribute_name = c_attribute_name
AND pbd.database_item_suffix = c_database_item_suffix
AND pbv.run_balance_status = 'V' ;
select 'Y'
from FND_PRODUCT_INSTALLATIONS
where APPLICATION_ID = 800
and to_number(substr(PRODUCT_VERSION,1,2)) >= 12;
select pettl.element_name
from pay_element_types_f pet,
pay_element_types_f_tl pettl,
pay_element_entries_f pee
where pet.element_type_id = pettl.element_type_id
and pettl.language = userenv('LANG')
and pet.element_type_id = pee.element_type_id
and pee.element_entry_id = p_element_entry_id
and p_retro_run_date between pet.effective_start_date and pet.effective_end_date
and p_payroll_run_date between pee.effective_start_date and pee.effective_end_date;