APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 481: FROM hz_cust_site_uses_all hcs

477: ,p_account_header_tbl(tab_row).bill_to_city
478: ,p_account_header_tbl(tab_row).bill_to_state
479: ,p_account_header_tbl(tab_row).bill_to_postal_code
480: ,p_account_header_tbl(tab_row).bill_to_country
481: FROM hz_cust_site_uses_all hcs
482: ,hz_cust_acct_sites_all hca
483: ,hz_party_sites hps
484: ,hz_locations hl
485: WHERE hcs.cust_acct_site_id=hca.cust_acct_site_id

Line 512: FROM hz_cust_site_uses_all hcs

508: ,p_account_header_tbl(tab_row).ship_to_city
509: ,p_account_header_tbl(tab_row).ship_to_state
510: ,p_account_header_tbl(tab_row).ship_to_postal_code
511: ,p_account_header_tbl(tab_row).ship_to_country
512: FROM hz_cust_site_uses_all hcs
513: ,hz_cust_acct_sites_all hca
514: ,hz_party_sites hps
515: ,hz_locations hl
516: WHERE hcs.cust_acct_site_id=hca.cust_acct_site_id

Line 531: FROM hz_cust_site_uses_all

527: /* Commented for bug 2670371
528: BEGIN
529: SELECT location
530: INTO p_account_header_tbl(tab_row).bill_to_location
531: FROM hz_cust_site_uses_all
532: WHERE site_use_id = p_account_header_tbl(tab_row).bill_to_address
533: AND site_use_code = 'BILL_TO';
534: EXCEPTION
535: WHEN no_data_found THEN

Line 542: FROM hz_cust_site_uses_all

538:
539: BEGIN
540: SELECT location
541: INTO p_account_header_tbl(tab_row).ship_to_location
542: FROM hz_cust_site_uses_all
543: WHERE site_use_id = p_account_header_tbl(tab_row).ship_to_address
544: AND site_use_code = 'SHIP_TO';
545: EXCEPTION
546: WHEN no_data_found THEN