The following lines contain the word 'select', 'insert', 'update' or 'delete':
(SELECT full_name ,
paa.organization_id,
pap.person_id ,
pap.employee_number,
pav.ADDRESS_LINE1,
pav.TOWN_OR_CITY ,
pav.REGION_2 ,
pav.REGION_1 ,
pav.D_COUNTRY ,
pav.POSTAL_CODE
FROM per_all_assignments_f paa,
per_all_people_f pap,
PER_ADDRESSES_V pav
WHERE paa.person_id = pap.person_id
AND paa.assignment_id = g_assignment_id
and l_direct_dep_date BETWEEN paa.EFFECTIVE_START_DATE AND NVL(paa.EFFECTIVE_END_DATE,l_direct_dep_date)
and pav.person_id = pap.person_id
and l_direct_dep_date BETWEEN pap.EFFECTIVE_START_DATE AND NVL(pap.EFFECTIVE_END_DATE,l_direct_dep_date)
AND (pav.ADDRESS_TYPE = 'IAT'
or (pav.primary_flag = 'Y' ))
and l_direct_dep_date BETWEEN pav.date_from and NVL(pav.date_to,l_direct_dep_date))
order by decode(pav.address_type, 'IAT',1,2);
(SELECT full_name ,
paaf.organization_id,
pap.person_id ,
pap.employee_number,
pav.ADDRESS_LINE1,
pav.TOWN_OR_CITY ,
pav.REGION_2 ,
pav.REGION_1 ,
pav.D_COUNTRY ,
pav.POSTAL_CODE
FROM per_all_assignments_f paaf,
per_all_people_f pap,
pay_pre_payments ppp,
pay_action_interlocks pai,
pay_payroll_actions ppa,
pay_assignment_actions paa,
PER_ADDRESSES_V pav
WHERE paaf.person_id = pap.person_id
AND paaf.assignment_id = g_assignment_id
and ppp.pre_payment_id = l_prepayment_id
and ppp.assignment_action_id = pai.locking_action_id
and pai.locked_action_id = paa.assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.action_type in ('R', 'Q')
and ((paa.source_action_id is not null and ppa.run_type_id is not null) or
(paa.source_action_id is null and ppa.run_type_id is null))
and ppa.effective_date BETWEEN paaf.EFFECTIVE_START_DATE AND NVL(paaf.EFFECTIVE_END_DATE,ppa.effective_date)
and pav.person_id = pap.person_id
and ppa.effective_date BETWEEN pap.EFFECTIVE_START_DATE AND NVL(pap.EFFECTIVE_END_DATE,ppa.effective_date)
AND (pav.ADDRESS_TYPE = 'IAT'
or (pav.primary_flag = 'Y'))
and ppa.effective_date BETWEEN pav.date_from and NVL(pav.date_to,ppa.effective_date))
order by decode(pav.address_type, 'IAT',1,2);
SELECT TO_CHAR(FORMULA_ID) INTO ff_formula_id
FROM FF_FORMULAS_F
WHERE p_effective_date BETWEEN EFFECTIVE_START_DATE AND
EFFECTIVE_END_DATE
AND FORMULA_NAME = p_formula_name;
UPDATE PAY_EXTERNAL_ACCOUNTS a
SET a.PRENOTE_DATE = nvl(to_date(p_direct_dep_date, 'YYMMDD'),
p_effective_date)
WHERE a.PRENOTE_DATE IS NULL
AND a.EXTERNAL_ACCOUNT_ID =
(SELECT b.EXTERNAL_ACCOUNT_ID
FROM PAY_PERSONAL_PAYMENT_METHODS_F b
WHERE b.PERSONAL_PAYMENT_METHOD_ID =
g_personal_payment_method_id
AND p_effective_date BETWEEN b.EFFECTIVE_START_DATE
AND b.EFFECTIVE_END_DATE);
SELECT hou.name ,
hl.ADDRESS_LINE_1,
hl.TOWN_OR_CITY ,
hl.REGION_2 ,
hl.REGION_1 ,
hl.COUNTRY ,
hl.POSTAL_CODE
INTO g_org_name ,
g_street_address,
g_city ,
g_state ,
g_county ,
g_country ,
g_postal_code
FROM hr_organization_units hou,
hr_locations hl
WHERE hou.location_id = hl.location_id
AND hou.organization_id = g_legal_company_id
and p_effective_date between hou.date_from and nvl(hou.date_to,p_effective_date);