APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_SALESREPS_MO_V

Line 421: FROM JTF_RS_SALESREPS_MO_V -- New Code Yogeshwar (MOAC)

417:
418: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS
419: SELECT 'Y'
420: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
421: FROM JTF_RS_SALESREPS_MO_V -- New Code Yogeshwar (MOAC)
422: WHERE resource_id = l_res_id
423: AND NVL(status,'A') = 'A'
424: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
425: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);

Line 446: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)

442:
443: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS
444: SELECT Resource_Id
445: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
446: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
447: WHERE Salesrep_Number = l_Srep
448: AND NVL(status,'A') = 'A'
449: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
450: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

Line 2020: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)

2016:
2017: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2018: SELECT A.Resource_Id, A.Resource_Grp_Id, A.Role_Id
2019: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)
2020: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2021: OE_SALES_CREDIT_TYPES ST
2022: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2023: AND A.Resource_Id = B.Resource_Id
2024: AND A.Update_Access_Flag = 'Y'

Line 2045: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)

2041:
2042: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS
2043: SELECT Resource_Id
2044: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
2045: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
2046: WHERE Salesrep_Number = l_Srep
2047: AND NVL(status,'A') = 'A'
2048: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
2049: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

Line 2438: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)

2434:
2435: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS
2436: SELECT 'Y'
2437: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
2438: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
2439: WHERE resource_id = l_res_id
2440: AND NVL(status,'A') = 'A'
2441: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
2442: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

Line 2452: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)

2448:
2449: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2450: SELECT A.Resource_Id, A.Resource_Grp_Id
2451: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)
2452: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2453: OE_SALES_CREDIT_TYPES ST
2454: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2455: AND A.Resource_Id = B.Resource_Id
2456: AND A.Update_Access_Flag = 'Y'

Line 2489: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)

2485:
2486: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS
2487: SELECT Resource_Id
2488: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
2489: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
2490: WHERE Salesrep_Number = l_Srep
2491: AND NVL(status,'A') = 'A'
2492: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
2493: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;