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_MC_CURRENCY_PKG dependencies on PA_MC_COST_DIST_LINES_ALL

Line 295: FROM pa_mc_cost_dist_lines_all

291: BEGIN
292:
293: SELECT max(line_num)
294: INTO out_line
295: FROM pa_mc_cost_dist_lines_all
296: WHERE expenditure_item_id = x_eiid
297: AND set_of_books_id = x_sob
298: AND line_type||'' = 'R';
299:

Line 347: x_err_stage := ' Select from pa_mc_cost_dist_lines_all';

343: BEGIN
344: l_old_stack := x_err_stack;
345: x_err_code := 0;
346: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_orig_cost_rates';
347: x_err_stage := ' Select from pa_mc_cost_dist_lines_all';
348:
349: SELECT exchange_rate,
350: conversion_date,
351: rate_type

Line 355: FROM pa_mc_cost_dist_lines_all

351: rate_type
352: INTO x_exchange_rate,
353: x_exchange_date,
354: x_exchange_rate_type
355: FROM pa_mc_cost_dist_lines_all
356: WHERE expenditure_item_id = x_adj_item
357: AND line_num = x_line_num
358: AND set_of_books_id = x_set_of_books_id;
359:

Line 443: x_err_stage := ' Select from pa_mc_cost_dist_lines_all';

439:
440: l_old_stack := x_err_stack;
441: x_err_code := 0;
442: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_cost_amts';
443: x_err_stage := ' Select from pa_mc_cost_dist_lines_all';
444:
445: SELECT amount,
446: quantity,
447: exchange_rate,

Line 455: FROM pa_mc_cost_dist_lines_all

451: x_quantity,
452: x_exchange_rate,
453: x_exchange_date,
454: x_exchange_rate_type
455: FROM pa_mc_cost_dist_lines_all
456: WHERE expenditure_item_id = x_exp_item_id
457: AND line_num = x_line_num
458: AND set_of_books_id = x_set_of_books_id;
459:

Line 499: x_err_stage := ' Select from pa_mc_cost_dist_lines_all';

495:
496: l_old_stack := x_err_stack;
497: x_err_code := 0;
498: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_max_cost_amts';
499: x_err_stage := ' Select from pa_mc_cost_dist_lines_all';
500: x_raw_cost := NULL;
501: x_burdened_cost := NULL;
502:
503: SELECT amount,

Line 513: FROM pa_mc_cost_dist_lines_all

509: x_burdened_cost,
510: x_exchange_rate,
511: x_exchange_date,
512: x_exchange_rate_type
513: FROM pa_mc_cost_dist_lines_all
514: WHERE set_of_books_id = x_set_of_books_id
515: AND expenditure_item_id = x_exp_item_id
516: AND line_num = ( select max(line_num)
517: from PA_COST_DISTRIBUTION_LINES_ALL