DBA Data[Home] [Help]

APPS.PAY_QPU_API dependencies on PAY_PAYMENT_TYPES

Line 249: , pay_payment_types typ

245: --
246: cursor csr_pay_type is
247: select 'Y'
248: from pay_org_payment_methods_f org
249: , pay_payment_types typ
250: where org.org_payment_method_id = p_org_payment_method_id
251: and typ.payment_type_id = org.payment_type_id
252: and typ.category = 'MT'
253: and p_effective_date between org.effective_start_date