5: g_credit_type_id CONSTANT NUMBER := -1000;
6:
7: PROCEDURE get_from_currency
8: (
9: p_org_id cn_salesreps.org_id%TYPE,
10: x_from_currency OUT NOCOPY gl_sets_of_books.currency_code%TYPE
11: )
12: IS
13: CURSOR get_source_currency_code(p_org_id cn_salesreps.org_id%TYPE)
9: p_org_id cn_salesreps.org_id%TYPE,
10: x_from_currency OUT NOCOPY gl_sets_of_books.currency_code%TYPE
11: )
12: IS
13: CURSOR get_source_currency_code(p_org_id cn_salesreps.org_id%TYPE)
14: IS
15: SELECT gsob.currency_code from_currency
16: FROM cn_repositories_all repo,
17: gl_sets_of_books gsob