eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on STANDARD

Line 496: NVL(bl.txn_cost_rate_override,bl.txn_standard_cost_rate),

492: l_module_name VARCHAR2(100);
493:
494: CURSOR bl_rates_cur (c_res_asg_id PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE) IS
495: SELECT bl.period_name,
496: NVL(bl.txn_cost_rate_override,bl.txn_standard_cost_rate),
497: NVL(bl.burden_cost_rate_override,bl.burden_cost_rate),
498: NVL(bl.txn_bill_rate_override,bl.txn_standard_bill_rate)
499: FROM pa_budget_lines bl
500: WHERE bl.resource_assignment_id = c_res_asg_id

Line 498: NVL(bl.txn_bill_rate_override,bl.txn_standard_bill_rate)

494: CURSOR bl_rates_cur (c_res_asg_id PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE) IS
495: SELECT bl.period_name,
496: NVL(bl.txn_cost_rate_override,bl.txn_standard_cost_rate),
497: NVL(bl.burden_cost_rate_override,bl.burden_cost_rate),
498: NVL(bl.txn_bill_rate_override,bl.txn_standard_bill_rate)
499: FROM pa_budget_lines bl
500: WHERE bl.resource_assignment_id = c_res_asg_id
501: AND bl.txn_currency_code = p_txn_currency_code;
502:

Line 4467: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,

4463: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4464: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4465: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4466: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4467: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4468: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4469: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4470: disp_quantity pa_budget_lines.display_quantity%TYPE);
4471:

Line 4469: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,

4465: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4466: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4467: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4468: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4469: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4470: disp_quantity pa_budget_lines.display_quantity%TYPE);
4471:
4472:
4473: TYPE l_ra_id_tbl_prest is TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 4868: ,NVL(pbl.txn_cost_rate_override,pbl.txn_standard_cost_rate)

4864: END IF;
4865:
4866: SELECT
4867: pbl.period_name
4868: ,NVL(pbl.txn_cost_rate_override,pbl.txn_standard_cost_rate)
4869: ,NVL(pbl.burden_cost_rate_override,pbl.burden_cost_rate)
4870: ,NVL(pbl.txn_bill_rate_override,pbl.txn_standard_bill_rate)
4871: ,pbl.quantity
4872: ,pbl.start_date

Line 4870: ,NVL(pbl.txn_bill_rate_override,pbl.txn_standard_bill_rate)

4866: SELECT
4867: pbl.period_name
4868: ,NVL(pbl.txn_cost_rate_override,pbl.txn_standard_cost_rate)
4869: ,NVL(pbl.burden_cost_rate_override,pbl.burden_cost_rate)
4870: ,NVL(pbl.txn_bill_rate_override,pbl.txn_standard_bill_rate)
4871: ,pbl.quantity
4872: ,pbl.start_date
4873: ,pbl.end_date
4874: ,pbl.txn_raw_cost