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:
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;