APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on MO_GLOBAL

Line 17: WHERE srv.ORG_ID = mo_global.get_current_org_id

13: '#' ID2,
14: srv.NAME NAME,
15: NULL DESCRIPTION
16: FROM JTF_RS_SALESREPS_MO_V srv
17: WHERE srv.ORG_ID = mo_global.get_current_org_id
18: AND srv.name = p_name
19: AND srv.SALESREP_ID = NVL(p_id1,srv.SALESREP_ID)
20: AND '#' = NVL(p_id2,'#')
21: ORDER BY srv.NAME

Line 171: AND NVL(cnt.ORG_ID, -99) = mo_global.get_current_org_id

167: cnt.name,
168: cnt.description
169: FROM OKX_CONTRACTS_V cnt
170: WHERE cnt.SCS_CODE IN ('LEASE','LOAN')
171: AND NVL(cnt.ORG_ID, -99) = mo_global.get_current_org_id
172: AND cnt.name = NVL(p_name,cnt.name)
173: AND cnt.id1 = NVL(p_id1,cnt.id1)
174: AND cnt.id2 = NVL(p_id2,cnt.id2)
175: ORDER BY cnt.NAME;

Line 8780: ((nvl(OKX_SALEPERS.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99))

8776: OKX_SALESREPS_V OKX_SALEPERS
8777:
8778: WHERE
8779:
8780: ((nvl(OKX_SALEPERS.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99))
8781:
8782: or (nvl(mo_global.get_current_org_id, -99) = -99))
8783:
8784: AND ID1 = p_id1

Line 8782: or (nvl(mo_global.get_current_org_id, -99) = -99))

8778: WHERE
8779:
8780: ((nvl(OKX_SALEPERS.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99))
8781:
8782: or (nvl(mo_global.get_current_org_id, -99) = -99))
8783:
8784: AND ID1 = p_id1
8785:
8786: AND ID2 = p_id2;

Line 9106: where OKX_LEASE.SCS_CODE IN ('LEASE','LOAN') AND NVL(OKX_LEASE.ORG_ID, -99) = mo_global.get_current_org_id

9102: SELECT '1'
9103:
9104: from OKX_CONTRACTS_V OKX_LEASE
9105:
9106: where OKX_LEASE.SCS_CODE IN ('LEASE','LOAN') AND NVL(OKX_LEASE.ORG_ID, -99) = mo_global.get_current_org_id
9107:
9108: AND ID1 = p_id1
9109:
9110: AND ID2 = p_id2;