DBA Data[Home] [Help]

APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 74: FROM hz_cust_accounts cust_acct,

70: SELECT cust_acct.cust_account_id customer_id ,
71: cust_acct.account_number ,
72: party.party_name ,
73: party.tax_reference
74: FROM hz_cust_accounts cust_acct,
75: hz_parties party
76: WHERE cust_acct.party_id = party.party_id
77: AND (p_customer_name_from is null or
78: upper(party.party_name) >= upper(p_customer_name_from))