98: ,p_program_id
99: ,p_request_id
100: ,p_program_update_date
101: ,p_org_id
102: FROM FND_LANGUAGES L
103: WHERE L.INSTALLED_FLAG IN ('I', 'B')
104: and not exists
105: ( select null
106: from oe_payment_types_tl t
790: B.PROGRAM_ID,
791: B.REQUEST_ID,
792: L.LANGUAGE_CODE,
793: B.SOURCE_LANG
794: from OE_PAYMENT_TYPES_TL B, FND_LANGUAGES L
795: where L.INSTALLED_FLAG in ('I', 'B')
796: and B.LANGUAGE = userenv('LANG')
797: and not exists
798: (select NULL