[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select puci.value
from pay_user_column_instances_f puci,
pay_user_columns puc,
pay_user_rows_f pur,
pay_user_tables put
where put.user_table_id = l_user_table_id
and pur.user_table_id = put.user_table_id
and l_effective_date
between pur.effective_start_date and pur.effective_end_date
and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
and decode(put.user_key_units,
'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),
'N', pur.row_low_range_or_name,
'T', pur.row_low_range_or_name,
null)
=
decode(put.user_key_units,
'D', to_char(fnd_date.canonical_to_date(p_row_value)),
'N', p_row_value,
'T', p_row_value,
null)
and puc.user_table_id = put.user_table_id
and puc.user_column_name = p_column_name
and nvl(puc.business_group_id, p_business_group_id) = p_business_group_id
and nvl(puc.legislation_code, l_legislation_code) = l_legislation_code
and puci.user_row_id = pur.user_row_id
and puci.user_column_id = puc.user_column_id
and l_effective_date
between puci.effective_start_date and puci.effective_end_date;
select puci.value
from pay_user_column_instances_f puci,
pay_user_columns puc,
pay_user_rows_f pur,
pay_user_tables put
where put.user_table_id = l_user_table_id
and put.user_key_units = 'N'
and pur.user_table_id = put.user_table_id
and l_effective_date
between pur.effective_start_date and pur.effective_end_date
and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
and fnd_number.canonical_to_number(p_row_value)
between fnd_number.canonical_to_number(pur.row_low_range_or_name)
and fnd_number.canonical_to_number(pur.row_high_range)
and puc.user_table_id = put.user_table_id
and puc.user_column_name = p_column_name
and nvl(puc.business_group_id, p_business_group_id) = p_business_group_id
and nvl(puc.legislation_code, l_legislation_code) = l_legislation_code
and puci.user_row_id = pur.user_row_id
and puci.user_column_id = puc.user_column_id
and l_effective_date
between puci.effective_start_date and puci.effective_end_date;
select effective_date
into l_effective_date
from fnd_sessions
where session_id = userenv('sessionid');
select legislation_code
into l_legislation_code
from per_business_groups
where business_group_id = p_business_group_id;
select range_or_match,
user_table_id
into l_range_or_match,
l_user_table_id
from pay_user_tables
where user_table_name = p_table_name
and nvl(business_group_id, p_business_group_id) = p_business_group_id
and nvl(legislation_code, l_legislation_code) = l_legislation_code;
select 'Y'
from pay_user_column_instances_f i,
pay_user_rows_f r,
pay_user_columns c,
pay_user_tables t
where t.legislation_code ='JP'
and t.business_group_id is null
and t.user_table_name = p_table_name
and c.legislation_code = 'JP'
and c.business_group_id is null
and c.user_table_id = t.user_table_id
and c.user_column_name = p_column_name
and r.user_table_id = t.user_table_id
and p_effective_date between r.effective_start_date and r.effective_end_date
and r.legislation_code = 'JP'
and r.business_group_id is null
and p_effective_date between i.effective_start_date and i.effective_end_date
and i.user_row_id = r.user_row_id
and i.user_column_id = c.user_column_id
and i.value = p_value
;
SELECT parameter_value FROM hr_jp_parameters
WHERE owner = p_owner
AND parameter_name = p_parameter_name;
select global_value
from ff_globals_f
where global_name = p_global_name
and nvl(legislation_code,g_legislation_code) = g_legislation_code
and nvl(business_group_id,p_business_group_id) = p_business_group_id
and l_effective_date
between effective_start_date and effective_end_date;
select effective_date
into g_effective_date
from fnd_sessions
where session_id = g_session_id;
g_glb_tbl.delete;
g_glb_tbl.delete;
select legislation_code
into g_legislation_code
from per_business_groups_perf
where business_group_id = g_business_group_id;