APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 54: FROM ASO_QUOTE_STATUSES_B

50: and b.quote_header_id = x_quote_header_id;
51:
52: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
53: SELECT quote_status_id
54: FROM ASO_QUOTE_STATUSES_B
55: WHERE status_code = c_status_code;
56:
57: CURSOR C_Qte_Status_Trans (from_id NUMBER, to_id NUMBER) IS
58: SELECT enabled_flag

Line 188: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

184: l_status VARCHAR2(1) := 'S';
185:
186: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
187: SELECT 'Y'
188: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
189: WHERE A.Quote_Header_Id = l_qte_hdr
190: AND A.Quote_Status_Id = B.Quote_Status_Id
191: AND B.Status_Code = 'STORE DRAFT';
192: