DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 607: hz_customer_profiles hcp

603:
604: Cursor default_payment_term_customer(l_cust_account_id NUMBER) Is
605: select hcp.standard_terms
606: from hz_cust_accounts hca,
607: hz_customer_profiles hcp
608: where hcp.cust_account_id = hca.cust_account_id
609: and hca.cust_account_id = l_cust_account_id
610: and nvl(hcp.status,'A') = 'A';
611: l_cust_acct_id number;