DBA Data[Home] [Help]

APPS.PA_REVENUE dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 1203: FROM pa_emp_bill_rate_overrides o

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

Line 1368: FROM pa_emp_bill_rate_overrides o2

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