APPS.ECE_TRADING_PARTNERS_PUB dependencies on HZ_CUST_ACCOUNTS

Line 126: hz_cust_accounts ca,

122: ca.account_number
123: INTO x_entity_id_out,x_tp_location_name_out,
124: x_translator_code_out
125: FROM hz_cust_acct_sites_all cas,
126: hz_cust_accounts ca,
127: hz_parties pt
128: WHERE cas.cust_acct_site_id = x_address_id_out
129: AND cas.cust_account_id = ca.cust_account_id
130: AND ca.party_id = pt.party_id;

Line 678: hz_cust_accounts ca,

674: TO_CHAR(NULL) region_3
675: FROM hz_cust_acct_sites_all cas,
676: hz_party_sites pts,
677: hz_locations loc,
678: hz_cust_accounts ca,
679: hz_parties pt
680: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND
681: -- cas.cust_acct_site_id = NVL(cp_address_id_in,cas.cust_acct_site_id) AND
682: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND

Line 2909: hz_cust_accounts ca,

2905: cursor ra_add is
2906: select cas.cust_account_id,
2907: cas.cust_acct_site_id
2908: from hz_cust_acct_sites cas,
2909: hz_cust_accounts ca,
2910: hz_parties pt,
2911: ece_tp_details etd
2912: where
2913: etd.translator_code = p_translator_code

Line 3134: hz_cust_accounts ca,

3130: cursor ra_add is
3131: select cas.cust_account_id,
3132: cas.cust_acct_site_id
3133: from hz_cust_acct_sites cas,
3134: hz_cust_accounts ca,
3135: hz_parties pt,
3136: ece_tp_headers eth
3137: where
3138: eth.tp_reference_ext1 = p_reference_ext1