728: SELECT hpu.party_site_use_id,
729: hpu1.party_site_use_id
730: INTO g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).bill_to_site_use_id,
731: g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).ship_to_site_use_id
732: FROM hz_party_sites hps,
733: hz_party_site_uses hpu,
734: hz_party_sites hps1,
735: hz_party_site_uses hpu1
736: WHERE hps.party_id = l_csd_recall_lines_tbl(l_index).owner_party_id
730: INTO g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).bill_to_site_use_id,
731: g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).ship_to_site_use_id
732: FROM hz_party_sites hps,
733: hz_party_site_uses hpu,
734: hz_party_sites hps1,
735: hz_party_site_uses hpu1
736: WHERE hps.party_id = l_csd_recall_lines_tbl(l_index).owner_party_id
737: AND hps.party_site_id = hpu.party_site_id
738: AND hpu.site_use_type = 'BILL_TO'
879: SELECT hpu.party_site_use_id,
880: hpu1.party_site_use_id
881: INTO g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).bill_to_site_use_id,
882: g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).ship_to_site_use_id
883: FROM hz_party_sites hps,
884: hz_party_site_uses hpu,
885: hz_party_sites hps1,
886: hz_party_site_uses hpu1
887: WHERE hps.party_id = l_csd_recall_lines_tbl(l_index).owner_party_id
881: INTO g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).bill_to_site_use_id,
882: g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).ship_to_site_use_id
883: FROM hz_party_sites hps,
884: hz_party_site_uses hpu,
885: hz_party_sites hps1,
886: hz_party_site_uses hpu1
887: WHERE hps.party_id = l_csd_recall_lines_tbl(l_index).owner_party_id
888: AND hps.party_site_id = hpu.party_site_id
889: AND hpu.site_use_type = 'BILL_TO'