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
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,'#')