[Home] [Help]
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 = 'IN';
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'
);