APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on MO_GLOBAL

Line 20: AND srv.ORG_ID = mo_global.get_current_org_id

16: NULL DESCRIPTION
17: FROM JTF_RS_SALESREPS_MO_V srv,
18: JTF_RS_RESOURCE_EXTNS_VL RES
19: WHERE res.resource_id=srv.resource_id
20: AND srv.ORG_ID = mo_global.get_current_org_id
21: --AND RES.RESOURCE_NAME = p_name
22: AND srv.SALESREP_ID = p_id1
23: AND '#' = NVL(p_id2,'#')
24: ORDER BY RES.RESOURCE_NAME ;

Line 32: WHERE srv.ORG_ID = mo_global.get_current_org_id

28: '#' ID2,
29: srv.NAME NAME,
30: NULL DESCRIPTION
31: FROM JTF_RS_SALESREPS_MO_V srv
32: WHERE srv.ORG_ID = mo_global.get_current_org_id
33: AND srv.name = p_name
34: AND srv.SALESREP_ID = NVL(p_id1,srv.SALESREP_ID)
35: AND '#' = NVL(p_id2,'#')
36: ORDER BY srv.NAME

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

183: cnt.name,
184: cnt.description
185: FROM OKX_CONTRACTS_V cnt
186: WHERE cnt.SCS_CODE IN ('LEASE','LOAN')
187: AND NVL(cnt.ORG_ID, -99) = mo_global.get_current_org_id
188: AND cnt.name = NVL(p_name,cnt.name)
189: AND cnt.id1 = NVL(p_id1,cnt.id1)
190: AND cnt.id2 = NVL(p_id2,cnt.id2)
191: ORDER BY cnt.NAME;

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

8838: OKX_SALESREPS_V OKX_SALEPERS
8839:
8840: WHERE
8841:
8842: ((nvl(OKX_SALEPERS.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99))
8843:
8844: or (nvl(mo_global.get_current_org_id, -99) = -99))
8845:
8846: AND ID1 = p_id1

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

8840: WHERE
8841:
8842: ((nvl(OKX_SALEPERS.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99))
8843:
8844: or (nvl(mo_global.get_current_org_id, -99) = -99))
8845:
8846: AND ID1 = p_id1
8847:
8848: AND ID2 = p_id2;

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

9164: SELECT '1'
9165:
9166: from OKX_CONTRACTS_V OKX_LEASE
9167:
9168: where OKX_LEASE.SCS_CODE IN ('LEASE','LOAN') AND NVL(OKX_LEASE.ORG_ID, -99) = mo_global.get_current_org_id
9169:
9170: AND ID1 = p_id1
9171:
9172: AND ID2 = p_id2;