APPS.PA_COST dependencies on PA_BILL_RATES_ALL

Line 2029: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

2025:
2026: /* Added for MCB2 */
2027: l_txn_cost_rate NUMBER :=null; -- It will be used to store cost amount transaction curr.
2028: l_txn_cost NUMBER :=null; -- It will be used to store the raw revenue trans. curr.
2029: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
2030: l_denominator Number;
2031: l_numerator Number;
2032: l_status Varchar2(30);
2033: l_converted_cost_amount Number;

Line 2110: FROM pa_bill_rates_all b

2106:
2107: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_cost_rate_multiplier,1)),
2108: (b.rate * NVL(p_cost_rate_multiplier,1) * p_quantity),rate_currency_code
2109: INTO l_x_raw_cost_rate, l_x_raw_cost ,l_rate_currency_code
2110: FROM pa_bill_rates_all b
2111: WHERE b.bill_rate_sch_id = p_job_cost_rate_sch_id
2112: AND b.job_id = px_proj_cost_job_id
2113: AND b.rate is NOT NULL
2114: AND to_date(nvl(to_date(p_schedule_date), to_date(p_item_date))+ 0.99999)