APPS.ARI_SELF_REG_CONFIG dependencies on HZ_CUST_ACCOUNTS

Line 378: --If user searches by customer, get customer id from hz_cust_accounts

374: IS
375: l_customer_id NUMBER;
376: BEGIN
377:
378: --If user searches by customer, get customer id from hz_cust_accounts
379: IF p_search_type = 'CUSTOMER_NUMBER' THEN
380: SELECT cust_account_id
381: INTO l_customer_id
382: FROM hz_cust_accounts

Line 382: FROM hz_cust_accounts

378: --If user searches by customer, get customer id from hz_cust_accounts
379: IF p_search_type = 'CUSTOMER_NUMBER' THEN
380: SELECT cust_account_id
381: INTO l_customer_id
382: FROM hz_cust_accounts
383: where account_number = p_search_number;
384:
385: --If user searches by transactions, get customer id from ar_payment_schedules
386: ELSIF p_search_type = 'INVOICES' OR

Line 489: l_query_string := 'SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable, hz_cust_accounts hca WHERE rownum = 1 and hca.'||p_hz_join_column||' = anstable.'||p_answer_join_column||

485:
486:
487: if ( p_customer_id is not null and p_customer_site_use_id ='CUST_LEVEL') then
488:
489: l_query_string := 'SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable, hz_cust_accounts hca WHERE rownum = 1 and hca.'||p_hz_join_column||' = anstable.'||p_answer_join_column||
490: ' and hca.cust_account_id = '||p_customer_id;
491: elsif ( p_customer_site_use_id is not null ) then
492:
493: l_query_string := 'SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable,hz_party_sites hps, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu where hcsu.site_use_id =' || p_customer_site_use_id ||

Line 508: hz_cust_accounts Cust,

504: fnd_territories_vl Terr,
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

Line 558: --If user searches by customer, get customer id from hz_cust_accounts

554: IS
555: l_customer_id NUMBER;
556: l_account_number VARCHAR2(30);
557: BEGIN
558: --If user searches by customer, get customer id from hz_cust_accounts
559: arp_standard.debug('Enetered procedure get_customer_id_number..');
560: IF p_search_type = 'CUSTOMER_NUMBER' THEN
561: SELECT cust_account_id
562: INTO l_customer_id

Line 563: FROM hz_cust_accounts

559: arp_standard.debug('Enetered procedure get_customer_id_number..');
560: IF p_search_type = 'CUSTOMER_NUMBER' THEN
561: SELECT cust_account_id
562: INTO l_customer_id
563: FROM hz_cust_accounts
564: where account_number = p_search_number;
565:
566: l_account_number := p_search_number;
567:

Line 594: FROM hz_cust_accounts

590: END);
591:
592: SELECT account_number
593: INTO l_account_number
594: FROM hz_cust_accounts
595: where cust_account_id = l_customer_id;
596:
597: EXCEPTION
598: WHEN TOO_MANY_ROWS THEN