eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_ORDER_INT SQL Statements

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

Line: 52


         SELECT salesrep_id
         FROM ra_salesreps
         WHERE person_id = employee_person_id
         AND  (sysdate  BETWEEN NVL(start_date_active, sysdate) AND
				 NVL(end_date_active, sysdate));

Line: 287


       SELECT CAN_FULFILL_ELECTRONIC_FLAG , jtf_amv_item_id
       FROM AMS_DELIVERABLES_ALL_B
       WHERE inventory_item_id =  lc_inventory_item_id;

Line: 369


SELECT RESOURCE_ID
from jtf_rs_srp_vl
where SALESREP_ID = p_salesrepid;

Line: 407


SELECT RESOURCE_ID  into  x_header_sales_credit_TBL(i).RESOURCE_ID
  from jtf_rs_srp_vl
  where SALESREP_ID = P_header_sales_credit_TBL(i).SALESREP_ID;

Line: 472


  SELECT RESOURCE_ID  into  x_line_sales_credit_TBL(i).RESOURCE_ID
  from jtf_rs_srp_vl
  where SALESREP_ID = P_line_sales_credit_TBL(i).SALESREP_ID;

Line: 523


   x_Lot_Serial_Tbl(i).last_updated_by           := p_Lot_Serial_Tbl(i).last_updated_by ;

Line: 524


   x_Lot_Serial_Tbl(i).last_update_date              := p_Lot_Serial_Tbl(i).last_update_date ;

Line: 525


   x_Lot_Serial_Tbl(i).last_update_login             := p_Lot_Serial_Tbl(i).last_update_login ;

Line: 760


PROCEDURE Update_order(
   P_Api_Version_Number         IN   NUMBER,
   P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
   P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
   P_Qte_Rec          IN    ASO_QUOTE_PUB.Qte_Header_Rec_Type
			:= ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
   P_Header_Payment_Tbl      IN    ASO_QUOTE_PUB.Payment_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Payment_TBL,
   P_Header_Price_Adj_Tbl    IN    ASO_QUOTE_PUB.Price_Adj_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
   P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
   P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
   P_Header_Price_Adj_Attr_Tbl    IN  ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
			 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
   P_Header_Shipment_Tbl     IN    ASO_QUOTE_PUB.Shipment_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
   P_Header_TAX_DETAIL_Tbl  IN    ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
   P_Header_FREIGHT_CHARGE_Tbl   IN   ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
			  := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
   P_header_sales_credit_TBL      IN   Sales_credit_tbl_type
			  := G_MISS_sales_credit_TBL,
    P_Qte_Line_Tbl     IN    ASO_QUOTE_PUB.Qte_Line_Tbl_Type
			  := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
    P_Qte_Line_Dtl_tbl IN    ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
    P_Line_Payment_Tbl      IN    ASO_QUOTE_PUB.Payment_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Payment_TBL,
    P_Line_Price_Adj_Tbl    IN    ASO_QUOTE_PUB.Price_Adj_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
    P_Line_Price_Attributes_Tbl   IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
    P_Line_Price_Adj_rltship_Tbl IN   ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
    P_Line_Price_Adj_Attr_Tbl    IN  ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
			:= ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Line_Shipment_Tbl     IN    ASO_QUOTE_PUB.Shipment_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_shipment_TBL,
    P_Line_TAX_DETAIL_Tbl  IN    ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
    P_Line_FREIGHT_CHARGE_Tbl    IN   ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
			  := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
    P_Line_Rltship_Tbl      IN   ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
    P_Line_sales_credit_TBL      IN   Sales_credit_tbl_type
			:= G_MISS_sales_credit_TBL,
    P_Lot_Serial_Tbl        IN   Lot_Serial_Tbl_Type
                             := G_MISS_Lot_Serial_Tbl,
    P_Control_Rec                IN Control_Rec_Type := G_MISS_Control_Rec,
    X_Order_Header_Rec           OUT NOCOPY /* file.sql.39 change */   Order_Header_Rec_Type,
    X_Order_Line_Tbl             OUT NOCOPY /* file.sql.39 change */   Order_Line_Tbl_type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */   VARCHAR2
    )
IS

l_api_version_number          CONSTANT NUMBER := 1.0;

Line: 820


l_api_name                    CONSTANT VARCHAR2(30):= 'Update_Order';

Line: 827


      SAVEPOINT UPDATE_order_PVT;

Line: 874


           Update_Order(
             P_Api_Version   => l_api_version_number,
    P_Init_Msg_List    =>P_Init_Msg_List,
    P_Commit           =>p_commit,
    P_Qte_Rec          => P_Qte_Rec,
    P_Header_Payment_Tbl   => P_Header_Payment_Tbl,
    P_Header_Price_Adj_Tbl    => P_Header_Price_Adj_Tbl,
    P_Header_Price_Attributes_Tbl => P_Header_Price_Attributes_Tbl,
    P_Header_Price_Adj_rltship_Tbl =>P_Header_Price_Adj_rltship_Tbl,
    P_Header_Price_Adj_Attr_Tbl  => P_Header_Price_Adj_Attr_Tbl,
    P_Header_Shipment_Tbl   => P_Header_Shipment_Tbl,
    P_Header_TAX_DETAIL_Tbl =>P_Header_TAX_DETAIL_Tbl,
    P_Header_FREIGHT_CHARGE_Tbl   => P_Header_FREIGHT_CHARGE_Tbl,
    P_Header_ATTRIBS_EXT_Tbl  => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
    P_Header_Quote_Party_Tbl      =>  ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
    P_header_sales_credit_TBL  => l_header_sales_credit_TBL,
    P_Qte_Line_Tbl    => P_Qte_Line_Tbl,
    P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,
    P_Line_Payment_Tbl => P_Line_Payment_Tbl,
    P_Line_Price_Adj_Tbl  => P_Line_Price_Adj_Tbl,
    P_Line_Price_Attributes_Tbl => P_Line_Price_Attributes_Tbl,
    P_Line_Price_Adj_rltship_Tbl => P_Line_Price_Adj_rltship_Tbl,
    P_Line_Price_Adj_Attr_Tbl  => P_Line_Price_Adj_Attr_Tbl,
    P_Line_Shipment_Tbl     => P_Line_Shipment_Tbl,
    P_Line_TAX_DETAIL_Tbl  => P_Line_TAX_DETAIL_Tbl,
    P_Line_FREIGHT_CHARGE_Tbl     => P_Line_FREIGHT_CHARGE_Tbl,
    P_Line_ATTRIBS_EXT_Tbl =>ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
    P_Line_Rltship_Tbl  => P_Line_Rltship_Tbl,
    P_Line_sales_credit_TBL  =>  l_Line_sales_credit_TBL ,
    P_Line_Quote_Party_Tbl   =>  ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
    P_Lot_Serial_Tbl     => l_Lot_Serial_Tbl,
    P_Control_Rec        => P_Control_Rec,
    X_Order_Header_Rec  => X_Order_Header_Rec,
    X_Order_Line_Tbl   => X_Order_Line_Tbl,
    X_Return_Status   => X_Return_Status,
    X_Msg_Count    => X_Msg_Count,
    X_Msg_Data  => X_Msg_Data
   );

Line: 969


END Update_Order;

Line: 972


PROCEDURE Delete_order(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_Order_Header_id            IN   NUMBER,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */   VARCHAR2
    )
IS

l_api_version_number          CONSTANT NUMBER := 1.0;

Line: 984


l_api_name                    CONSTANT VARCHAR2(30):= 'DELETE_ORDER';

Line: 989


      SAVEPOINT Delete_Order_PVT;

Line: 1032


	OE_ORDER_PUB.Delete_Order
	(
 	    p_header_id      => p_order_header_id
	,   x_return_status  => x_return_status
	,   x_msg_count      => x_msg_count
	,   x_msg_data       => x_msg_data
	);

Line: 1097


END Delete_order;

Line: 1421


	SELECT lookup_code
	from oe_lookups
	WHERE lookup_type = 'CANCEL_CODE'
	AND lookup_code = 'Not provided';

Line: 1485


     l_header_rec.operation        := OE_Globals.G_OPR_UPDATE;

Line: 2239


PROCEDURE Update_order(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_Qte_Rec          IN    ASO_QUOTE_PUB.Qte_Header_Rec_Type
			:= ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
    P_Header_Payment_Tbl      IN    ASO_QUOTE_PUB.Payment_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Payment_TBL,
    P_Header_Price_Adj_Tbl    IN    ASO_QUOTE_PUB.Price_Adj_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
    P_Header_Price_Attributes_Tbl IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
    P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
    P_Header_Price_Adj_Attr_Tbl    IN  ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
			 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Header_Shipment_Tbl     IN    ASO_QUOTE_PUB.Shipment_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
    P_Header_TAX_DETAIL_Tbl  IN    ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
    P_Header_FREIGHT_CHARGE_Tbl    IN   ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
		        := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
    P_Header_ATTRIBS_EXT_Tbl  IN  ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
                        := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
    P_Header_Quote_Party_Tbl       IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type
                                    := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
    P_header_sales_credit_TBL      IN   ASO_QUOTE_PUB.Sales_credit_tbl_type
			:= ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
    P_Qte_Line_Tbl     IN    ASO_QUOTE_PUB.Qte_Line_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
    P_Qte_Line_Dtl_tbl  IN    ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
    P_Line_Payment_Tbl      IN    ASO_QUOTE_PUB.Payment_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Payment_TBL,
    P_Line_Price_Adj_Tbl    IN    ASO_QUOTE_PUB.Price_Adj_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
    P_Line_Price_Attributes_Tbl   IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
    P_Line_Price_Adj_rltship_Tbl IN   ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
			 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
    P_Line_Price_Adj_Attr_Tbl    IN  ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
			:= ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Line_Shipment_Tbl     IN    ASO_QUOTE_PUB.Shipment_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_shipment_TBL,
    P_Line_TAX_DETAIL_Tbl  IN    ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
			:= ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
    P_Line_FREIGHT_CHARGE_Tbl        IN   ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type  			 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
    P_Line_ATTRIBS_EXT_Tbl  IN  ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
                        := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
    P_Line_Rltship_Tbl      IN   ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
			  := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
   P_Line_sales_credit_TBL      IN   ASO_QUOTE_PUB.Sales_credit_tbl_type
			 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
    P_Line_Quote_Party_Tbl       IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type
                                    := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
    P_Lot_Serial_Tbl        IN   ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
                             := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
    P_Control_Rec                IN Control_Rec_Type := G_MISS_Control_Rec,
    X_Order_Header_Rec           OUT NOCOPY /* file.sql.39 change */   Order_Header_Rec_Type,
    X_Order_Line_Tbl             OUT NOCOPY /* file.sql.39 change */   Order_Line_Tbl_type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */   VARCHAR2
    )
IS
-- this should be changed post 11.5.1
   CURSOR C_cancel_reason IS
      SELECT lookup_code
      from oe_lookups
      WHERE lookup_type = 'CANCEL_CODE'
      AND lookup_code = 'Not provided';

Line: 2314


l_api_name                    CONSTANT VARCHAR2(30):= 'Update_Order';

Line: 2393


      SAVEPOINT UPDATE_order_PVT;

Line: 2501


    p_operation                   => 'UPDATE'                      ,
    P_Qte_Rec                     => P_Qte_Rec                     ,
    P_Header_Payment_Tbl          => P_Header_Payment_Tbl          ,
    P_Header_Price_Adj_Tbl        => P_Header_Price_Adj_Tbl        ,
    P_Header_Price_Attributes_Tbl => P_Header_Price_Attributes_Tbl ,
    P_Header_Price_Adj_rltship_Tbl=> P_Header_Price_Adj_rltship_Tbl  ,
    P_Header_Price_Adj_Attr_Tbl   => P_Header_Price_Adj_Attr_Tbl  ,
    P_Header_Shipment_Tbl         => P_Header_Shipment_Tbl        ,
    P_Header_TAX_DETAIL_Tbl       => P_Header_TAX_DETAIL_Tbl      ,
    P_Header_FREIGHT_CHARGE_Tbl   => P_Header_FREIGHT_CHARGE_Tbl  ,
    P_header_sales_credit_TBL     => P_header_sales_credit_TBL    ,
    P_Qte_Line_Tbl                => P_Qte_Line_Tbl               ,
    P_Qte_Line_Dtl_Tbl            => P_Qte_Line_Dtl_Tbl           ,
    P_Line_Payment_Tbl            => P_Line_Payment_Tbl           ,
    P_Line_Price_Adj_Tbl          => P_Line_Price_Adj_Tbl         ,
    P_Line_Price_Attributes_Tbl   => P_Line_Price_Attributes_Tbl  ,
    P_Line_Price_Adj_rltship_Tbl  => P_Line_Price_Adj_rltship_Tbl ,
    P_Line_Price_Adj_Attr_Tbl     => P_Line_Price_Adj_Attr_Tbl    ,
    P_Line_Shipment_Tbl           => P_Line_Shipment_Tbl          ,
    P_Line_TAX_DETAIL_Tbl         => P_Line_TAX_DETAIL_Tbl        ,
    P_Line_FREIGHT_CHARGE_Tbl     => P_Line_FREIGHT_CHARGE_Tbl    ,
    P_Line_Rltship_Tbl            => P_Line_Rltship_Tbl           ,
    P_Line_sales_credit_TBL       => P_Line_sales_credit_TBL      ,
    P_Lot_serial_TBL              => P_Lot_serial_TBL             ,
    x_header_rec                  => l_header_rec                 ,
    x_header_val_rec              => l_header_val_rec             ,
    x_header_Adj_tbl              => l_header_Adj_tbl             ,
    x_header_Adj_val_tbl          => l_header_Adj_val_tbl         ,
    x_header_price_Att_tbl        => l_header_price_Att_tbl       ,
    x_header_Adj_Att_tbl          => l_header_Adj_Att_tbl         ,
    x_header_Adj_Assoc_tbl        => l_header_Adj_Assoc_tbl       ,
    x_header_Scredit_tbl          => l_header_Scredit_tbl         ,
    x_Header_Scredit_val_tbl      => l_Header_Scredit_val_tbl     ,
    x_Header_Payment_tbl          => l_Header_Payment_tbl         ,
    x_line_tbl                    => l_line_tbl                   ,
    x_line_val_tbl                => l_line_val_tbl               ,
    x_line_Adj_tbl                => l_line_Adj_tbl               ,
    x_line_Adj_val_tbl            => l_line_Adj_val_tbl           ,
    x_line_price_Att_tbl          => l_line_price_Att_tbl         ,
    x_line_Adj_Att_tbl            => l_line_Adj_Att_tbl           ,
    x_line_Adj_Assoc_tbl          => l_line_Adj_Assoc_tbl         ,
    x_line_Scredit_tbl            => l_line_Scredit_tbl           ,
    x_line_Scredit_val_tbl        => l_line_Scredit_val_tbl       ,
    x_lot_Serial_tbl              => l_lot_Serial_tbl             ,
    X_Lot_Serial_val_tbl          => l_Lot_Serial_val_tbl         ,
    x_Line_Payment_tbl            => l_Line_Payment_tbl
);

Line: 2549


 l_header_rec.operation := OE_Globals.G_OPR_UPDATE;

Line: 2638


aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');

Line: 2720


aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');

Line: 2823


END Update_Order;

Line: 3102


SELECT a.party_type
from
HZ_PARTIES a, HZ_PARTY_SITES b
where
a.status = 'A'
and b.party_site_id = p_party_site_id
and b.party_id = a.party_id;

Line: 3110


select a.site_use_id
from
hz_cust_site_uses_all a, hz_cust_acct_sites_all b
where
a.status = 'A'
and b.cust_account_id = p_cust_account_id
and b.party_site_id = p_party_site_id
and a.cust_acct_site_id = b.cust_acct_site_id
and a.site_use_code = p_acct_site_type;

Line: 3159


SELECT party_type
from
HZ_PARTIES
where party_id = p_party_id and status ='A';

Line: 3164


select a.org_contact_id
from
hz_org_contacts a, hz_relationships b
where
b.party_id = p_party_id
--and a.status = 'A' -- status column is obseleted
and b.relationship_id = a.party_relationship_id
and (sysdate between nvl(b.start_date, sysdate) and nvl(b.end_date, sysdate));

Line: 3173


select a.cust_account_role_id
from
hz_cust_account_roles a, hz_role_responsibility b, hz_cust_acct_sites_all c
where
a.role_type = 'CONTACT'
and a.party_id = p_party_id
and a.cust_account_id = p_cust_account_id
and a.cust_acct_site_id = c.cust_acct_site_id
and a.cust_account_id = c.cust_account_id
and c.party_site_id = p_party_site_id
and a.cust_account_role_id = b.cust_account_role_id
and responsibility_type = p_acct_site_type;

Line: 3235


     SELECT cust_account_id
     FROM hz_cust_accounts
     WHERE party_id = l_Party_Id
     and status = 'A';