The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'N'
FROM pa_project_assignments ppa,
pa_assignments_history pah,
pa_work_types_b wtv1,
pa_work_types_b wtv2
WHERE ppa.assignment_id = p_assignment_id
AND pah.assignment_id = p_assignment_id
AND pah.last_approved_flag = 'Y'
AND ppa.start_date = pah.start_date
AND ppa.end_date = pah.end_date
AND (ppa.work_type_id = pah.work_type_id
OR (ppa.work_type_id <> pah.work_type_id
AND wtv1.work_type_id = ppa.work_type_id
AND wtv2.work_type_id = pah.work_type_id
AND wtv1.BILLABLE_CAPITALIZABLE_FLAG = wtv2.BILLABLE_CAPITALIZABLE_FLAG
AND wtv1.RES_UTILIZATION_PERCENTAGE = wtv2.RES_UTILIZATION_PERCENTAGE
AND wtv1.ORG_UTILIZATION_PERCENTAGE = wtv2.ORG_UTILIZATION_PERCENTAGE
)
)
-- Included NVL condition for the below four conditions for Bug#3960313
AND nvl(ppa.tp_rate_override, -99) = nvl(pah.tp_rate_override, -99)
AND nvl(ppa.tp_currency_override, '-99') = nvl(pah.tp_currency_override, '-99')
AND nvl(ppa.tp_calc_base_code_override, '-99') = nvl(pah.tp_calc_base_code_override, '-99')
AND nvl(ppa.tp_percent_applied_override, -99) = nvl(pah.tp_percent_applied_override, -99)
AND rownum = 1;