APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 4018: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

4014:
4015: -- Code for Sales Team Assignment Changes
4016: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
4017: SELECT 'Y'
4018: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
4019: WHERE A.Quote_Header_Id = l_qte_hdr
4020: AND A.Quote_Status_Id = B.Quote_Status_Id
4021: AND B.Status_Code = 'STORE DRAFT';
4022:

Line 6623: FROM ASO_QUOTE_STATUSES_B

6619: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
6620:
6621: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
6622: SELECT AUTO_VERSION_FLAG
6623: FROM ASO_QUOTE_STATUSES_B
6624: WHERE quote_status_id = c_qte_status_id;
6625:
6626: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
6627: SELECT max(quote_version)

Line 6819: FROM ASO_QUOTE_STATUSES_B A, ASO_QUOTE_STATUSES_B B

6815: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
6816:
6817: CURSOR C_Check_Store_Status (l_old_stat NUMBER, l_new_stat NUMBER) IS
6818: SELECT 'Y'
6819: FROM ASO_QUOTE_STATUSES_B A, ASO_QUOTE_STATUSES_B B
6820: WHERE A.Quote_Status_Id = l_old_stat
6821: AND A.Status_Code = 'STORE DRAFT'
6822: AND B.Quote_Status_Id = l_new_stat
6823: AND B.Status_Code = 'DRAFT';

Line 10923: FROM ASO_QUOTE_STATUSES_B

10919: WHERE quote_number = X_qte_number;
10920:
10921: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
10922: SELECT quote_status_id
10923: FROM ASO_QUOTE_STATUSES_B
10924: WHERE status_code = c_status_code;
10925: --WHERE status_code = 'DRAFT';
10926:
10927: CURSOR C_Qte_Status_Trans (from_id NUMBER, to_id NUMBER) IS