DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on HZ_PARTY_SITES

Line 2171: hz_party_sites hzps

2167: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2168: UNION
2169: SELECT cal.fa_location_id fa_location_id
2170: FROM csi_a_locations cal,
2171: hz_party_sites hzps
2172: WHERE hzps.location_id = cal.location_id
2173: AND hzps.party_site_id = l_location_id -- Modified for bug 4149685
2174: AND l_location_type_code = 'HZ_PARTY_SITES'
2175: AND cal.location_table IN ('HZ_LOCATIONS','LOCATION_CODES')

Line 2174: AND l_location_type_code = 'HZ_PARTY_SITES'

2170: FROM csi_a_locations cal,
2171: hz_party_sites hzps
2172: WHERE hzps.location_id = cal.location_id
2173: AND hzps.party_site_id = l_location_id -- Modified for bug 4149685
2174: AND l_location_type_code = 'HZ_PARTY_SITES'
2175: AND cal.location_table IN ('HZ_LOCATIONS','LOCATION_CODES')
2176: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2177: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate ;
2178: