APPS.PA_COSTING dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 251: pa_cost_distribution_lines_All cdl

247: , p_sys_reference5
248: , l_si_assets_addition_flag
249: FROM
250: -- pa_cost_distribution_lines cdl -- 12i MOAC changes
251: pa_cost_distribution_lines_All cdl
252: WHERE cdl.expenditure_item_id = X_expenditure_item_id
253: AND DECODE(p_mode,'INTERFACE',NULL,cdl.line_num_reversed) IS NULL -- Bug 4374769
254: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
255: AND cdl.line_type = X_line_type

Line 258: AND NOT EXISTS (select 1 from pa_cost_distribution_lines_all cdl1

254: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
255: AND cdl.line_type = X_line_type
256: AND cdl.line_num = DECODE ( p_mode, 'INTERFACE', X_line_num, cdl.line_num) -- Bug 4374769
257: /* Added this Not exists Clause for the bug 5509019 */
258: AND NOT EXISTS (select 1 from pa_cost_distribution_lines_all cdl1
259: where cdl1.expenditure_item_id = cdl.expenditure_item_id
260: and cdl1.line_num_reversed = cdl.line_num
261: and cdl1.transfer_status_code = 'G'
262: and cdl1.line_type = 'I'

Line 328: UPDATE pa_cost_distribution_lines_all

324: /* Bug 4374769 : If p_mode is 'INTERFACE' i.e if the reversing and new cdls are created because of PJI summarization then the reversed_flag is
325: kept as NULL on the original cdl. */
326:
327: If p_mode <> 'INTERFACE' Then
328: UPDATE pa_cost_distribution_lines_all
329: SET reversed_flag = 'Y'
330: WHERE expenditure_item_id = X_expenditure_item_id
331: AND line_num = max_cdl_line_num ;
332: end if;

Line 785: Insert into pa_cost_distribution_lines_All

781: pa_cc_utils.log_message('Gl Accounted Flag['||PA_TRANSACTIONS.GL_ACCOUNTED_FLAG||
782: ']l_gl_date['||l_gl_date||']x_gl_date['||x_gl_date||']');
783:
784: -- Insert into pa_cost_distribution_lines
785: Insert into pa_cost_distribution_lines_All
786: ( line_num
787: , parent_line_num
788: , expenditure_item_id
789: , amount

Line 1377: FROM pa_cost_distribution_lines_All -- 12i MOAC changes

1373: , p_cdlsr4
1374: , p_cdlsr5
1375: , l_si_assets_addition_flag
1376: -- FROM pa_cost_distribution_lines -- 12i MOAC changes
1377: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
1378: WHERE expenditure_item_id = X_exp_item_id
1379: -- AND line_num = 1; -- commented for bug2378505
1380: AND line_num = actual_cdl_line_num; -- bug2378505
1381: