[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
from pay_balance_feeds_f feed
,pay_run_result_values target
,pay_run_results rr
,pay_payroll_actions pact
,pay_assignment_actions assact
where feed.balance_type_id = p_bal_id + decode(target.input_value_id,null, 0, 0)
and feed.input_value_id = target.input_value_id
and target.run_result_id = rr.run_result_id
and nvl(target.result_value,'0') <> '0'
and rr.assignment_action_id = assact.assignment_action_id
and assact.payroll_action_id = pact.payroll_action_id
and pact.effective_date between feed.effective_start_date and feed.effective_end_date
and pact.payroll_action_id <> p_payroll_action_id
and rr.status in ('P','PA')
and PACT.effective_date <= p_date
and ASSACT.tax_unit_id = p_tax_id /* Tax Unit */
/* Calendar Bi-Monthly */
and PACT.effective_date >= trunc(Add_months(p_date,MOD(TO_NUMBER(TO_CHAR(p_date,'MM')),2)-1),'MM')
and RR.jurisdiction_code = p_jur_code
and RR.local_unit_id= p_local_unit ;
Select balance_type_id
from pay_balance_types pbt
where pbt.balance_name = p_bal_name
and pbt.legislation_code = 'NO';
select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
from
pay_balance_feeds_f feed
,pay_run_result_values target
,pay_run_results rr
,pay_payroll_actions pact
,pay_assignment_actions assact
,pay_payroll_actions bact
,pay_assignment_actions bal_assact
where bal_assact.assignment_action_id = P_asg_id
and bal_assact.payroll_action_id = bact.payroll_action_id
and feed.balance_type_id = p_bal_id + decode(target.input_value_id,null, 0, 0)
and feed.input_value_id = target.input_value_id
and target.run_result_id = rr.run_result_id
and nvl(target.result_value,'0') <> '0'
and rr.assignment_action_id = assact.assignment_action_id
and assact.payroll_action_id = pact.payroll_action_id
and pact.effective_date between feed.effective_start_date and feed.effective_end_date
and pact.payroll_action_id <> p_payroll_action_id
and rr.status in ('P','PA')
/* Calendar Bi-Monthly */
and PACT.effective_date >= trunc(Add_months(bact.effective_date,MOD(TO_NUMBER(TO_CHAR(bact.effective_date,'MM')),2)-1),'MM')
and assact.action_sequence <= bal_assact.action_sequence
and assact.assignment_id = bal_assact.assignment_id
/* Tax Unit */
and assact.tax_unit_id = p_tax_id
and RR.jurisdiction_code = p_jur_code
and RR.local_unit_id= p_local_unit;
select pact.ASSIGNMENT_ACTION_ID
from pay_assignment_actions pact
,pay_run_types_f prt
where pact.PAYROLL_ACTION_ID = p_payroll_action_id
and pact.TAX_UNIT_ID = p_tax_unit_id
and prt.LEGISLATION_CODE = 'NO'
and prt.RUN_TYPE_NAME = 'Employer Contributions'
and nvl(pact.RUN_TYPE_ID,-99) <> prt.RUN_TYPE_ID
and p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE ;
select count(*)
from pay_assignment_actions pact
,pay_run_types_f prt
where pact.PAYROLL_ACTION_ID = p_payroll_action_id
and pact.TAX_UNIT_ID = p_tax_unit_id
and prt.LEGISLATION_CODE = 'NO'
and prt.RUN_TYPE_NAME = 'Employer Contributions'
and nvl(pact.RUN_TYPE_ID,-99) <> prt.RUN_TYPE_ID
and p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE ;
select last_day(Add_months(p_date_earned,MOD(TO_NUMBER(TO_CHAR(p_date_earned,'MM')),2)))
from dual;
-- insert a new row for exceeded limit
g_tab_calc(8).zone := g_tab_calc(i).zone;
-- finished inserting new row
-- set remaining rows under_limit = N
FOR j IN i+1..7 LOOP
g_tab_calc(j).under_limit := 'N';
-- insert a new row for exceeded limit
g_tab_calc(8).zone := g_tab_calc(i).zone;
-- finished inserting new row
-- set remaining rows under_limit = N
FOR j IN i+1..7 LOOP
g_tab_calc(j).under_limit := 'N';
SELECT pdb.defined_balance_id
INTO l_defined_balance_id
FROM pay_defined_balances pdb
,pay_balance_types pbt
,pay_balance_dimensions pbd
WHERE pbd.database_item_suffix = p_dbi_suffix
AND pbd.legislation_code = 'NO'
AND pbt.balance_name = p_balance_name
AND pbt.legislation_code = 'NO'
AND pdb.balance_type_id = pbt.balance_type_id
AND pdb.balance_dimension_id = pbd.balance_dimension_id
AND pdb.legislation_code = 'NO';
SELECT ELEMENT_TYPE_ID
FROM pay_element_types_f pet
WHERE pet.element_name = 'Tax Deduction Base'
AND pet.LEGISLATION_CODE = 'NO'
AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
SELECT ELEMENT_TYPE_ID
FROM pay_element_types_f pet
WHERE pet.element_name = 'Tax'
AND pet.LEGISLATION_CODE = 'NO'
AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
END IF; -- end IF for inserting Local Unit in l_unique_lu_tab table
select meaning
from hr_lookups
where lookup_type = p_lookup_type
and lookup_code = p_lookup_code
and enabled_flag = 'Y';
-- inserting values in g_tab_main
g_tab_main(l_curr_index).run_base := g_tab_main(l_curr_index).run_base + g_tab_calc(i).run_base ;
select pucf.EFFECTIVE_START_DATE
,pucf.EFFECTIVE_END_DATE
,pucf.VALUE
from pay_user_tables put
,pay_user_rows_f pur
,pay_user_columns puc
,pay_user_column_instances_f pucf
where put.USER_TABLE_NAME = 'NO_GLOBAL_CONSTANTS'
and pur.ROW_LOW_RANGE_OR_NAME = 'NATIONAL_INSURANCE_BASE_RATE'
and puc.USER_COLUMN_NAME = 'Value'
and put.legislation_code = 'NO'
and pur.legislation_code = 'NO'
and puc.legislation_code = 'NO'
and ( pucf.business_group_id = p_bus_grp_id OR pucf.business_group_id is NULL )
and put.user_table_id = pur.user_table_id
and put.user_table_id = puc.user_table_id
and pucf.user_row_id = pur.user_row_id
and pucf.user_column_id = puc.user_column_id
and p_date_earned between pur.effective_start_date and pur.effective_end_date
and pucf.effective_start_date < (trunc(add_months(p_date_earned,12),'Y')-1)
and pucf.effective_end_date > trunc(p_date_earned , 'Y' ) ;
select EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, to_number(global_value) VALUE
from ff_globals_f
where legislation_code = 'NO'
and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
and BUSINESS_GROUP_ID IS NULL
and effective_start_date <= (trunc(add_months(p_date_earned,12),'Y')-1)
and effective_end_date >= trunc(p_date_earned , 'Y' ) ;
select EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, fnd_number.canonical_to_number(global_value) VALUE
from ff_globals_f
where legislation_code = 'NO'
and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
and BUSINESS_GROUP_ID IS NULL
and effective_start_date <= (trunc(add_months(p_date_earned,12),'Y')-1)
and effective_end_date >= trunc(p_date_earned , 'Y' ) ;