DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 612: hz_customer_profiles hcp

608:
609: Cursor default_payment_term_customer(l_cust_account_id NUMBER) Is
610: select hcp.standard_terms
611: from hz_cust_accounts hca,
612: hz_customer_profiles hcp
613: where hcp.cust_account_id = hca.cust_account_id
614: and hca.cust_account_id = l_cust_account_id
615: and nvl(hcp.status,'A') = 'A'
616: and site_use_id IS NULL;