APPS.OZF_CLAIM_PVT dependencies on MO_GLOBAL

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

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

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

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

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

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

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

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

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

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

Line 3330: 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
3334: FROM ozf_sys_parameters

Line 3335: 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
3339: FROM ozf_sys_parameters

Line 3340: 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
3344: FROM ozf_sys_parameters

Line 3345: 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:
3349: CURSOR claim_id_csr IS

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

3606: l_claim.org_id := l_org_id; */
3607:
3608: -- If org_id is null, then needs to get current_org_id.
3609: IF (l_claim.org_id IS NULL ) THEN
3610: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements
3611: l_claim.org_id := l_org_id;
3612: ELSE
3613: l_org_id := l_claim.org_id;
3614: END IF;

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

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

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

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