APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on GL_SETS_OF_BOOKS

Line 10: x_from_currency OUT NOCOPY gl_sets_of_books.currency_code%TYPE

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)
14: IS

Line 17: gl_sets_of_books gsob

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
18: WHERE repo.org_id = p_org_id
19: AND repo.application_id = 283
20: AND repo.set_of_books_id = gsob.set_of_books_id;
21: BEGIN

Line 30: p_from_currency gl_sets_of_books.currency_code%TYPE,

26: END get_from_currency;
27:
28: PROCEDURE get_conversion_rate
29: (
30: p_from_currency gl_sets_of_books.currency_code%TYPE,
31: p_to_currency gl_sets_of_books.currency_code%TYPE,
32: p_conversion_date DATE,
33: p_conversion_type gl_daily_conversion_types.conversion_type%TYPE,
34: x_rate OUT NOCOPY NUMBER

Line 31: p_to_currency gl_sets_of_books.currency_code%TYPE,

27:
28: PROCEDURE get_conversion_rate
29: (
30: p_from_currency gl_sets_of_books.currency_code%TYPE,
31: p_to_currency gl_sets_of_books.currency_code%TYPE,
32: p_conversion_date DATE,
33: p_conversion_type gl_daily_conversion_types.conversion_type%TYPE,
34: x_rate OUT NOCOPY NUMBER
35: )

Line 176: l_from_currency gl_sets_of_books.currency_code%TYPE;

172:
173: l_rate NUMBER; --conversion rate
174: l_factor NUMBER; --proration factor
175:
176: l_from_currency gl_sets_of_books.currency_code%TYPE;
177: l_conversion_date DATE;
178: l_conversion_type gl_daily_conversion_types.conversion_type%TYPE;
179:
180: l_temp_org_name hr_operating_units.name%TYPE;