128: AND ps.last_update_date BETWEEN l_from_date AND l_to_date
129:
130: UNION
131: SELECT ap.party_id
132: FROM hz_organization_profiles bapr,
133: hz_organization_profiles brpr,
134: hz_parties bp,
135: hz_party_sites s,
136: iby_account_owners ow,
129:
130: UNION
131: SELECT ap.party_id
132: FROM hz_organization_profiles bapr,
133: hz_organization_profiles brpr,
134: hz_parties bp,
135: hz_party_sites s,
136: iby_account_owners ow,
137: hz_parties br,