| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
<queryset> |
| |
3 |
3 |
<rdbms><type>oracle</type><version>8.1.6</version></rdbms> |
| |
4 |
4 |
|
| |
5 |
5 |
<fullquery name="check_sender"> |
| |
6 |
6 |
<querytext> |
| |
7 |
7 |
|
| |
8 |
8 |
select email as good_email from parties |
| |
9 |
9 |
where party_id = (select apv.attr_value |
| |
10 |
10 |
from apm_parameter_values apv, |
| |
11 |
11 |
apm_parameters ap |
| |
12 |
12 |
where ap.package_key = :package_key |
| |
13 |
13 |
and ap.parameter_name = 'NotificationSender' |
| |
14 |
14 |
and ap.parameter_id = apv.parameter_id) |
| |
15 |
15 |
|
| |
16 |
16 |
</querytext> |
| |
17 |
17 |
</fullquery> |
| |
18 |
18 |
|
| |
19 |
19 |
</queryset> |
