APPS.OZF_CLAIM_PVT dependencies on OZF_SYS_PARAMETERS

Line 70: ozf_sys_parameters osp

66: -- fix for bug 5042046
67: CURSOR gp_func_currency_cd_csr IS
68: SELECT gs.currency_code
69: FROM gl_sets_of_books gs,
70: ozf_sys_parameters osp
71: WHERE gs.set_of_books_id = osp.set_of_books_id
72: AND osp.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
73:
74: ---------------------------------------------------------------------

Line 608: FROM ozf_sys_parameters

604:
605: -- fix for bug 5042046
606: CURSOR sys_parameters_days_due_csr IS
607: SELECT days_due
608: FROM ozf_sys_parameters
609: where org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
610:
611: l_days_due number;
612: BEGIN

Line 622: -- get days_due from ozf_sys_parameters.

618: OPEN days_due_csr(p_cust_accout_id);
619: FETCH days_due_csr into l_days_due;
620: CLOSE days_due_csr;
621:
622: -- get days_due from ozf_sys_parameters.
623: IF l_days_due is null THEN
624: OPEN sys_parameters_days_due_csr;
625: FETCH sys_parameters_days_due_csr INTO l_days_due;
626: CLOSE sys_parameters_days_due_csr;

Line 1527: FROM OZF_SYS_PARAMETERS

1523: --Cursor to get the Threshold amounts from the system parameters.
1524: CURSOR get_sys_parm_wo_thr_csr IS
1525: SELECT pos_write_off_threshold
1526: , neg_write_off_threshold
1527: FROM OZF_SYS_PARAMETERS
1528: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1529:
1530: BEGIN
1531:

Line 1667: FROM OZF_SYS_PARAMETERS

1663: -- fix for bug 5042046
1664: --Cursor to get the exchange rate type.
1665: CURSOR get_exchange_rate_type_csr IS
1666: SELECT exchange_rate_type
1667: FROM OZF_SYS_PARAMETERS
1668: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1669:
1670: BEGIN
1671:

Line 3324: FROM ozf_sys_parameters

3320:
3321: -- fix for bug 5042046
3322: CURSOR sob_csr IS
3323: SELECT set_of_books_id
3324: FROM ozf_sys_parameters
3325: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3326:
3327: CURSOR sys_parameters_csr IS
3328: SELECT gl_date_type

Line 3329: FROM ozf_sys_parameters

3325: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3326:
3327: CURSOR sys_parameters_csr IS
3328: SELECT gl_date_type
3329: FROM ozf_sys_parameters
3330: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3331:
3332: CURSOR exchange_rate_type_csr IS
3333: SELECT exchange_rate_type

Line 3334: FROM ozf_sys_parameters

3330: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3331:
3332: CURSOR exchange_rate_type_csr IS
3333: SELECT exchange_rate_type
3334: FROM ozf_sys_parameters
3335: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3336:
3337: CURSOR default_owner_id_csr IS
3338: SELECT default_owner_id

Line 3339: FROM ozf_sys_parameters

3335: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3336:
3337: CURSOR default_owner_id_csr IS
3338: SELECT default_owner_id
3339: FROM ozf_sys_parameters
3340: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3341:
3342: CURSOR auto_assign_flag_csr IS
3343: SELECT auto_assign_flag

Line 3344: FROM ozf_sys_parameters

3340: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3341:
3342: CURSOR auto_assign_flag_csr IS
3343: SELECT auto_assign_flag
3344: FROM ozf_sys_parameters
3345: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3346:
3347: l_auto_assign_flag varchar2(1);
3348:

Line 5311: FROM ozf_sys_parameters

5307:
5308: -- fix for bug 5042046
5309: CURSOR auto_assign_flag_csr IS
5310: SELECT auto_assign_flag
5311: FROM ozf_sys_parameters
5312: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
5313:
5314: l_auto_assign_flag varchar2(1);
5315:

Line 5318: FROM ozf_sys_parameters

5314: l_auto_assign_flag varchar2(1);
5315:
5316: CURSOR default_owner_id_csr IS
5317: SELECT default_owner_id
5318: FROM ozf_sys_parameters
5319: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
5320:
5321: CURSOR resource_id_csr(p_user_id in number) is
5322: SELECT resource_id

Line 7255: --FROM ozf_sys_parameters;

7251: l_return_status varchar2(30);
7252:
7253: --CURSOR claim_type_id_csr IS
7254: --SELECT claim_type_id
7255: --FROM ozf_sys_parameters;
7256:
7257: -- This cursor checks whether a given claim_type_id is of deduction class.
7258: -- and whether it is in the database.
7259: --CURSOR number_of_claim_type_id_csr(p_claim_type_id in number) IS

Line 7268: --FROM ozf_sys_parameters;

7264: --l_number_of_claim_type_id NUMBER;
7265:
7266: --CURSOR reason_code_id_csr IS
7267: --SELECT reason_code_id
7268: --FROM ozf_sys_parameters;
7269:
7270: -- This cursor checks whether a given reason_type is in the database
7271: --CURSOR number_of_reason_code_id_csr(p_reason_code_id in number) IS
7272: --SELECT count(reason_code_id)