DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PVT dependencies on MO_GLOBAL

Line 20: WHERE ((nvl(srv.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99)) or (nvl(mo_global.get_current_org_id, -99) = -99))

16: srv.ID2,
17: srv.NAME,
18: srv.DESCRIPTION
19: FROM OKX_SALESREPS_V srv
20: WHERE ((nvl(srv.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99)) or (nvl(mo_global.get_current_org_id, -99) = -99))
21: AND srv.name = NVL(p_name,srv.name)
22: AND srv.ID1 = NVL(p_id1,srv.ID1)
23: AND srv.ID2 = NVL(p_id2,srv.ID2)
24: ORDER BY srv.NAME;