APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 4101: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

4097:
4098: -- Code for Sales Team Assignment Changes
4099: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
4100: SELECT 'Y'
4101: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
4102: WHERE A.Quote_Header_Id = l_qte_hdr
4103: AND A.Quote_Status_Id = B.Quote_Status_Id
4104: AND B.Status_Code = 'STORE DRAFT';
4105:

Line 6762: FROM ASO_QUOTE_STATUSES_B

6758: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
6759:
6760: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
6761: SELECT AUTO_VERSION_FLAG
6762: FROM ASO_QUOTE_STATUSES_B
6763: WHERE quote_status_id = c_qte_status_id;
6764:
6765: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
6766: SELECT max(quote_version)

Line 6959: FROM ASO_QUOTE_STATUSES_B A, ASO_QUOTE_STATUSES_B B

6955: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
6956:
6957: CURSOR C_Check_Store_Status (l_old_stat NUMBER, l_new_stat NUMBER) IS
6958: SELECT 'Y'
6959: FROM ASO_QUOTE_STATUSES_B A, ASO_QUOTE_STATUSES_B B
6960: WHERE A.Quote_Status_Id = l_old_stat
6961: AND A.Status_Code = 'STORE DRAFT'
6962: AND B.Quote_Status_Id = l_new_stat
6963: AND B.Status_Code = 'DRAFT';

Line 11994: FROM ASO_QUOTE_STATUSES_B

11990: WHERE quote_number = X_qte_number;
11991:
11992: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
11993: SELECT quote_status_id
11994: FROM ASO_QUOTE_STATUSES_B
11995: WHERE status_code = c_status_code;
11996: --WHERE status_code = 'DRAFT';
11997:
11998: CURSOR C_Qte_Status_Trans (from_id NUMBER, to_id NUMBER) IS