APPS.PA_CLIENT_EXTN_ASGMT_APPRVL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

 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;