[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT org.org_information1,
org.org_information2,
org.org_information3,
org.org_information4,
org.org_information5,
org.org_information6,
org.org_information7
FROM hr_organization_information_v org
WHERE org.org_information_context = pay_apac_payslip_archive.g_bg_context
AND org.organization_id = p_business_group_id;
SELECT nvl(pbttl.reporting_name,pbttl.balance_name),
pbd.database_item_suffix,
pdb.legislation_code,
pdb.defined_balance_id
FROM pay_balance_types_tl pbttl,
pay_balance_dimensions pbd,
pay_defined_balances pdb
WHERE pdb.balance_type_id = pbttl.balance_type_id
AND pdb.balance_dimension_id = pbd.balance_dimension_id
AND pbttl.balance_type_id = p_balance_type_id
AND pbd.balance_dimension_id = p_balance_dimension_id
AND pbttl.language = userenv('LANG');
SELECT nvl(pettl.reporting_name,pettl.element_name)
FROM pay_element_types_f_tl pettl,
pay_element_types_f pet
WHERE pet.element_type_id = p_element_type_id
AND pettl.element_type_id = pet.element_type_id
AND pettl.language = userenv('LANG')
AND p_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
SELECT piv.uom,
pivtl.name
FROM pay_input_values_f piv,
pay_input_values_f_tl pivtl
WHERE piv.input_value_id = p_input_value_id
AND pivtl.input_value_id = piv.input_value_id
AND pivtl.language = userenv('LANG')
AND p_effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date;
SELECT tax_unit_id
FROM pay_assignment_actions
WHERE assignment_action_id = p_run_assignment_action_id;
select distinct CONTEXT.result_value
from pay_run_result_values CONTEXT
,pay_input_values_f PIVF
,pay_run_results RR
,pay_payroll_actions PACT,
pay_assignment_actions paa
where CONTEXT.run_result_id = RR.run_result_id
and CONTEXT.input_value_id = PIVF.input_value_id
and PIVF.name = 'Source'
and paa.assignment_action_id= p_run_assignment_action_id
and paa.assignment_action_id=RR.assignment_action_id
and paa.payroll_action_id=pact.payroll_action_id
and PACT.effective_date between PIVF.effective_start_date and PIVF.effective_end_date;
SELECT pac.assignment_action_id
,pac.source_action_id
FROM pay_action_interlocks pai
,pay_assignment_actions pac
,pay_payroll_Actions ppa
WHERE pai.locking_action_id = p_pre_assignment_action_id
AND pai.locked_action_id = pac.assignment_action_id
AND ppa.payroll_action_id = pac.payroll_action_id
AND (ppa.run_type_id IS NULL
OR
(ppa.run_type_id IS not NULL
and pac.source_action_id IS NOT NULL)) --Bug:3731940 Because run results are not queried for master record
ORDER BY pac.assignment_action_id DESC;
SELECT action_information1
FROM pay_action_information
WHERE action_context_id = p_arch_assignment_action_id
AND action_information_category = 'APAC ELEMENTS'
AND action_context_type = 'AAP';
SELECT nvl(reporting_name,element_name)
FROM pay_element_types_f
WHERE element_type_id = p_element_type_id
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT substr(uom,1,1) uom,
name
FROM pay_input_values_f
WHERE input_value_id = p_input_value_id
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT prv.result_value value
FROM pay_run_result_values prv,
pay_run_results prr
WHERE prr.status IN ('P','PA')
AND prv.run_result_id = prr.run_result_id
AND prr.assignment_action_id = p_assignment_action_id
AND prr.element_type_id = p_element_type_id
AND prv.input_value_id = p_input_value_id
AND prv.result_value IS NOT NULL;
SELECT sum(fnd_number.canonical_to_number(prv.result_value)) value/*Bug 3228928*/
FROM pay_run_result_values prv,
pay_run_results prr
WHERE prr.status IN ('P','PA')
AND prv.run_result_id = prr.run_result_id
AND prr.assignment_action_id = p_assignment_action_id
AND prr.element_type_id = p_element_type_id
AND prv.input_value_id = p_input_value_id
AND prv.result_value IS NOT NULL;
SELECT ppa.payroll_action_id payroll_action_id
,ppa.effective_date run_effective_date
,ppa.date_earned date_earned
,ppa.pay_advice_message payroll_message
FROM pay_payrolls_f pp,
pay_payroll_actions ppa
WHERE ppa.payroll_id = p_payroll_id
AND ppa.effective_date BETWEEN p_start_date
AND p_end_date
AND (ppa.action_type = 'R' OR
ppa.action_type = 'Q' )
AND ppa.action_status = 'C'
AND ppa.payroll_id = pp.payroll_id
AND NOT EXISTS (SELECT NULL
FROM pay_action_information pai
WHERE pai.action_context_id = ppa.payroll_action_id
AND pai.action_context_type = 'PA'
AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION');
SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
FROM pay_payroll_actions ppa
WHERE ppa.payroll_action_id = p_payroll_action_id;
SELECT 1
FROM pay_action_information
WHERE action_context_id = p_payroll_action_id
AND action_context_type = 'PA'
AND action_information_category IN('EMEA BALANCE DEFINITION'
,'EMEA ELEMENT DEFINITION'
,'EMPLOYEE OTHER INFORMATION'
,'ADDRESS DETAILS'
);