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_COSTING dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 258: pa_cost_distribution_lines_All cdl

254: --, l_agreement_id --FSIO Changes
255: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
256: FROM
257: -- pa_cost_distribution_lines cdl -- 12i MOAC changes
258: pa_cost_distribution_lines_All cdl
259: WHERE cdl.expenditure_item_id = X_expenditure_item_id
260: AND DECODE(p_mode,'INTERFACE',NULL,cdl.line_num_reversed) IS NULL -- Bug 4374769
261: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
262: AND cdl.line_type = X_line_type

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

261: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
262: AND cdl.line_type = X_line_type
263: AND cdl.line_num = DECODE ( p_mode, 'INTERFACE', X_line_num, cdl.line_num) -- Bug 4374769
264: /* Added this Not exists Clause for the bug 5509019 */
265: AND NOT EXISTS (select 1 from pa_cost_distribution_lines_all cdl1
266: where cdl1.expenditure_item_id = cdl.expenditure_item_id
267: and cdl1.line_num_reversed = cdl.line_num
268: and cdl1.transfer_status_code = 'G'
269: and cdl1.line_type = 'I'

Line 341: UPDATE pa_cost_distribution_lines_all

337: /* 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
338: kept as NULL on the original cdl. */
339:
340: If p_mode <> 'INTERFACE' Then
341: UPDATE pa_cost_distribution_lines_all
342: SET reversed_flag = 'Y'
343: WHERE expenditure_item_id = X_expenditure_item_id
344: AND line_num = max_cdl_line_num ;
345: end if;

Line 815: Insert into pa_cost_distribution_lines_All

811: pa_cc_utils.log_message('Gl Accounted Flag['||PA_TRANSACTIONS.GL_ACCOUNTED_FLAG||
812: ']l_gl_date['||l_gl_date||']x_gl_date['||x_gl_date||']');
813:
814: -- Insert into pa_cost_distribution_lines
815: Insert into pa_cost_distribution_lines_All
816: ( line_num
817: , parent_line_num
818: , expenditure_item_id
819: , amount

Line 1439: FROM pa_cost_distribution_lines_All -- 12i MOAC changes

1435: , l_costing_method
1436: /* 12.2 payroll intg .. end */
1437: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
1438: -- FROM pa_cost_distribution_lines -- 12i MOAC changes
1439: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
1440: WHERE expenditure_item_id = X_exp_item_id
1441: -- AND line_num = 1; -- commented for bug2378505
1442: AND line_num = actual_cdl_line_num; -- bug2378505
1443: