[Home] [Help]
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
31: opm.effective_start_date AND opm.effective_end_date