The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,p_assignment_action_id),0)
FROM pay_balance_dimensions pbd
,pay_defined_balances pdb
,pay_balance_types pbt
WHERE pbt.balance_name = p_balance_name
AND pbd.dimension_name = p_dimension_name
AND pbt.balance_type_id = pdb.balance_type_id
AND pbd.balance_dimension_id = pdb.balance_dimension_id
AND pbt.legislation_code = 'CN';
SELECT fnd_number.canonical_to_number(prrv.result_value)
FROM pay_assignment_actions paa
,pay_payroll_actions ppa
,pay_element_types_f pet
,pay_input_values_f piv
,pay_run_results prr
,pay_run_result_values prrv
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND ppa.action_type IN ('Q','R')
AND ppa.action_status = 'C'
AND paa.assignment_action_id = prr.assignment_action_id
AND pet.element_name = p_element_name
AND pet.legislation_code = 'CN'
AND pet.element_type_id = prr.element_type_id
AND prr.run_result_id = prrv.run_result_id
AND prr.status in ('P','PA')
AND pet.element_type_id = piv.element_type_id
AND piv.name = p_input_value_name
AND piv.input_value_id = prrv.input_value_id
AND ppa.effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date
AND ppa.effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
SELECT gdr.conversion_rate
FROM gl_daily_rates gdr
,gl_daily_conversion_types gdct
WHERE gdr.conversion_type = gdct.conversion_type
AND gdr.from_currency = p_from_currency
AND gdr.to_currency = p_to_currency
AND gdr.conversion_date = p_eff_date
AND gdct.user_conversion_type = (
SELECT puci.value
FROM pay_user_column_instances_f puci
,pay_user_rows_f pur
,pay_user_columns puc
,pay_user_tables put
WHERE puci.user_row_id = pur.user_row_id
AND puci.user_column_id = puc.user_column_id
AND pur.user_table_id = put.user_table_id
AND puc.user_table_id = put.user_table_id
AND puci.business_group_id = p_business_group_id
AND pur.ROW_LOW_RANGE_OR_NAME = 'PAY'
AND put.user_table_name = 'EXCHANGE_RATE_TYPES'
);
SELECT fcu.currency_code
FROM hr_organization_information hoi,
hr_organization_units hou,
fnd_currencies fcu
WHERE hou.business_group_id = p_business_group_id
AND hou.organization_id = hoi.organization_id
AND hoi.org_information_context = 'Business Group Information'
AND fcu.issuing_territory_code = hoi.org_information9;