DBA Data[Home] [Help]

APPS.EC_INBOUND_STAGE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1147: Replaced ra_addresses with hz_cust_acct_sites_all

1143: i_data_length number;
1144:
1145:
1146: /* Bug 1966138.
1147: Replaced ra_addresses with hz_cust_acct_sites_all
1148: to improve performance*/
1149: CURSOR c_cust_addr
1150: (
1151: i_translator_code IN varchar2,

Line 1158: hz_cust_acct_sites_all hcas,

1154: )
1155: IS
1156: select tp_code
1157: from ece_tp_details td,
1158: hz_cust_acct_sites_all hcas,
1159: ece_tp_headers th
1160: where td.translator_code = i_translator_code and
1161: hcas.ece_tp_location_code = i_location_code and
1162: hcas.tp_header_id = td.tp_header_id and