DBA Data[Home] [Help]

APPS.PER_BF_PAYMENT_DETAILS_API dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 26: FROM pay_org_payment_methods_f opm

22: -- Cursor to retrieve the currency code from the org payment method
23: --
24: CURSOR csr_get_org_currency (l_ppm_id IN NUMBER) IS
25: SELECT opm.currency_code
26: FROM pay_org_payment_methods_f opm
27: ,pay_personal_payment_methods_f ppm
28: WHERE ppm.org_payment_method_id = opm.org_payment_method_id
29: AND ppm.personal_payment_method_id = l_ppm_id
30: AND p_effective_date BETWEEN