DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 62: pa_implementations_all i

58:
59: SELECT gl.currency_code
60: INTO currency
61: FROM gl_sets_of_books gl,
62: pa_implementations_all i
63: -- WHERE NVL(i.org_id,-99) = NVL(x_org_id,-99)
64: WHERE i.org_id = x_org_id -- x_org_id also taken from Implementation table.
65: AND i.set_of_books_id = gl.set_of_books_id;
66:

Line 96: FROM pa_implementations_all i

92: G_PREV_ORG_ID2 := x_org_id;
93:
94: SELECT set_of_books_id
95: INTO sob_id
96: FROM pa_implementations_all i
97: -- WHERE NVL(i.org_id,-99) = NVL(x_org_id,-99);
98: where i.org_id = x_org_id ;
99:
100: G_PREV_SOB_ID := sob_id;