APPS.PA_COSTING dependencies on PA_IMPLEMENTATIONS_ALL

Line 681: FROM pa_implementations_all imp1, pa_implementations_all imp2

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
681: FROM pa_implementations_all imp1, pa_implementations_all imp2
682: -- start 12i MOAC changes
683: -- WHERE nvl(imp1.org_id,-99) = nvl(l_org_id,-99)
684: -- AND nvl(imp2.org_id,-99) = nvl(l_recvr_org_id,-99);
685: WHERE imp1.org_id = l_org_id

Line 756: PA_Implementations_All IMP */

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

Line 1233: FROM pa_implementations_all imp1, pa_implementations_all imp2

1229:
1230: /* selecting set of books id for bug 2661921*/
1231: SELECT imp1.set_of_books_id, imp2.set_of_books_id
1232: INTO l_sob_id, l_recvr_sob_id
1233: FROM pa_implementations_all imp1, pa_implementations_all imp2
1234: -- start 12i MOAC changes
1235: -- WHERE nvl(imp1.org_id,-99) = nvl(l_org_id,-99)
1236: -- AND nvl(imp2.org_id,-99) = nvl(l_recvr_org_id,-99);
1237: WHERE imp1.org_id = l_org_id