eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARI_SELF_REG_CONFIG dependencies on HZ_PARTIES

Line 269: l_customer_name hz_parties.party_name%type;

265: PROCEDURE validate_cust_detail_access( p_customer_id IN VARCHAR2,
266: x_verify_access OUT NOCOPY ARI_SELF_REGISTRATION_PKG.VerifyAccessTable,
267: x_attempts OUT NOCOPY NUMBER)
268: IS
269: l_customer_name hz_parties.party_name%type;
270: l_answer varchar2(200);
271: i PLS_INTEGER := 1 ;
272:
273: BEGIN

Line 509: hz_parties Party,

505: hz_cust_acct_sites acct_sites,
506: hz_party_sites party_sites,
507: hz_locations loc,
508: hz_cust_accounts Cust,
509: hz_parties Party,
510: hz_cust_site_uses site_uses
511: WHERE Party.party_id = Cust.party_id
512: AND Cust.account_number = p_customer_id
513: AND Cust.cust_account_id = acct_sites.cust_account_id