DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on MO_GLOBAL

Line 79: AND osp.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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: ---------------------------------------------------------------------
82: -- Definitions of some packagewise data type.
83: ---------------------------------------------------------------------

Line 662: where org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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
666:

Line 1605: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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:
1609: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1745: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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:
1749: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3706: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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
3710: FROM ozf_sys_parameters

Line 3711: 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
3715: FROM ozf_sys_parameters

Line 3716: 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
3720: FROM ozf_sys_parameters

Line 3721: 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
3725: FROM ozf_sys_parameters

Line 3726: 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:
3730: CURSOR claim_id_csr IS

Line 4063: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements

4059: l_claim.org_id := l_org_id; */
4060:
4061: -- If org_id is null, then needs to get current_org_id.
4062: IF (l_claim.org_id IS NULL ) THEN
4063: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements
4064: l_claim.org_id := l_org_id;
4065: ELSE
4066: l_org_id := l_claim.org_id;
4067: END IF;

Line 6202: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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:
6206: CURSOR default_owner_id_csr IS

Line 6209: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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
6213: FROM jtf_rs_resource_extns

Line 6349: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

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;
6353: l_old_claim_line_id number;