APPS.PA_OUTPUT_TAX dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 544: from pa_expenditure_items_all e1

540: and a.line_num_reversed = b.line_num ;
541:
542: /* CURSOR c_reversal_ei (p_exp_item_id number) IS
543: select adjusted_expenditure_item_id
544: from pa_expenditure_items_all e1
545: where e1.expenditure_item_id = p_Exp_item_id; */
546:
547: CURSOR c_reversal_ei (p_exp_item_id number) IS
548: select b.expenditure_item_id, max(b.line_num ) line_num

Line 549: from pa_expenditure_items_all e1,

545: where e1.expenditure_item_id = p_Exp_item_id; */
546:
547: CURSOR c_reversal_ei (p_exp_item_id number) IS
548: select b.expenditure_item_id, max(b.line_num ) line_num
549: from pa_expenditure_items_all e1,
550: pa_expenditure_items_all e2,
551: PA_CUST_REV_DIST_LINES_ALL b
552: where e1.expenditure_item_id = p_exp_item_id
553: and e1.adjusted_expenditure_item_id is not null

Line 550: pa_expenditure_items_all e2,

546:
547: CURSOR c_reversal_ei (p_exp_item_id number) IS
548: select b.expenditure_item_id, max(b.line_num ) line_num
549: from pa_expenditure_items_all e1,
550: pa_expenditure_items_all e2,
551: PA_CUST_REV_DIST_LINES_ALL b
552: where e1.expenditure_item_id = p_exp_item_id
553: and e1.adjusted_expenditure_item_id is not null
554: and e1.adjusted_expenditure_item_id = e2.expenditure_item_id

Line 1271: Update PA_EXPENDITURE_ITEMS_ALL

1267: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' updateing ei ');
1268: END IF;
1269:
1270:
1271: Update PA_EXPENDITURE_ITEMS_ALL
1272: Set
1273: invproc_rate_type =
1274: DECODE(tmp_status_tab(loop_index),'N',
1275: tmp_invproc_rate_type(loop_index), NULL),