DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on JTF_RS_SALESREPS_MO_V

Line 17: FROM JTF_RS_SALESREPS_MO_V srv,

13: SELECT srv.SALESREP_ID ID1,
14: '#' ID2,
15: NVL(srv.NAME,RES.RESOURCE_NAME) NAME,
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

Line 31: FROM JTF_RS_SALESREPS_MO_V srv

27: SELECT srv.SALESREP_ID ID1,
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,'#')