[Home] [Help]
2624: AND NOT EXISTS (
2625: SELECT 'X'
2626: from hz_cust_accounts cust_acct,
2627: hz_parties party,
2628: so_agreements a,
2629: qp_lookups sl
2630: where a.agreement_type_code = sl.lookup_code
2631: and sl.lookup_type = 'QP_AGREEMENT_TYPE'
2632: and a.customer_id = cust_acct.cust_account_id(+)