APPS.ASO_SALES_CREDIT_PVT dependencies on JTF_RS_SALESREPS_MO_V

Line 62: FROM JTF_RS_SALESREPS_MO_V B --New Code Yogeshwar (MOAC)

58: AND A.Role_Id IS NOT NULL
59: AND EXISTS
60: ( SELECT B.Resource_Id
61: /* FROM JTF_RS_SRP_VL B */ --Commented Code Yogeshwar (MOAC)
62: FROM JTF_RS_SALESREPS_MO_V B --New Code Yogeshwar (MOAC)
63: WHERE B.Resource_Id = A.Resource_Id
64: AND NVL(B.status,'A') = 'A'
65: AND nvl(trunc(B.start_date_active), trunc(sysdate)) <= trunc(sysdate)
66: AND nvl(trunc(B.end_date_active), trunc(sysdate)) >= trunc(sysdate));

Line 733: FROM JTF_RS_SALESREPS_MO_V C --New Code yogeshwar (MOAC)

729: AND A.Role_Id IS NOT NULL
730: AND EXISTS
731: ( SELECT C.Resource_Id
732: /* FROM JTF_RS_SRP_VL C */ --Commented Code Yogeshwar (MOAC)
733: FROM JTF_RS_SALESREPS_MO_V C --New Code yogeshwar (MOAC)
734: WHERE C.Resource_Id = A.Resource_Id
735: AND NVL(status,'A') = 'A'
736: AND nvl(trunc(C.start_date_active), trunc(sysdate)) <= trunc(sysdate)
737: AND nvl(trunc(C.end_date_active), trunc(sysdate)) >= trunc(sysdate));