DBA Data[Home] [Help]

APPS.OTA_TEA_BUS dependencies on HZ_CUST_ACCOUNTS

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;

Line 118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');

114: --
115: if not l_customer_exists then
116: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
117: fnd_message.set_token('COLUMN_NAME','CUST_ACCOUNT_ID');
118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');
119: fnd_message.raise_error;
120: end if;
121: --
122: end check_customer;