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 239: hz_cust_accounts cust_acct

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