783: ||' : '||pay_type_tl.payment_type_name PAYMENT_TYPE
784: from pay_personal_payment_methods_f PPM,
785: pay_org_payment_methods_f_tl OPM_TL,
786: pay_org_payment_methods_f OPM,
787: pay_payment_types_tl PAY_TYPE_TL,
788: pay_payment_types PAY_TYPE
789: where personal_payment_method_id = p_personal_payment_method_id
790: and ppm.org_payment_method_id = opm.org_payment_method_id
791: and opm_tl.org_payment_method_id = opm.org_payment_method_id
784: from pay_personal_payment_methods_f PPM,
785: pay_org_payment_methods_f_tl OPM_TL,
786: pay_org_payment_methods_f OPM,
787: pay_payment_types_tl PAY_TYPE_TL,
788: pay_payment_types PAY_TYPE
789: where personal_payment_method_id = p_personal_payment_method_id
790: and ppm.org_payment_method_id = opm.org_payment_method_id
791: and opm_tl.org_payment_method_id = opm.org_payment_method_id
792: and USERENV('LANG') = opm_tl.language