APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on GL_SETS_OF_BOOKS

Line 1471: FROM gl_sets_of_books gs

1467: AND r.request_header_id = cv_request_id;
1468: -- Added For Multi Currency - kpatro (As For Public API this is the starting point)
1469: CURSOR csr_function_currency IS
1470: SELECT gs.currency_code
1471: FROM gl_sets_of_books gs
1472: , ozf_sys_parameters org
1473: WHERE org.set_of_books_id = gs.set_of_books_id
1474: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1475:

Line 2262: FROM gl_sets_of_books gs

2258: WHERE claim_line_util_id = cv_claim_line_util_id;
2259:
2260: CURSOR csr_function_currency(cv_org_id NUMBER) IS
2261: SELECT gs.currency_code
2262: FROM gl_sets_of_books gs
2263: , ozf_sys_parameters org
2264: WHERE org.set_of_books_id = gs.set_of_books_id
2265: AND org.org_id = cv_org_id;
2266:

Line 3189: FROM gl_sets_of_books gs

3185:
3186: -- fix for bug 5042046
3187: CURSOR csr_function_currency IS
3188: SELECT gs.currency_code
3189: FROM gl_sets_of_books gs
3190: , ozf_sys_parameters org
3191: WHERE org.set_of_books_id = gs.set_of_books_id
3192: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3193:

Line 3982: FROM gl_sets_of_books gs

3978: l_currency_rec currency_rec_type;
3979:
3980: CURSOR csr_function_currency IS
3981: SELECT gs.currency_code
3982: FROM gl_sets_of_books gs
3983: , ozf_sys_parameters org
3984: WHERE org.set_of_books_id = gs.set_of_books_id
3985: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3986:

Line 4419: FROM gl_sets_of_books gs

4415:
4416: -- fix for bug 5042046
4417: CURSOR csr_function_currency IS
4418: SELECT gs.currency_code
4419: FROM gl_sets_of_books gs
4420: , ozf_sys_parameters org
4421: WHERE org.set_of_books_id = gs.set_of_books_id
4422: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
4423:

Line 4941: FROM gl_sets_of_books gs

4937: WHERE org_id = l_currOrgId;
4938:
4939: CURSOR csr_function_currency IS
4940: SELECT gs.currency_code
4941: FROM gl_sets_of_books gs
4942: , ozf_sys_parameters org
4943: WHERE org.set_of_books_id = gs.set_of_books_id
4944: AND org.org_id = l_currOrgId;
4945: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

Line 6279: FROM gl_sets_of_books gs

6275: WHERE claim_line_id = cv_claim_line_id
6276: AND claim_id = cv_claim_id;
6277: CURSOR csr_function_currency IS
6278: SELECT gs.currency_code
6279: FROM gl_sets_of_books gs
6280: , ozf_sys_parameters org
6281: WHERE org.set_of_books_id = gs.set_of_books_id
6282: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6283:

Line 9633: FROM gl_sets_of_books gs

9629: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
9630:
9631: CURSOR csr_function_currency(cv_org_id NUMBER) IS
9632: SELECT gs.currency_code
9633: FROM gl_sets_of_books gs
9634: , ozf_sys_parameters org
9635: WHERE org.set_of_books_id = gs.set_of_books_id
9636: AND org.org_id = cv_org_id;
9637:

Line 10409: FROM gl_sets_of_books gs

10405:
10406: -- fix for bug 5042046
10407: CURSOR csr_function_currency IS
10408: SELECT gs.currency_code
10409: FROM gl_sets_of_books gs
10410: , ozf_sys_parameters org
10411: WHERE org.set_of_books_id = gs.set_of_books_id
10412: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
10413:

Line 12152: FROM gl_sets_of_books gs

12148:
12149: --// ER 9226258 : to get the functional currency
12150: CURSOR csr_function_currency IS
12151: SELECT gs.currency_code
12152: FROM gl_sets_of_books gs
12153: , ozf_sys_parameters org
12154: WHERE org.set_of_books_id = gs.set_of_books_id
12155: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
12156: