DBA Data[Home] [Help]

APPS.IGF_SL_GEN dependencies on HZ_LOCATIONS

Line 960: hz_locations l ,

956: l.country,
957: l.postal_code,
958: l.last_update_date
959: FROM hz_party_sites ps,
960: hz_locations l ,
961: igs_pe_hz_pty_sites ihps
962: WHERE ps.location_id = l.location_id
963: AND ps.party_site_id = ihps.party_site_id(+)
964: AND ps.identifying_address_flag = cp_identifying_address_flag

Line 1013: hz_locations l,

1009: l.country,
1010: l.postal_code,
1011: l.last_update_date
1012: FROM hz_party_sites ps,
1013: hz_locations l,
1014: hz_party_site_uses psu
1015: WHERE ps.location_id = l.location_id
1016: AND ps.party_site_id = psu.party_site_id
1017: AND psu.status = cp_status