The following lines contain the word 'select', 'insert', 'update' or 'delete':
select TP.end_date + 1
into l_return_val
from per_time_periods TP,
pay_payroll_actions PACT
where PACT.payroll_action_id = p_pactid
and PACT.payroll_id = TP.payroll_id
and p_date between TP.start_date and TP.end_date;
SELECT fnd_date.canonical_to_date(org_information11)
INTO l_beg_of_fiscal_year
FROM pay_payroll_actions PACT,
hr_organization_information HOI
WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND HOI.organization_id = PACT.business_group_id
AND PACT.payroll_action_id = p_owner_payroll_action_id;
SELECT fnd_date.canonical_to_date(org_information11)
INTO l_beg_of_fiscal_year
FROM pay_payroll_actions PACT,
hr_organization_information HOI
WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND HOI.organization_id = PACT.business_group_id
AND PACT.payroll_action_id = p_owner_payroll_action_id;
SELECT fnd_date.canonical_to_date(org_information11)
INTO l_beg_of_fiscal_year
FROM pay_payroll_actions PACT,
hr_organization_information HOI
WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND HOI.organization_id = PACT.business_group_id
AND PACT.payroll_action_id = p_owner_payroll_action_id;
SELECT fnd_date.canonical_to_date(org_information11)
INTO l_beg_of_fiscal_year
FROM pay_payroll_actions PACT,
hr_organization_information HOI
WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND HOI.organization_id = PACT.business_group_id
AND PACT.payroll_action_id = p_owner_payroll_action_id;
SELECT dimension_name
FROM pay_defined_balances pdb
, pay_balance_dimensions pbd
WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
AND pdb.defined_balance_id = c_defined_balance_id;
SELECT ppa.payroll_action_id, ppa.effective_date
FROM pay_payroll_actions ppa, pay_assignment_actions paa
WHERE ppa.payroll_action_id = paa.payroll_action_id
AND paa.assignment_action_id = c_assignment_action_id;
SELECT fnd_date.canonical_to_date(org_information11)
INTO l_beg_of_fiscal_year
FROM pay_payroll_actions PACT,
hr_organization_information HOI
WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND HOI.organization_id = PACT.business_group_id
AND PACT.payroll_action_id = l_payroll_action_id;
SELECT fnd_date.canonical_to_date(org_information11)
INTO l_beg_of_fiscal_year
FROM pay_payroll_actions PACT,
hr_organization_information HOI
WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND HOI.organization_id = PACT.business_group_id
AND PACT.payroll_action_id = l_payroll_action_id;