DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_STATUSES_VL

Line 343: FROM ASO_QUOTE_STATUSES_VL

339: WHERE quote_number = X_qte_number;
340:
341: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
342: SELECT quote_status_id
343: FROM ASO_QUOTE_STATUSES_VL
344: WHERE status_code = c_status_code;
345:
346: CURSOR c_price_list (c_order_type_id NUMBEr) IS
347: SELECT price_list_id

Line 1885: from aso_quote_statuses_vl

1881:
1882: -- Start bug fix 10217258 For limits reversal
1883: IF NVL(FND_PROFILE.VALUE('QP_LIMITS_INSTALLED'),'N') = 'Y' THEN
1884: select count(*) into ct
1885: from aso_quote_statuses_vl
1886: where status_code = 'INACTIVE'
1887: and quote_status_id = p_qte_header_rec.QUOTE_STATUS_ID;
1888:
1889: if ct >0 then