[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 balance_name = 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;
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 => 'Jurisdiction',
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 => 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);