DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on HZ_PARTIES

Line 238: from hz_parties party,

234: Where r.customer_id = X_Customer_Id;
235: */
236: Select Nvl(cust_acct.status,'A')
237: into Pl_Status
238: from hz_parties party,
239: hz_cust_accounts cust_acct
240: Where
241: cust_acct.party_id = party.party_id
242: and cust_acct.cust_account_id = X_Customer_Id;