DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on HZ_CUST_ACCOUNTS

Line 33: Pl_Status hz_cust_accounts.Status%type;

29: Pl_Ship_To_Contact_Id Number := X_Ship_To_Contact_Id; --for tracking bug by aditi changed from null to value being passed from pa_project_pub.update_project
30:
31: -- 4363092 TCA changes, replaced RA views with HZ tables
32: --Pl_Status Ra_customers.Status%type;
33: Pl_Status hz_cust_accounts.Status%type;
34: -- 4363092 end
35:
36: l_address_id Number;
37: l_contact_id Number;

Line 230: hz_cust_accounts cust_acct

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;
234: