258: AND nvl(CARD_EXPIRYDATE, sysdate) >= sysdate
259: and
260: exists
261: (select msite_information1
262: from ibe_msite_information m, fnd_lookup_values b
263: where
264: m.msite_id =l_msite_id and
265: b.lookup_type = 'CREDIT_CARD' and
266: b.view_application_id = 660 and
282: AND nvl(CARD_EXPIRYDATE, sysdate) >= sysdate
283: and
284: exists
285: (select msite_information1
286: from ibe_msite_information m, fnd_lookup_values b
287: where
288: m.msite_id = l_msite_id and
289: b.lookup_type = 'CREDIT_CARD' and
290: (b.tag = 'Y' or b.tag is null) and