APPS.BIM_LEADS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

	SELECT COUNT(*) INTO LN_ORDERS_GENERATED
	FROM
	(
	SELECT ASO2.OBJECT_ID
	FROM
			ASO_QUOTE_RELATED_OBJECTS ASO1,
			ASO_QUOTE_RELATED_OBJECTS ASO2
	WHERE
			ASO1.OBJECT_TYPE_CODE = 'LEAD' AND
			ASO1.OBJECT_ID = p_lead_id AND
			ASO1.RELATIONSHIP_TYPE_CODE = 'LEAD_QUOTE' AND
			ASO1.QUOTE_OBJECT_ID = ASO2.QUOTE_OBJECT_ID AND
			ASO1.QUOTE_OBJECT_TYPE_CODE = ASO2.QUOTE_OBJECT_TYPE_CODE AND
			ASO2.RELATIONSHIP_TYPE_CODE = 'QUOTE_ORDER'
	UNION
	SELECT ASO2.OBJECT_ID
	FROM
			AS_SALES_LEAD_OPPORTUNITY ASLO,
			ASO_QUOTE_RELATED_OBJECTS ASO1,
			ASO_QUOTE_RELATED_OBJECTS ASO2
	WHERE
			ASLO.SALES_LEAD_ID = p_lead_id AND
			ASLO.OPPORTUNITY_ID = ASO1.OBJECT_ID AND
			ASO1.OBJECT_TYPE_CODE = 'OPPORTUNITY' AND
			ASO1.RELATIONSHIP_TYPE_CODE = 'OPP_QUOTE' AND
			ASO1.QUOTE_OBJECT_ID = ASO2.QUOTE_OBJECT_ID AND
			ASO1.QUOTE_OBJECT_TYPE_CODE = ASO2.QUOTE_OBJECT_TYPE_CODE AND
			ASO2.RELATIONSHIP_TYPE_CODE = 'QUOTE_ORDER'
	);