The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
fnd_number.canonical_to_number(purt.value1) current_balance,
fnd_number.canonical_to_number(purt.value2) previous_balance,
fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
fnd_number.canonical_to_number(purt.attribute2) report_id,
fnd_number.canonical_to_number(purt.attribute3) group_id,
fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
fnd_number.canonical_to_number(purt.attribute5) payroll_id,
fnd_number.canonical_to_number(purt.attribute6) assignment_id,
purt.attribute14 full_name,
purt.attribute7 last_name,
purt.attribute8 first_name,
purt.attribute10 middle_name,
purt.attribute9 national_id,
purt.attribute11 effective_date,
purt.attribute13 assignment_number
FROM pay_us_rpt_totals purt
WHERE organization_id=p_ppa_finder
AND purt.attribute12 = p_ppa_finder
ORDER BY purt.attribute7;
SELECT payroll_name
FROM pay_payrolls_f
WHERE payroll_id=p_payroll_id
AND consolidation_set_id=p_consolidation_set_id
AND (business_group_id = p_business_group_id
OR business_group_id IS NULL)
AND trunc(p_date) between effective_start_date and effective_end_date;
SELECT consolidation_set_name
from pay_consolidation_sets
WHERE consolidation_set_id=p_consolidation_set_id
AND (business_group_id =p_business_group_id
OR business_group_id IS NULL);
SELECT DISTINCT balance_name
FROM pay_balance_types
WHERE balance_type_id=p_balance_type_id;
SELECT Distinct legislation_code,currency_code
FROM per_business_groups
WHERE business_group_id =p_business_group_id;
SELECT variance_value
,comparison_value
,exception_report_name
,output_format
,balance_dimension_id
FROM pqp_exception_reports
WHERE exception_report_id=p_report_id
AND (business_group_id IS NULL
OR business_group_id=p_business_group_id)
AND (legislation_code IS NULL
OR legislation_code=p_legislation_code) ;
SELECT meaning
FROM hr_lookups
WHERE lookup_type='PQP_COMPARISON_TYPE'
AND lookup_code=(
SELECT comparison_type
FROM pqp_exception_reports
WHERE exception_report_id=p_report_id
AND (business_group_id IS NULL
OR business_group_id=p_business_group_id)
AND (legislation_code IS NULL
OR legislation_code=p_legislation_code)) ;
SELECT distinct hrl.meaning
FROM pqp_exception_reports per,
hr_lookups hrl
WHERE per.exception_report_id=p_report_id
AND (per.business_group_id IS NULL
OR per.business_group_id=p_business_group_id)
AND (per.legislation_code IS NULL
OR per.legislation_code=p_legislation_code)
AND hrl.lookup_type = 'PQP_VARIANCE_TYPES'
AND hrl.lookup_code = per.variance_type;
SELECT meaning
FROM HR_LOOKUPS HRL
WHERE HRL.LOOKUP_TYPE = 'PQP_OPERATOR_TYPES'
AND HRL.ENABLED_FLAG = 'Y'
AND LOOKUP_CODE =(
SELECT distinct variance_operator
FROM pqp_exception_reports
WHERE exception_report_id=p_report_id
AND (business_group_id IS NULL
OR business_group_id=p_business_group_id)
AND (legislation_code IS NULL
OR legislation_code=p_legislation_code));
SELECT EXCEPTION_GROUP_NAME
FROM pqp_exception_report_groups
WHERE EXCEPTION_GROUP_ID = p_group_id;
select pbd.dimension_name dimension_name
from pay_balance_dimensions pbd,
pay_defined_balances pdb,
pqp_exception_report_suffix ers
where pbd.database_item_suffix = ers.database_item_suffix
and ers.legislation_code = userenv('LANG')
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pdb.balance_dimension_id = p_dimension_id;
SELECT output_format
FROM pqp_exception_reports
WHERE exception_report_name = p_report_name
AND (business_group_id= p_business_group_id
OR business_group_id IS NULL)
UNION
SELECT DISTINCT output_format
FROM pqp_exception_report_groups
WHERE exception_group_name = p_group_name
AND (business_group_id= p_business_group_id
OR business_group_id IS NULL);
DELETE FROM pay_us_rpt_totals
WHERE organization_id =p_ppa_finder
AND attribute12 = p_ppa_finder;
hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');