118: v_job_id,
119: v_curr_code
120: FROM pa_bill_rates_all b,
121: per_assignments_f pa,
122: pa_std_bill_rate_schedules_all brs
123: WHERE
124: pa.primary_flag = 'Y'
125: -- AND pa.assignment_type = 'E' /* bug 2911451 */
126: AND pa.assignment_type IN ('E','C') -- Modified for CWK impact