The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT element_type_id,effective_start_date
FROM PAY_ELEMENT_TYPES_F
WHERE ELEMENT_NAME = p_element_name
AND LEGISLATION_CODE = p_legislation_code;
SELECT COUNT(*) INTO l_verify_element_link
FROM PAY_ELEMENT_LINKS_F
WHERE element_type_id = l_element_type_id
AND business_group_id = p_bg_id
AND organization_id is null
AND people_group_id is null
AND job_id is null
AND position_id is null
AND grade_id is null
AND location_id is null
AND employment_category is null
AND payroll_id is null
AND pay_basis_id is null; /* CHECKS MADE TO ENSURE THAT IT IS AN OPEN ELEMENT LINK*/
SELECT i.input_value_id
FROM PAY_INPUT_VALUES_F i,PAY_ELEMENT_TYPES_F e
WHERE i.element_type_id = e.element_type_id
AND i.name = p_input_value_name
AND e.element_name = p_element_name
AND e.legislation_code = p_legislation_code; -- CHANGE THE LEGISLATION CODE ACCORDING TO REQUIREMENT
SELECT rate_id
FROM PAY_RATES
WHERE name = p_rate_name
and business_group_id = p_bg_id;
SELECT COUNT(*) INTO l_verify_salary_basis
FROM PER_PAY_BASES
WHERE name = p_name
AND business_group_id = p_bg_id;
-- Call the API to insert the Salary Basis
HR_SALARY_BASIS_API.CREATE_SALARY_BASIS(P_VALIDATE => false,
P_BUSINESS_GROUP_ID => p_bg_id,
P_INPUT_VALUE_ID => l_input_value_id,
P_RATE_ID => l_rate_id,
P_NAME => l_name,
P_PAY_BASIS => l_pay_basis_name,
P_RATE_BASIS => null,
P_PAY_ANNUALIZATION_FACTOR => l_pay_annualization_factor,
P_GRADE_ANNUALIZATION_FACTOR => l_grade_annualization_factor,
P_ATTRIBUTE_CATEGORY => null,
P_ATTRIBUTE1 => null,
P_ATTRIBUTE2 => null,
P_ATTRIBUTE3 => null,
P_ATTRIBUTE4 => null,
P_ATTRIBUTE5 => null,
P_ATTRIBUTE6 => null,
P_ATTRIBUTE7 => null,
P_ATTRIBUTE8 => null,
P_ATTRIBUTE9 => null,
P_ATTRIBUTE10 => null,
P_ATTRIBUTE11 => null,
P_ATTRIBUTE12 => null,
P_ATTRIBUTE13 => null,
P_ATTRIBUTE14 => null,
P_ATTRIBUTE15 => null,
P_ATTRIBUTE16 => null,
P_ATTRIBUTE17 => null,
P_ATTRIBUTE18 => null,
P_ATTRIBUTE19 => null,
P_ATTRIBUTE20 => null,
P_LAST_UPDATE_DATE => null,
P_LAST_UPDATED_BY => null,
P_LAST_UPDATE_LOGIN => null,
P_CREATED_BY => null,
P_CREATION_DATE => null,
P_INFORMATION_CATEGORY => null,
P_INFORMATION1 => null,
P_INFORMATION2 => null,
P_INFORMATION3 => null,
P_INFORMATION4 => null,
P_INFORMATION5 => null,
P_INFORMATION6 => null,
P_INFORMATION7 => null,
P_INFORMATION8 => null,
P_INFORMATION9 => null,
P_INFORMATION10 => null,
P_INFORMATION11 => null,
P_INFORMATION12 => null,
P_INFORMATION13 => null,
P_INFORMATION14 => null,
P_INFORMATION15 => null,
P_INFORMATION16 => null,
P_INFORMATION17 => null,
P_INFORMATION18 => null,
P_INFORMATION19 => null,
P_INFORMATION20 => null,
P_PAY_BASIS_ID => l_pay_basis_id,
P_OBJECT_VERSION_NUMBER => l_object_version_number);
SELECT c.consolidation_set_id
FROM PAY_CONSOLIDATION_SETS c,PER_BUSINESS_GROUPS b
WHERE b.business_group_id = p_bg_id
AND b.business_group_id = c.business_group_id
AND c.consolidation_set_name = p_consolidation_set_name;
SELECT COUNT(*) INTO l_verify_payroll
FROM PAY_PAYROLLS_F
WHERE payroll_name = p_payroll_name
AND business_group_id = p_bg_id;
SELECT distinct payroll_id into p_payroll_id
FROM PAY_PAYROLLS_F
WHERE payroll_name = p_payroll_name
AND business_group_id = p_bg_id;
SELECT payment_type_id
FROM PAY_PAYMENT_TYPES
WHERE payment_type_name = p_payment_type_name
AND territory_code = p_territory_code;
SELECT currency_code
FROM FND_CURRENCIES
WHERE issuing_territory_code = p_territory_code;
SELECT COUNT(*) INTO l_verify_payment_method
FROM PAY_ORG_PAYMENT_METHODS_F
WHERE org_payment_method_name = p_payment_method_name
AND business_group_id = p_bg_id;
SELECT distinct org_payment_method_id into p_org_payment_method_id
FROM PAY_ORG_PAYMENT_METHODS_F
WHERE org_payment_method_name = p_payment_method_name
AND business_group_id = p_bg_id;
SELECT count(*) into l_reccount
FROM PAY_ORG_PAY_METHOD_USAGES_F
WHERE payroll_id = p_payroll_id
AND org_payment_method_id = p_org_payment_method_id;
PAY_ORG_PAY_METH_USAGES_F_PKG.Insert_Row(X_Rowid => l_rowid
,X_Org_Pay_Method_Usage_Id => l_org_pay_method_usage_id
,X_Effective_Start_Date => p_effective_start_date
,X_Effective_End_Date => l_effective_end_date
,X_Payroll_Id => p_payroll_id
,X_Org_Payment_Method_Id => p_org_payment_method_id);
SELECT COUNT(*) INTO l_verify_org_info
FROM HR_ORGANIZATION_INFORMATION
WHERE organization_id = p_org_id
AND org_information_context = p_org_info_type;
SELECT business_group_id,date_from,name,legislation_code
FROM PER_BUSINESS_GROUPS
WHERE business_group_id is not null
and business_group_id = p_bg_id;
SELECT organization_id
FROM HR_ORGANIZATION_UNITS
WHERE business_group_id = p_bg_id
AND name = p_bg_name;
SELECT element_name
FROM PAY_ELEMENT_TYPES_F
WHERE business_group_id = p_bg_id
AND indirect_only_flag = 'N'
AND legislation_code is not null;
SELECT count(*) as crp_run
FROM per_ri_requests prr,
fnd_concurrent_requests fcr
WHERE business_group_id = p_bg_id
AND SETUP_TASK_CODE = 'GENERATE_DEFAULT_SETTINGS'
AND prr.request_id = fcr.request_id
and status_code = 'C';
Select ahm.api_module_id
, ahk.api_hook_id
From hr_api_hooks ahk
,hr_api_modules ahm
Where ahm.module_name = c_module_name
and ahm.api_module_type = c_api_module_type
and ahk.api_hook_type = c_api_hook_type
and ahk.api_module_id = ahm.api_module_id;
Select hc.api_hook_call_id
From hr_api_hook_calls hc
Where hc.api_hook_id = c_hook_id
and hc.legislation_code Is Null
and hc.call_package = 'PER_RI_CREATE_CRP_EMPLOYEE'
and hc.call_procedure = 'SET_USER_ACCT_DETAILS'
and application_id = 800;
Select text
From hr_api_user_hook_reports
Where session_id = userenv('SESSIONID')
Order By line;