APPS.PA_MC_CURRENCY_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 517: from PA_COST_DISTRIBUTION_LINES_ALL

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
518: where expenditure_item_id = x_exp_item_id
519: and line_type = 'R' );
520:
521: x_err_stack := l_old_stack;

Line 1010: x_err_stage := ' Select from pa_cost_distribution_lines_all';

1006:
1007: l_old_stack := x_err_stack;
1008: x_err_code := 0;
1009: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_ap_keys';
1010: x_err_stage := ' Select from pa_cost_distribution_lines_all';
1011:
1012:
1013: SELECT cdl.system_reference2,
1014: cdl.system_reference3

Line 1017: FROM pa_cost_distribution_lines_all cdl

1013: SELECT cdl.system_reference2,
1014: cdl.system_reference3
1015: INTO x_ref2, -- invoice id
1016: x_ref3 -- line num
1017: FROM pa_cost_distribution_lines_all cdl
1018: WHERE cdl.expenditure_item_id = x_eiid
1019: AND rownum = 1;
1020:
1021: x_err_stack := l_old_stack;