1199: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),o.rate_currency_code) r_revenue,
1200: o.rate_currency_code,
1201: 'O',
1202: o.discount_percentage
1203: FROM pa_emp_bill_rate_overrides o
1204: WHERE o.person_id+0 = p_person_id
1205: AND o.task_id = p_task_id
1206: AND p_item_date
1207: BETWEEN o.start_date_active
1364: NVL(p_bill_rate_multiplier,1) * p_quantity),o2.rate_currency_code) r_revenue,
1365: o2.rate_currency_code,
1366: 'O',
1367: o2.discount_percentage
1368: FROM pa_emp_bill_rate_overrides o2
1369: WHERE o2.person_id = p_person_id
1370: AND o2.project_id = p_project_id
1371: AND l_called_process <>2 /*Added for Doosan rate api change */
1372: AND p_item_date