[Home] [Help]
718: ci_payer_equiv IN VARCHAR2,
719: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
720: IS
721: SELECT c.instrument_type
722: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
723: WHERE (c.payment_channel_code = ci_channel_code)
724: AND (pm.payment_method_code = c.payment_channel_code)
725: AND (NVL(pm.inactive_date,SYSDATE-10)