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 111: , ozf_sys_parameters org

107:
108: CURSOR csr_function_currency IS
109: SELECT gs.currency_code
110: FROM gl_sets_of_books gs
111: , ozf_sys_parameters org
112: WHERE org.set_of_books_id = gs.set_of_books_id
113: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
114:
115: l_offr_currency_code VARCHAR2(15);

Line 1640: FROM ozf_sys_parameters

1636:
1637: -- fix for bug 5042046
1638: CURSOR csr_system_flag IS
1639: SELECT NVL(prorate_earnings_flag, 'F')
1640: FROM ozf_sys_parameters
1641: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1642:
1643: BEGIN
1644: IF OZF_DEBUG_HIGH_ON THEN

Line 1914: , ozf_sys_parameters org

1910: -- fix for bug 5042046
1911: CURSOR csr_function_currency IS
1912: SELECT gs.currency_code
1913: FROM gl_sets_of_books gs
1914: , ozf_sys_parameters org
1915: WHERE org.set_of_books_id = gs.set_of_books_id
1916: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1917:
1918: CURSOR csr_claim_exc(cv_claim_line_id IN NUMBER) IS

Line 2223: , ozf_sys_parameters org

2219: -- fix for bug 5042046
2220: CURSOR csr_function_currency IS
2221: SELECT gs.currency_code
2222: FROM gl_sets_of_books gs
2223: , ozf_sys_parameters org
2224: WHERE org.set_of_books_id = gs.set_of_books_id
2225: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
2226:
2227: CURSOR csr_claim_exc(cv_claim_line_id IN NUMBER) IS

Line 2659: , ozf_sys_parameters org

2655: -- fix for bug 5042046
2656: CURSOR csr_function_currency IS
2657: SELECT gs.currency_code
2658: FROM gl_sets_of_books gs
2659: , ozf_sys_parameters org
2660: WHERE org.set_of_books_id = gs.set_of_books_id
2661: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
2662:
2663: BEGIN

Line 2863: , ozf_sys_parameters org

2859: -- fix for bug 5042046
2860: CURSOR csr_function_currency IS
2861: SELECT gs.currency_code
2862: FROM gl_sets_of_books gs
2863: , ozf_sys_parameters org
2864: WHERE org.set_of_books_id = gs.set_of_books_id
2865: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
2866:
2867: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS

Line 3200: , ozf_sys_parameters org

3196: -- fix for bug 5042046
3197: CURSOR csr_function_currency IS
3198: SELECT gs.currency_code
3199: FROM gl_sets_of_books gs
3200: , ozf_sys_parameters org
3201: WHERE org.set_of_books_id = gs.set_of_books_id
3202: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3203:
3204: BEGIN

Line 3395: , ozf_sys_parameters org

3391: -- fix for bug 5042046
3392: CURSOR csr_function_currency IS
3393: SELECT gs.currency_code
3394: FROM gl_sets_of_books gs
3395: , ozf_sys_parameters org
3396: WHERE org.set_of_books_id = gs.set_of_books_id
3397: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3398:
3399: CURSOR csr_final_lu_acctd_amt(cv_claim_line_id IN NUMBER) IS

Line 4040: , ozf_sys_parameters org

4036: -- fix for bug 5042046
4037: CURSOR csr_function_currency IS
4038: SELECT gs.currency_code
4039: FROM gl_sets_of_books gs
4040: , ozf_sys_parameters org
4041: WHERE org.set_of_books_id = gs.set_of_books_id
4042: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
4043:
4044: BEGIN

Line 4522: FROM ozf_sys_parameters_all

4518:
4519: --Added for bug 7030415
4520: CURSOR c_get_conversion_type IS
4521: SELECT exchange_rate_type
4522: FROM ozf_sys_parameters_all
4523: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
4524:
4525: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
4526: l_rate NUMBER;

Line 5888: FROM ozf_sys_parameters_all

5884:
5885: --Added for bug 7030415
5886: CURSOR c_get_conversion_type IS
5887: SELECT exchange_rate_type
5888: FROM ozf_sys_parameters_all
5889: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
5890:
5891: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
5892: l_rate NUMBER;

Line 6322: FROM ozf_sys_parameters

6318: -- fix for bug 5042046
6319: CURSOR csr_sys_pay_unearned IS
6320: SELECT un_earned_pay_allow_to, un_earned_pay_thold_type
6321: , un_earned_pay_thold_amount, un_earned_pay_thold_flag
6322: FROM ozf_sys_parameters
6323: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6324:
6325: CURSOR csr_earnings(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
6326: SELECT SUM(acctd_amount), SUM(acctd_amount_remaining)

Line 6710: , ozf_sys_parameters org

6706: -- fix for bug 5042046
6707: CURSOR csr_function_currency IS
6708: SELECT gs.currency_code
6709: FROM gl_sets_of_books gs
6710: , ozf_sys_parameters org
6711: WHERE org.set_of_books_id = gs.set_of_books_id
6712: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6713:
6714: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS

Line 8074: , ozf_sys_parameters org

8070: -- fix for bug 5042046
8071: CURSOR csr_function_currency IS
8072: SELECT gs.currency_code
8073: FROM gl_sets_of_books gs
8074: , ozf_sys_parameters org
8075: WHERE org.set_of_books_id = gs.set_of_books_id
8076: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
8077:
8078: CURSOR csr_claim_currency(cv_claim_line_id IN NUMBER) IS

Line 9131: , ozf_sys_parameters org

9127:
9128: CURSOR csr_function_currency IS
9129: SELECT gs.currency_code
9130: FROM gl_sets_of_books gs
9131: , ozf_sys_parameters org
9132: WHERE org.set_of_books_id = gs.set_of_books_id
9133: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
9134:
9135: l_fu_currency_code VARCHAR2(15);

Line 9372: FROM ozf_sys_parameters

9368:
9369: -- fix for bug 5042046
9370: CURSOR csr_sys_param_info IS
9371: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag
9372: FROM ozf_sys_parameters
9373: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
9374:
9375: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
9376: SELECT fu.plan_id, fu.cust_account_id, sum(lu.acctd_amount)