DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 556: from IBY_EXT_PARTY_PMT_MTHDS ppm,

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

Line 575: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,

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

Line 598: from IBY_EXT_PARTY_PMT_MTHDS ppm,

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

Line 1739: IBY_EXT_PARTY_PMT_MTHDS pm,

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,

Line 1867: IBY_EXT_PARTY_PMT_MTHDS pm,

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,