DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on AS_ACCESSES_ALL

Line 234: FROM AS_ACCESSES_ALL

230: attribute12,
231: attribute13,
232: attribute14,
233: attribute15
234: FROM AS_ACCESSES_ALL
235: WHERE lead_id = l_lead_id;
236:
237: -- bug 5534788, fixed cursor so that freeze flag
238: -- is carried over from opp to qte correctly

Line 241: FROM AS_ACCESSES_ALL a, ASO_QUOTE_HEADERS_ALL B,aso_quote_accesses c

237: -- bug 5534788, fixed cursor so that freeze flag
238: -- is carried over from opp to qte correctly
239: Cursor C_opp_owner(p_lead_id NUMBER,p_qte_number Number) IS
240: SELECT a.freeze_flag,c.access_id
241: FROM AS_ACCESSES_ALL a, ASO_QUOTE_HEADERS_ALL B,aso_quote_accesses c
242: WHERE a.lead_id = p_lead_id
243: AND b.quote_number = p_qte_number
244: AND a.salesforce_id = c.resource_id
245: AND b.quote_number =c.quote_number;