APPS.PA_COSTING dependencies on PA_IMPLEMENTATIONS_ALL

Line 711: FROM pa_implementations_all imp1, pa_implementations_all imp2

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
711: FROM pa_implementations_all imp1, pa_implementations_all imp2
712: -- start 12i MOAC changes
713: -- WHERE nvl(imp1.org_id,-99) = nvl(l_org_id,-99)
714: -- AND nvl(imp2.org_id,-99) = nvl(l_recvr_org_id,-99);
715: WHERE imp1.org_id = l_org_id

Line 786: PA_Implementations_All IMP */

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:
790: END IF;

Line 1285: FROM pa_implementations_all imp1, pa_implementations_all imp2

1281:
1282: /* selecting set of books id for bug 2661921*/
1283: SELECT imp1.set_of_books_id, imp2.set_of_books_id
1284: INTO l_sob_id, l_recvr_sob_id
1285: FROM pa_implementations_all imp1, pa_implementations_all imp2
1286: -- start 12i MOAC changes
1287: -- WHERE nvl(imp1.org_id,-99) = nvl(l_org_id,-99)
1288: -- AND nvl(imp2.org_id,-99) = nvl(l_recvr_org_id,-99);
1289: WHERE imp1.org_id = l_org_id