The following lines contain the word 'select', 'insert', 'update' or 'delete':
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 ORG_INFORMATION3
from HR_ORGANIZATION_INFORMATION
where ORGANIZATION_ID = p_tax_unit_id
and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';
select nvl(to_number(ORG_INFORMATION1),0)
from hr_organization_information
where ORGANIZATION_ID = p_org_id
and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);
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(11).zone := g_tab_calc(i).zone;
-- finished inserting new row
-- set remaining rows under_limit = N
FOR j IN i+1..10 LOOP
g_tab_calc(j).under_limit := 'N';
-- insert a new row for exceeded limit
g_tab_calc(11).zone := g_tab_calc(i).zone;
-- finished inserting new row
-- set remaining rows under_limit = N
FOR j IN i+1..10 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 ;
END IF; -- end IF for inserting Local Unit in l_unique_lu_tab table
select date_of_birth
into l_dob
from per_all_people_f pap
,per_all_assignments_f asg
,pay_assignment_actions assact
where assact.ASSIGNMENT_ACTION_ID = p_assignment_action_id
and assact.assignment_id = asg.assignment_id
and p_date_earned between asg.effective_start_date and asg.effective_end_date
and p_date_earned between pap.effective_start_date and pap.effective_end_date
and asg.PERSON_ID = pap.PERSON_ID;
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
, 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' ) ;