DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on OE_SALES_CREDIT_TYPES

Line 1582: OE_SALES_CREDIT_TYPES ST

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'
1586: AND A.Quote_Number = l_qte_num

Line 2014: OE_SALES_CREDIT_TYPES ST

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'
2018: AND A.Quote_Number = l_qte_num