DBA Data[Home] [Help]

APPS.OTA_TEA_BUS dependencies on HZ_PARTIES

Line 94: from hz_parties party, hz_cust_accounts cust_acct

90: procedure check_customer (p_customer_id number) is
91: --
92: cursor csr_customer is
93: select 1
94: from hz_parties party, hz_cust_accounts cust_acct
95: where cust_acct.party_id = party.party_id
96: and cust_acct.cust_account_id = p_customer_id;
97: --
98: l_customer_exists boolean;