DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on ASO_QUOTE_HEADERS_ALL

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;

Line 1270: FROM ASO_QUOTE_HEADERS_ALL

1266:
1267:
1268: BEGIN
1269: SELECT last_update_date into l_last_update_date
1270: FROM ASO_QUOTE_HEADERS_ALL
1271: WHERE quote_header_id = lx_qte_header_rec.quote_header_id;
1272:
1273: lx_QTE_HEADER_REC.last_update_date := l_last_update_date;
1274:

Line 1479: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',

1475: p_api_version => l_api_version,
1476: p_init_msg_list => FND_API.G_FALSE,
1477: p_commit => FND_API.G_FALSE,
1478: p_old_object_code => 'AS_OPPORTUNITY_ATTCH',
1479: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1480: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,
1481: p_new_object_id => lx_qte_header_rec.quote_header_id,
1482: x_return_status => x_return_status,
1483: x_msg_count => x_msg_count,