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