DBA Data[Home] [Help]

APPS.ASO_IBY_FINANCING_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 80: FROM aso_quote_headers_all qh, aso_quote_statuses_b qs

76: lc_quote_id NUMBER
77: ) IS
78: SELECT qh.quote_source_code, qh.last_update_date, qh.resource_id,
79: qh.quote_status_id, qs.status_code
80: FROM aso_quote_headers_all qh, aso_quote_statuses_b qs
81: WHERE qh.quote_header_id = lc_quote_id
82: AND qh.quote_status_id = qs.quote_status_id;
83:
84: CURSOR c_qte_status_id (

Line 88: FROM aso_quote_statuses_b

84: CURSOR c_qte_status_id (
85: lc_status_code VARCHAR2
86: ) IS
87: SELECT quote_status_id
88: FROM aso_quote_statuses_b
89: WHERE status_code = lc_status_code;
90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT update_status_pvt;