APPS.PA_FORECAST_COST dependencies on PA_BILL_RATES

Line 1518: FROM pa_bill_rates b

1514: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_cost_rate_multiplier,1)),
1515: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_cost_rate_multiplier,1)
1516: * p_quantity)
1517: INTO l_x_raw_cost_rate, l_x_raw_cost
1518: FROM pa_bill_rates b
1519: WHERE b.bill_rate_sch_id = p_job_cost_rate_sch_id
1520: AND b.job_id = p_proj_cost_job_id
1521: AND b.rate is NOT NULL
1522: AND to_date(nvl(to_date(p_schedule_date, 'YYYY/MM/DD'), to_date(p_item_date, 'YYYY/MM/DD'))+ 0.99999, 'YYYY/MM/DD')