552: AND (am.APPLICATION_ID is null OR am.APPLICATION_ID = p_application_id)
553: AND (am.INACTIVE_DATE is null OR am.INACTIVE_DATE >= trunc(sysdate))
554: AND am.PAYMENT_METHOD_CODE = m.PAYMENT_METHOD_CODE
555: AND NOT EXISTS (select 1
556: from IBY_EXT_PARTY_PMT_MTHDS ppm,
557: IBY_EXTERNAL_PAYEES_ALL payee
558: where ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
559: and ppm.PAYMENT_METHOD_CODE = am.PAYMENT_METHOD_CODE
560: and ppm.PAYMENT_FUNCTION = p_payment_function
571: ppm.PAYMENT_METHOD_CODE,
572: m.SUPPORT_BILLS_PAYABLE_FLAG,
573: m.MATURITY_DATE_OFFSET_DAYS,
574: m.DESCRIPTION
575: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,
576: IBY_EXTERNAL_PAYEES_ALL payee,
577: IBY_PAYMENT_METHODS_VL m
578: WHERE ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
579: AND ppm.PAYMENT_FUNCTION = p_payment_function
594: pmthds.DESCRIPTION
595: FROM IBY_PAYMENT_METHODS_VL pmthds
596: WHERE (pmthds.inactive_date is NULL OR pmthds.inactive_date >= trunc(sysdate))
597: AND NOT EXISTS (select 1
598: from IBY_EXT_PARTY_PMT_MTHDS ppm,
599: IBY_EXTERNAL_PAYEES_ALL payee
600: where ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
601: and PAYMENT_METHOD_CODE = pmthds.PAYMENT_METHOD_CODE
602: and ppm.PAYMENT_FUNCTION = p_payment_function
1735: payee.settlement_priority,
1736: d.territory_code delivery_channel_country,
1737: r.territory_code payment_reason_country
1738: FROM IBY_EXTERNAL_PAYEES_ALL payee,
1739: IBY_EXT_PARTY_PMT_MTHDS pm,
1740: IBY_PAYMENT_METHODS_VL m,
1741: IBY_FORMATS_VL f,
1742: IBY_DELIVERY_CHANNELS_VL d,
1743: IBY_PAYMENT_REASONS_VL r,
1863: m.support_bills_payable_flag,
1864: m.maturity_date_offset_days
1865: FROM
1866: IBY_EXTERNAL_PAYEES_ALL payee,
1867: IBY_EXT_PARTY_PMT_MTHDS pm,
1868: IBY_PAYMENT_METHODS_VL m
1869: WHERE
1870: payee.ext_payee_id IN (
1871: p_payee1,