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_PVT dependencies on OZF_SYS_PARAMETERS

Line 77: ozf_sys_parameters osp

73: -- fix for bug 5042046
74: CURSOR gp_func_currency_cd_csr IS
75: SELECT gs.currency_code
76: FROM gl_sets_of_books gs,
77: ozf_sys_parameters osp
78: WHERE gs.set_of_books_id = osp.set_of_books_id
79: AND osp.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
80:
81: ---------------------------------------------------------------------

Line 661: FROM ozf_sys_parameters

657:
658: -- fix for bug 5042046
659: CURSOR sys_parameters_days_due_csr IS
660: SELECT days_due
661: FROM ozf_sys_parameters
662: where org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
663:
664: l_days_due number;
665: BEGIN

Line 675: -- get days_due from ozf_sys_parameters.

671: OPEN days_due_csr(p_cust_accout_id);
672: FETCH days_due_csr into l_days_due;
673: CLOSE days_due_csr;
674:
675: -- get days_due from ozf_sys_parameters.
676: IF l_days_due is null THEN
677: OPEN sys_parameters_days_due_csr;
678: FETCH sys_parameters_days_due_csr INTO l_days_due;
679: CLOSE sys_parameters_days_due_csr;

Line 1604: FROM OZF_SYS_PARAMETERS

1600: --Cursor to get the Threshold amounts from the system parameters.
1601: CURSOR get_sys_parm_wo_thr_csr IS
1602: SELECT pos_write_off_threshold
1603: , neg_write_off_threshold
1604: FROM OZF_SYS_PARAMETERS
1605: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1606:
1607: BEGIN
1608:

Line 1744: FROM OZF_SYS_PARAMETERS

1740: -- fix for bug 5042046
1741: --Cursor to get the exchange rate type.
1742: CURSOR get_exchange_rate_type_csr IS
1743: SELECT exchange_rate_type
1744: FROM OZF_SYS_PARAMETERS
1745: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1746:
1747: BEGIN
1748:

Line 3705: FROM ozf_sys_parameters

3701:
3702: -- fix for bug 5042046
3703: CURSOR sob_csr IS
3704: SELECT set_of_books_id
3705: FROM ozf_sys_parameters
3706: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3707:
3708: CURSOR sys_parameters_csr IS
3709: SELECT gl_date_type

Line 3710: FROM ozf_sys_parameters

3706: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3707:
3708: CURSOR sys_parameters_csr IS
3709: SELECT gl_date_type
3710: FROM ozf_sys_parameters
3711: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3712:
3713: CURSOR exchange_rate_type_csr IS
3714: SELECT exchange_rate_type

Line 3715: FROM ozf_sys_parameters

3711: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3712:
3713: CURSOR exchange_rate_type_csr IS
3714: SELECT exchange_rate_type
3715: FROM ozf_sys_parameters
3716: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3717:
3718: CURSOR default_owner_id_csr IS
3719: SELECT default_owner_id

Line 3720: FROM ozf_sys_parameters

3716: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3717:
3718: CURSOR default_owner_id_csr IS
3719: SELECT default_owner_id
3720: FROM ozf_sys_parameters
3721: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3722:
3723: CURSOR auto_assign_flag_csr IS
3724: SELECT auto_assign_flag

Line 3725: FROM ozf_sys_parameters

3721: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3722:
3723: CURSOR auto_assign_flag_csr IS
3724: SELECT auto_assign_flag
3725: FROM ozf_sys_parameters
3726: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3727:
3728: l_auto_assign_flag varchar2(1);
3729:

Line 4996: hz_cust_accounts cust, ozf_sys_parameters_all ozfsys

4992: type.name ClaimType,
4993: reason.name ClaimReason,
4994: claim.org_id
4995: from ozf_claims_all claim, ozf_claim_types_all_vl type, ozf_reason_codes_all_vl reason,
4996: hz_cust_accounts cust, ozf_sys_parameters_all ozfsys
4997: where
4998: type.claim_type_id = claim.claim_type_id AND
4999: reason.reason_code_id = ozfsys.reason_code_id AND
5000: claim.cust_account_id = cust.cust_account_id AND

Line 6201: FROM ozf_sys_parameters

6197:
6198: -- fix for bug 5042046
6199: CURSOR auto_assign_flag_csr IS
6200: SELECT auto_assign_flag
6201: FROM ozf_sys_parameters
6202: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6203:
6204: l_auto_assign_flag varchar2(1);
6205:

Line 6208: FROM ozf_sys_parameters

6204: l_auto_assign_flag varchar2(1);
6205:
6206: CURSOR default_owner_id_csr IS
6207: SELECT default_owner_id
6208: FROM ozf_sys_parameters
6209: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6210:
6211: CURSOR resource_id_csr(p_user_id in number) is
6212: SELECT resource_id

Line 6348: FROM ozf_sys_parameters

6344:
6345: --Bugfix : 10176541
6346: CURSOR exchange_rate_type_csr IS
6347: SELECT exchange_rate_type
6348: FROM ozf_sys_parameters
6349: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6350:
6351: l_activity_id NUMBER;
6352: l_ind number :=1;

Line 8978: --FROM ozf_sys_parameters;

8974: l_return_status varchar2(30);
8975:
8976: --CURSOR claim_type_id_csr IS
8977: --SELECT claim_type_id
8978: --FROM ozf_sys_parameters;
8979:
8980: -- This cursor checks whether a given claim_type_id is of deduction class.
8981: -- and whether it is in the database.
8982: --CURSOR number_of_claim_type_id_csr(p_claim_type_id in number) IS

Line 8991: --FROM ozf_sys_parameters;

8987: --l_number_of_claim_type_id NUMBER;
8988:
8989: --CURSOR reason_code_id_csr IS
8990: --SELECT reason_code_id
8991: --FROM ozf_sys_parameters;
8992:
8993: -- This cursor checks whether a given reason_type is in the database
8994: --CURSOR number_of_reason_code_id_csr(p_reason_code_id in number) IS
8995: --SELECT count(reason_code_id)