APPS.ASO_DEFAULTING_UTIL SQL Statements

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

Line: 44

  SELECT Party_Type
  FROM HZ_PARTIES
  WHERE Party_Id = lc_party_id;

Line: 49

  SELECT pty.Party_Type
  FROM HZ_PARTIES pty, ASO_QUOTE_HEADERS_ALL hdr
  WHERE pty.Party_Id = hdr.cust_party_id
  AND hdr.quote_header_id = lc_quote_header_id;

Line: 55

  SELECT Segment1
  FROM mtl_system_items_vl
  WHERE inventory_item_id = lc_inv_item_id
  AND organization_id = lc_organization_id;

Line: 314

           P_Quote_Header_Rec.LAST_UPDATE_DATE IS NULL THEN
          X_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 317

          X_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := P_Quote_Header_Rec.LAST_UPDATE_DATE;

Line: 914

           P_Quote_Header_Rec.LAST_UPDATE_DATE IS NULL THEN
          X_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 917

          X_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := P_Quote_Header_Rec.LAST_UPDATE_DATE;

Line: 1344

           P_Quote_Line_Rec.LAST_UPDATE_DATE IS NULL THEN
          X_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 1347

          X_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := P_Quote_Line_Rec.LAST_UPDATE_DATE;

Line: 1844

          X_Quote_Header_Rec.LAST_UPDATE_DATE := P_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE;

Line: 1920

          X_Quote_Header_Rec.LAST_UPDATE_DATE := P_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE;

Line: 1973

          X_Quote_Line_Rec.LAST_UPDATE_DATE := P_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE;

Line: 2098

          P_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 2176

          P_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 2233

          P_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE :=  FND_API.G_MISS_DATE;