[Home] [Help]
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
1163: td.tp_header_id = th.tp_header_id and
1178: IS
1179: select tp_code
1180: from ece_tp_details td,
1181: ra_addresses ra,
1182: ece_tp_headers th
1183: where td.translator_code = i_translator_code and
1184: ra.ece_tp_location_code = i_location_code and
1185: ra.tp_header_id = td.tp_header_id and
1186: td.tp_header_id = th.tp_header_id and
1197: IS
1198: select tp_code
1199: from ece_tp_details td,
1200: po_vendor_sites pvs,
1201: ece_tp_headers th
1202: where td.translator_code = i_translator_code and
1203: pvs.ece_tp_location_code = i_location_code and
1204: pvs.tp_header_id = td.tp_header_id and
1205: th.tp_header_id = td.tp_header_id and
1215: IS
1216: select tp_code
1217: from ece_tp_details td,
1218: ap_bank_branches abb,
1219: ece_tp_headers th
1220: where td.translator_code = i_translator_code and
1221: abb.ece_tp_location_code = i_location_code and
1222: abb.tp_header_id = td.tp_header_id and
1223: th.tp_header_id = td.tp_header_id and
1234: IS
1235: select tp_code
1236: from ece_tp_details td,
1237: hr_locations hrl,
1238: ece_tp_headers th
1239: where td.translator_code = i_translator_code and
1240: hrl.ece_tp_location_code = i_location_code and
1241: hrl.tp_header_id = td.tp_header_id and
1242: th.tp_header_id = td.tp_header_id and