[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT balance_type_id,
nvl(jurisdiction_level, 999),
balance_uom
FROM pay_balance_types
WHERE upper(balance_name) = upper(l_baltyp_name)
AND ((business_group_id = p_busgrp_id)
OR( business_group_id is null
AND legislation_code = p_leg_code)
OR( business_group_id IS NULL
AND legislation_code IS NULL)
)
FOR UPDATE OF balance_type_id;
SELECT balance_dimension_id
FROM pay_balance_dimensions
WHERE upper(dimension_name) = l_baldim_name
AND ((business_group_id = p_busgrp_id)
OR( business_group_id IS NULL
AND legislation_code = p_leg_code)
OR( business_group_id IS NULL
AND legislation_code IS NULL)
);
select hou.business_group_id,
hou.legislation_code
from per_business_groups hou,
pay_balance_batch_headers bbh
where bbh.batch_id = p_batch_id
and upper(hou.name) = upper(bbh.business_group_name);
select balance_name,
dimension_name
from pay_balance_batch_lines
where batch_id = c_batch_id;
select balance_feed_id
from pay_balance_feeds_f BF,
pay_input_values_f IV,
pay_element_types_f ET,
pay_element_classifications EC
where EC.classification_name = 'Balance Initialization'
and ET.classification_id = EC.classification_id
and IV.element_type_id = ET.element_type_id
and IV.input_value_id = BF.input_value_id
and BF.balance_type_id = p_balance_type_id
and nvl(BF.business_group_id, p_business_group) = p_business_group;
SELECT pbg.business_group_id
,bbh.business_group_name
,pbg.currency_code
,pbg.legislation_code
FROM pay_balance_batch_headers bbh
,per_business_groups pbg
WHERE batch_id = p_batch_id
AND upper(pbg.name) = upper(bbh.business_group_name);
SELECT 1, rule_mode
FROM pay_legislation_rules
WHERE rule_type ='SOURCE_IV'
AND legislation_code = p_leg_code;
SELECT 1, rule_mode
FROM pay_legislation_rules
WHERE rule_type ='SOURCE_TEXT_IV'
AND legislation_code = p_leg_code;
select 1, input_value_name
from pay_legislation_contexts plc, ff_contexts fc
where legislation_code= p_leg_code
and plc.context_id = fc.context_id
and fc.context_name = 'JURISDICTION_CODE';
select 1, input_value_name
from pay_legislation_contexts plc, ff_contexts fc
where legislation_code= p_leg_code
and plc.context_id = fc.context_id
and fc.context_name = 'SOURCE_TEXT2';
update pay_element_types_f ELEM
set ELEM.element_information1 = 'B'
where element_type_id = l_element_type_id;
p_insert_type => 'INSERT_INPUT_VALUE',
p_element_link_id => l_elem_link_id,
p_input_value_id => l_input_val_id,
p_input_value_name => l_jur_iv_val,
p_costable_type => NULL,
p_validation_start_date =>
to_date('01-01-0001','DD-MM-YYYY'),
p_validation_end_date =>
to_date('31-12-4712','DD-MM-YYYY'),
p_default_value => NULL,
p_max_value => NULL,
p_min_value => NULL,
p_warning_or_error_flag => NULL,
p_hot_default_flag => NULL,
p_legislation_code => NULL,
p_pay_value_name => NULL,
p_element_type_id => l_element_type_id);
p_insert_type => 'INSERT_INPUT_VALUE',
p_element_link_id => l_elem_link_id,
p_input_value_id => l_input_val_id,
p_input_value_name => l_source_iv_val,
p_costable_type => NULL,
p_validation_start_date =>
to_date('01-01-0001','DD-MM-YYYY'),
p_validation_end_date =>
to_date('31-12-4712','DD-MM-YYYY'),
p_default_value => NULL,
p_max_value => NULL,
p_min_value => NULL,
p_warning_or_error_flag => NULL,
p_hot_default_flag => NULL,
p_legislation_code => NULL,
p_pay_value_name => NULL,
p_element_type_id => l_element_type_id);
p_insert_type => 'INSERT_INPUT_VALUE',
p_element_link_id => l_elem_link_id,
p_input_value_id => l_input_val_id,
p_input_value_name => l_source_text_iv_val,
p_costable_type => NULL,
p_validation_start_date =>
to_date('01-01-0001','DD-MM-YYYY'),
p_validation_end_date =>
to_date('31-12-4712','DD-MM-YYYY'),
p_default_value => NULL,
p_max_value => NULL,
p_min_value => NULL,
p_warning_or_error_flag => NULL,
p_hot_default_flag => NULL,
p_legislation_code => NULL,
p_pay_value_name => NULL,
p_element_type_id => l_element_type_id);
p_insert_type => 'INSERT_INPUT_VALUE',
p_element_link_id => l_elem_link_id,
p_input_value_id => l_input_val_id,
p_input_value_name => l_source_text2_iv_val,
p_costable_type => NULL,
p_validation_start_date =>
to_date('01-01-0001','DD-MM-YYYY'),
p_validation_end_date =>
to_date('31-12-4712','DD-MM-YYYY'),
p_default_value => NULL,
p_max_value => NULL,
p_min_value => NULL,
p_warning_or_error_flag => NULL,
p_hot_default_flag => NULL,
p_legislation_code => NULL,
p_pay_value_name => NULL,
p_element_type_id => l_element_type_id);
create an input value for each balance_name selected and
name it after the balance it is created for.
*/
l_input_val_id := pay_db_pay_setup.create_input_value (
p_element_name => l_element_name,
p_name =>
substr(l_bal_name, 1, 28)||j,
p_uom_code =>
g_baltyp_tbl_uom(l_bal_count),
p_business_group_name => l_bg_name,
p_effective_start_date =>
to_date('01-01-0001','DD-MM-YYYY'),
p_effective_end_date =>
to_date('31-12-4712','DD-MM-YYYY'),
p_display_sequence => j);
p_insert_type => 'INSERT_INPUT_VALUE',
p_element_link_id => l_elem_link_id,
p_input_value_id => l_input_val_id,
p_input_value_name =>
substr(l_bal_name, 1 , 28)||j,
p_costable_type => NULL,
p_validation_start_date =>
to_date('01-01-0001','DD-MM-YYYY'),
p_validation_end_date =>
to_date('31-12-4712','DD-MM-YYYY'),
p_default_value => NULL,
p_max_value => NULL,
p_min_value => NULL,
p_warning_or_error_flag => NULL,
p_hot_default_flag => NULL,
p_legislation_code => NULL,
p_pay_value_name => NULL,
p_element_type_id => l_element_type_id);