DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on OE_SALES_CREDIT_TYPES

Line 2021: OE_SALES_CREDIT_TYPES ST

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

Line 2453: OE_SALES_CREDIT_TYPES ST

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