DBA Data[Home] [Help]

APPS.ARI_SELF_REG_CONFIG dependencies on HZ_PARTIES

Line 212: l_customer_name hz_parties.party_name%type;

208: PROCEDURE validate_cust_detail_access( p_customer_id IN VARCHAR2,
209: x_verify_access OUT NOCOPY ARI_SELF_REGISTRATION_PKG.VerifyAccessTable,
210: x_attempts OUT NOCOPY NUMBER)
211: IS
212: l_customer_name hz_parties.party_name%type;
213: BEGIN
214: /*
215: Customize this portion to specify the parameters for different
216: customers

Line 236: from hz_parties party, hz_cust_accounts cust

232:
233: --Find Customer Name
234: select party_name
235: into l_customer_name
236: from hz_parties party, hz_cust_accounts cust
237: where cust.cust_account_id = p_customer_id
238: and cust.party_id = party.party_id;
239:
240: --Use existing message/define new nessage for the question.