DBA Data[Home] [Help]

APPS.PA_COSTING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 485: from pa_expenditure_items_all

481: /* bug 2891527 */
482: If p_mode = 'VIADJUST' Then
483: select cost_ind_compiled_set_id
484: into p_ind_compiled_set_id
485: from pa_expenditure_items_all
486: where expenditure_item_id = X_expenditure_item_id;
487: end if;
488: /* bug 2891527 */
489:

Line 676: FROM pa_expenditure_items_All ITEMS

672: ,l_recvr_org_id
673: ,l_sys_link_function
674: ,l_exp_id
675: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes
676: FROM pa_expenditure_items_All ITEMS
677: WHERE ITEMS.expenditure_item_id = X_expenditure_item_id;
678:
679: SELECT imp1.set_of_books_id, imp2.set_of_books_id
680: INTO l_sob_id, l_recvr_sob_id

Line 755: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665

751: l_gl_period_name,
752: l_recvr_gl_date,
753: l_recvr_gl_period_name
754: -- From PA_Expenditure_items EI, -- 12i MOAC changes
755: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665
756: PA_Implementations_All IMP */
757: Where EI.expenditure_item_id = X_expenditure_item_id;
758: /* AND NVL(EI.recvr_org_id,EI.ORG_ID) = IMP.org_id; Bug 5353670 / PQE Bug 5248665 */
759:

Line 1225: FROM pa_expenditure_items_All ITEMS,

1221: ,l_sys_link_function
1222: ,l_exp_id
1223: /* bug 2661921*/
1224: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes
1225: FROM pa_expenditure_items_All ITEMS,
1226: pa_transaction_sources TRN
1227: WHERE ITEMS.transaction_source = TRN.transaction_source
1228: AND ITEMS.expenditure_item_id = X_exp_item_id;
1229: