DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 4355: FROm pa_cost_distribution_lines_all cdl

4351: write_log(LOG, G_err_stage);
4352:
4353: SELECT cr_code_combination_id, dr_code_combination_id
4354: INTO l_cr_ccid, l_dr_ccid
4355: FROm pa_cost_distribution_lines_all cdl
4356: WHERE cdl.expenditure_item_id = p_expenditure_item_id
4357: AND cdl.line_num in (select max(line_num)
4358: from pa_cost_distribution_lines_all cdl2
4359: where cdl2.expenditure_item_id = cdl.expenditure_item_id

Line 4358: from pa_cost_distribution_lines_all cdl2

4354: INTO l_cr_ccid, l_dr_ccid
4355: FROm pa_cost_distribution_lines_all cdl
4356: WHERE cdl.expenditure_item_id = p_expenditure_item_id
4357: AND cdl.line_num in (select max(line_num)
4358: from pa_cost_distribution_lines_all cdl2
4359: where cdl2.expenditure_item_id = cdl.expenditure_item_id
4360: and line_type ='R');
4361:
4362: l_prev_exp_item_id := p_expenditure_item_id;

Line 11063: FROM pa_cost_distribution_lines_all cdl,

11059: ,ei.document_distribution_id
11060: ,ei.document_payment_id
11061: ,ei.document_line_number
11062: ,cdl.system_reference5 cdl_sys_ref5 --to get the rcv_sub_leger_id of parent Rcv txn
11063: FROM pa_cost_distribution_lines_all cdl,
11064: pa_expenditure_items_all ei
11065: WHERE cdl.expenditure_item_id (+) = ei.expenditure_item_id
11066: AND nvl(cdl.reversed_flag, 'N') = 'N'
11067: AND ei.document_distribution_id = p_document_distribution_id /*Added this for 6945767 */