DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 639: from IBY_EXT_PARTY_PMT_MTHDS ppm,

635: AND (m.INACTIVE_DATE is null OR m.INACTIVE_DATE >= trunc(sysdate))
636: AND (am.INACTIVE_DATE is null OR am.INACTIVE_DATE >= trunc(sysdate))
637: AND am.PAYMENT_METHOD_CODE = m.PAYMENT_METHOD_CODE
638: AND NOT EXISTS (select 1
639: from IBY_EXT_PARTY_PMT_MTHDS ppm,
640: IBY_EXTERNAL_PAYEES_ALL payee
641: where ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
642: and ppm.PAYMENT_METHOD_CODE = am.PAYMENT_METHOD_CODE
643: and ppm.PAYMENT_FUNCTION = p_payment_function

Line 657: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,

653: ppm.PAYMENT_METHOD_CODE,
654: m.SUPPORT_BILLS_PAYABLE_FLAG,
655: m.MATURITY_DATE_OFFSET_DAYS,
656: m.DESCRIPTION
657: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,
658: IBY_EXTERNAL_PAYEES_ALL payee,
659: IBY_PAYMENT_METHODS_VL m
660: WHERE ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
661: AND ppm.PAYMENT_FUNCTION = p_payment_function

Line 680: from IBY_EXT_PARTY_PMT_MTHDS ppm,

676: pmthds.DESCRIPTION
677: FROM IBY_PAYMENT_METHODS_VL pmthds
678: WHERE (pmthds.inactive_date is NULL OR pmthds.inactive_date >= trunc(sysdate))
679: AND NOT EXISTS (select 1
680: from IBY_EXT_PARTY_PMT_MTHDS ppm,
681: IBY_EXTERNAL_PAYEES_ALL payee
682: where ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
683: and PAYMENT_METHOD_CODE = pmthds.PAYMENT_METHOD_CODE
684: and ppm.PAYMENT_FUNCTION = p_payment_function

Line 1940: IBY_EXT_PARTY_PMT_MTHDS pm,

1936: payee.settlement_priority,
1937: d.territory_code delivery_channel_country,
1938: r.territory_code payment_reason_country
1939: FROM IBY_EXTERNAL_PAYEES_ALL payee,
1940: IBY_EXT_PARTY_PMT_MTHDS pm,
1941: IBY_PAYMENT_METHODS_VL m,
1942: IBY_FORMATS_VL f,
1943: IBY_DELIVERY_CHANNELS_VL d,
1944: IBY_PAYMENT_REASONS_VL r,

Line 2069: IBY_EXT_PARTY_PMT_MTHDS pm,

2065: m.support_bills_payable_flag,
2066: m.maturity_date_offset_days
2067: FROM
2068: IBY_EXTERNAL_PAYEES_ALL payee,
2069: IBY_EXT_PARTY_PMT_MTHDS pm,
2070: IBY_PAYMENT_METHODS_VL m
2071: WHERE
2072: payee.ext_payee_id IN (
2073: p_payee1,