2391: x_last_update_login,
2392: x_end_date,
2393: x_period_name,
2394: x_quantity,
2395: pa_currency.round_currency_amt(x_raw_cost),
2396: pa_currency.round_currency_amt(x_burdened_cost),
2397: pa_currency.round_currency_amt(x_revenue),
2398: x_change_reason_code,
2399: x_description,
2392: x_end_date,
2393: x_period_name,
2394: x_quantity,
2395: pa_currency.round_currency_amt(x_raw_cost),
2396: pa_currency.round_currency_amt(x_burdened_cost),
2397: pa_currency.round_currency_amt(x_revenue),
2398: x_change_reason_code,
2399: x_description,
2400: x_attribute_category,
2393: x_period_name,
2394: x_quantity,
2395: pa_currency.round_currency_amt(x_raw_cost),
2396: pa_currency.round_currency_amt(x_burdened_cost),
2397: pa_currency.round_currency_amt(x_revenue),
2398: x_change_reason_code,
2399: x_description,
2400: x_attribute_category,
2401: x_attribute1,
2569: (select sum(nvl(to_number(decode(a.track_as_labor_flag,
2570: 'Y', l.quantity, NULL)),0)),
2571: -- decode(a.track_as_labor_flag, 'Y', a.unit_of_measure, NULL),
2572: 'HOURS', -- V4 uses HOURS as the only labor unit
2573: pa_currency.round_currency_amt(sum(nvl(l.raw_cost, 0))),
2574: pa_currency.round_currency_amt(sum(nvl(l.burdened_cost, 0))),
2575: pa_currency.round_currency_amt(sum(nvl(l.revenue, 0))),
2576: SYSDATE,
2577: x_created_by,
2570: 'Y', l.quantity, NULL)),0)),
2571: -- decode(a.track_as_labor_flag, 'Y', a.unit_of_measure, NULL),
2572: 'HOURS', -- V4 uses HOURS as the only labor unit
2573: pa_currency.round_currency_amt(sum(nvl(l.raw_cost, 0))),
2574: pa_currency.round_currency_amt(sum(nvl(l.burdened_cost, 0))),
2575: pa_currency.round_currency_amt(sum(nvl(l.revenue, 0))),
2576: SYSDATE,
2577: x_created_by,
2578: x_last_update_login
2571: -- decode(a.track_as_labor_flag, 'Y', a.unit_of_measure, NULL),
2572: 'HOURS', -- V4 uses HOURS as the only labor unit
2573: pa_currency.round_currency_amt(sum(nvl(l.raw_cost, 0))),
2574: pa_currency.round_currency_amt(sum(nvl(l.burdened_cost, 0))),
2575: pa_currency.round_currency_amt(sum(nvl(l.revenue, 0))),
2576: SYSDATE,
2577: x_created_by,
2578: x_last_update_login
2579: from pa_resource_assignments a,
3692: Function Check_Currency_Uom (x_uom_code in varchar2)
3693: return varchar2 is
3694: cursor check_uom is
3695: select currency_uom_flag
3696: from pa_currency_uom_v
3697: where uom_code = x_uom_code;
3698:
3699: v_currency_uom_flag varchar2(1);
3700: