DBA Data[Home] [Help]

APPS.PA_REVENUE dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 1222: FROM pa_emp_bill_rate_overrides o

1218: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),o.rate_currency_code) r_revenue,
1219: o.rate_currency_code,
1220: 'O',
1221: o.discount_percentage
1222: FROM pa_emp_bill_rate_overrides o
1223: WHERE o.person_id+0 = p_person_id
1224: AND o.task_id = p_task_id
1225: AND p_item_date
1226: BETWEEN o.start_date_active

Line 1387: FROM pa_emp_bill_rate_overrides o2

1383: NVL(p_bill_rate_multiplier,1) * p_quantity),o2.rate_currency_code) r_revenue,
1384: o2.rate_currency_code,
1385: 'O',
1386: o2.discount_percentage
1387: FROM pa_emp_bill_rate_overrides o2
1388: WHERE o2.person_id = p_person_id
1389: AND o2.project_id = p_project_id
1390: AND l_called_process <>2 /*Added for Doosan rate api change */
1391: AND p_item_date