APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_SALESREPS_MO_V

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

140:
141: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS
142: SELECT 'Y'
143: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
144: FROM JTF_RS_SALESREPS_MO_V -- New Code Yogeshwar (MOAC)
145: WHERE resource_id = l_res_id
146: AND NVL(status,'A') = 'A'
147: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
148: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);

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

165:
166: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS
167: SELECT Resource_Id
168: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
169: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
170: WHERE Salesrep_Number = l_Srep
171: AND NVL(status,'A') = 'A'
172: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
173: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

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

1577:
1578: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
1579: SELECT A.Resource_Id, A.Resource_Grp_Id, A.Role_Id
1580: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)
1581: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
1582: OE_SALES_CREDIT_TYPES ST
1583: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
1584: AND A.Resource_Id = B.Resource_Id
1585: AND A.Update_Access_Flag = 'Y'

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

1602:
1603: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS
1604: SELECT Resource_Id
1605: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
1606: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
1607: WHERE Salesrep_Number = l_Srep
1608: AND NVL(status,'A') = 'A'
1609: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
1610: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

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

1995:
1996: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS
1997: SELECT 'Y'
1998: /* FROM JTF_RS_SRP_VL */ --Commented Code Yogeshwar (MOAC)
1999: FROM JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
2000: WHERE resource_id = l_res_id
2001: AND NVL(status,'A') = 'A'
2002: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
2003: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

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

2009:
2010: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2011: SELECT A.Resource_Id, A.Resource_Grp_Id
2012: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)
2013: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2014: OE_SALES_CREDIT_TYPES ST
2015: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2016: AND A.Resource_Id = B.Resource_Id
2017: AND A.Update_Access_Flag = 'Y'

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

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