eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SYS_PARAMETERS

Line 823: FROM ozf_sys_parameters_all ospa,

819: --Bug# 8632964 fixed by anuj & muthsubr (+)
820: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
821: IS
822: SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
823: FROM ozf_sys_parameters_all ospa,
824: ozf_resale_batches_all orba
825: WHERE ospa.org_id = orba.org_id
826: AND orba.resale_batch_id = p_resale_batch_id;
827:

Line 1472: , ozf_sys_parameters org

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:
1476: BEGIN

Line 1958: FROM ozf_sys_parameters

1954:
1955: -- fix for bug 5042046
1956: CURSOR csr_system_flag IS
1957: SELECT NVL(prorate_earnings_flag, 'F')
1958: FROM ozf_sys_parameters
1959: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1960:
1961: BEGIN
1962: IF OZF_DEBUG_HIGH_ON THEN

Line 2263: , ozf_sys_parameters org

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:
2267: --nepanda Fix for Bug 9075792 - this code is moved to java layer to ClaimAssoVO

Line 3190: , ozf_sys_parameters org

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:
3194: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS

Line 3983: , ozf_sys_parameters org

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:
3987: BEGIN

Line 4420: , ozf_sys_parameters org

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:
4424: BEGIN

Line 4936: FROM ozf_sys_parameters_all

4932:
4933: --Added for bug 7030415
4934: CURSOR c_get_conversion_type IS
4935: SELECT exchange_rate_type
4936: FROM ozf_sys_parameters_all
4937: WHERE org_id = l_currOrgId;
4938:
4939: CURSOR csr_function_currency IS
4940: SELECT gs.currency_code

Line 4942: , ozf_sys_parameters org

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;
4946: l_rate NUMBER;

Line 6280: , ozf_sys_parameters org

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:
6284: BEGIN

Line 6965: FROM ozf_sys_parameters_all

6961: AND c.cust_account_id = cv_cust_account_id;
6962:
6963: CURSOR c_get_conversion_type IS
6964: SELECT exchange_rate_type
6965: FROM ozf_sys_parameters_all
6966: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
6967:
6968: --POS Batch Processing by profiles by rsatyava (+)
6969: l_auto_claim_profile varchar2(1):= FND_PROFILE.value('OZF_AUTO_CLAIM_POS');

Line 7454: FROM ozf_sys_parameters_all

7450: AND c.cust_account_id = cv_cust_account_id;
7451:
7452: CURSOR c_get_conversion_type IS
7453: SELECT exchange_rate_type
7454: FROM ozf_sys_parameters_all
7455: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
7456:
7457: --POS Batch Processing by profiles by rsatyava (+)
7458: l_auto_claim_profile varchar2(1):= FND_PROFILE.value('OZF_AUTO_CLAIM_POS');

Line 8009: FROM ozf_sys_parameters

8005: -- fix for bug 5042046
8006: CURSOR csr_sys_pay_unearned IS
8007: SELECT un_earned_pay_allow_to, un_earned_pay_thold_type
8008: , un_earned_pay_thold_amount, un_earned_pay_thold_flag
8009: FROM ozf_sys_parameters
8010: WHERE org_id = l_currOrgId;
8011:
8012: CURSOR csr_earnings(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
8013: SELECT SUM(DECODE(p_currency_rec.association_currency_code,p_currency_rec.transaction_currency_code, plan_curr_amount,acctd_amount))

Line 9634: , ozf_sys_parameters org

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:
9638: -- Bugfix 5404951

Line 10410: , ozf_sys_parameters org

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:
10414: CURSOR csr_claim_currency(cv_claim_line_id IN NUMBER) IS

Line 11624: FROM ozf_sys_parameters

11620:
11621: -- fix for bug 5042046
11622: CURSOR csr_sys_param_info IS
11623: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag
11624: FROM ozf_sys_parameters
11625: WHERE org_id = l_currOrgId;
11626:
11627: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11628: SELECT fu.plan_id, fu.cust_account_id, sum(lu.acctd_amount)

Line 12153: , ozf_sys_parameters org

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:
12157: --Fix for Bug 10047209