DBA Data[Home] [Help]

APPS.PA_COSTING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 501: from pa_expenditure_items_all

497: /* bug 2891527 */
498: If p_mode = 'VIADJUST' Then
499: select cost_ind_compiled_set_id
500: into p_ind_compiled_set_id
501: from pa_expenditure_items_all
502: where expenditure_item_id = X_expenditure_item_id;
503: end if;
504: /* bug 2891527 */
505:

Line 706: FROM pa_expenditure_items_All ITEMS

702: ,l_recvr_org_id
703: ,l_sys_link_function
704: ,l_exp_id
705: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes
706: FROM pa_expenditure_items_All ITEMS
707: WHERE ITEMS.expenditure_item_id = X_expenditure_item_id;
708:
709: SELECT imp1.set_of_books_id, imp2.set_of_books_id
710: INTO l_sob_id, l_recvr_sob_id

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

781: l_gl_period_name,
782: l_recvr_gl_date,
783: l_recvr_gl_period_name
784: -- From PA_Expenditure_items EI, -- 12i MOAC changes
785: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665
786: PA_Implementations_All IMP */
787: Where EI.expenditure_item_id = X_expenditure_item_id;
788: /* AND NVL(EI.recvr_org_id,EI.ORG_ID) = IMP.org_id; Bug 5353670 / PQE Bug 5248665 */
789:

Line 1277: FROM pa_expenditure_items_All ITEMS,

1273: ,l_sys_link_function
1274: ,l_exp_id
1275: /* bug 2661921*/
1276: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes
1277: FROM pa_expenditure_items_All ITEMS,
1278: pa_transaction_sources TRN
1279: WHERE ITEMS.transaction_source = TRN.transaction_source
1280: AND ITEMS.expenditure_item_id = X_exp_item_id;
1281: