DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 5511: FROm pa_cost_distribution_lines_all cdl

5507: write_log(LOG, G_err_stage);
5508:
5509: SELECT cr_code_combination_id, dr_code_combination_id
5510: INTO l_cr_ccid, l_dr_ccid
5511: FROm pa_cost_distribution_lines_all cdl
5512: WHERE cdl.expenditure_item_id = p_expenditure_item_id
5513: AND cdl.line_num in (select max(line_num)
5514: from pa_cost_distribution_lines_all cdl2
5515: where cdl2.expenditure_item_id = cdl.expenditure_item_id

Line 5514: from pa_cost_distribution_lines_all cdl2

5510: INTO l_cr_ccid, l_dr_ccid
5511: FROm pa_cost_distribution_lines_all cdl
5512: WHERE cdl.expenditure_item_id = p_expenditure_item_id
5513: AND cdl.line_num in (select max(line_num)
5514: from pa_cost_distribution_lines_all cdl2
5515: where cdl2.expenditure_item_id = cdl.expenditure_item_id
5516: and line_type ='R');
5517:
5518: l_prev_exp_item_id := p_expenditure_item_id;

Line 12826: FROM pa_cost_distribution_lines_all cdl,

12822: ,ei.document_line_number
12823: ,cdl.system_reference5 cdl_sys_ref5 --to get the rcv_sub_leger_id of parent Rcv txn
12824: ,ei.cbs_element_id -- Added for CBS Enhancement Bug 16220146
12825: /* ,nvl(ei.net_zero_adjustment_flag,'N') net_zero_adjustment_flag -- Added for for bug#12338132 Commented for 13470521 */
12826: FROM pa_cost_distribution_lines_all cdl,
12827: pa_expenditure_items_all ei
12828: WHERE cdl.expenditure_item_id (+) = ei.expenditure_item_id
12829: AND nvl(cdl.reversed_flag, 'N') = 'N'
12830: AND ei.document_distribution_id = p_document_distribution_id /*Added this for 6945767 */