APPS.PA_COST dependencies on PA_BILL_RATES_ALL

Line 2062: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

2058:
2059: /* Added for MCB2 */
2060: l_txn_cost_rate NUMBER :=null; -- It will be used to store cost amount transaction curr.
2061: l_txn_cost NUMBER :=null; -- It will be used to store the raw revenue trans. curr.
2062: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
2063: l_denominator Number;
2064: l_numerator Number;
2065: l_status Varchar2(30);
2066: l_converted_cost_amount Number;

Line 2143: FROM pa_bill_rates_all b

2139:
2140: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_cost_rate_multiplier,1)),
2141: (b.rate * NVL(p_cost_rate_multiplier,1) * p_quantity),rate_currency_code
2142: INTO l_x_raw_cost_rate, l_x_raw_cost ,l_rate_currency_code
2143: FROM pa_bill_rates_all b
2144: WHERE b.bill_rate_sch_id = p_job_cost_rate_sch_id
2145: AND b.job_id = px_proj_cost_job_id
2146: AND b.rate is NOT NULL
2147: AND to_date(nvl(to_date(p_schedule_date), to_date(p_item_date))+ 0.99999)