APPS.CSD_RECALLS_PVT dependencies on HZ_PARTY_SITE_USES

Line 733: hz_party_site_uses hpu,

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
737: AND hps.party_site_id = hpu.party_site_id

Line 735: hz_party_site_uses hpu1

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'
739: AND hpu.primary_per_type = 'Y'

Line 884: hz_party_site_uses hpu,

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
888: AND hps.party_site_id = hpu.party_site_id

Line 886: hz_party_site_uses hpu1

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'
890: AND hpu.primary_per_type = 'Y'