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 197: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

193: l_warning_config_exception EXCEPTION;
194:
195: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
196: SELECT 'Y'
197: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
198: WHERE A.Quote_Header_Id = l_qte_hdr
199: AND A.Quote_Status_Id = B.Quote_Status_Id
200: AND B.Status_Code = 'STORE DRAFT';
201: