DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on HZ_PARTIES

Line 229: from hz_parties party,

225: Where r.customer_id = X_Customer_Id;
226: */
227: Select Nvl(cust_acct.status,'A')
228: into Pl_Status
229: from hz_parties party,
230: hz_cust_accounts cust_acct
231: Where
232: cust_acct.party_id = party.party_id
233: and cust_acct.cust_account_id = X_Customer_Id;