eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 239: IBY_EXTERNAL_PAYEES_ALL ibypayee

235: b.payment_factor_flag,
236: b.eft_swift_code
237: FROM IBY_PMT_INSTR_USES_ALL ibyu,
238: IBY_EXT_BANK_ACCOUNTS_V b,
239: IBY_EXTERNAL_PAYEES_ALL ibypayee
240: WHERE ibyu.instrument_id = b.ext_bank_account_id
241: AND ibyu.instrument_type = 'BANKACCOUNT'
242: AND (b.currency_code = p_payment_currency OR b.currency_code is null)
243: AND ibyu.ext_pmt_party_id = ibypayee.ext_payee_id

Line 557: IBY_EXTERNAL_PAYEES_ALL payee

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
561: and ppm.INACTIVE_DATE < trunc(sysdate)

Line 576: IBY_EXTERNAL_PAYEES_ALL payee,

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
580: AND (ppm.INACTIVE_DATE is null OR ppm.INACTIVE_DATE >= trunc(sysdate))

Line 599: IBY_EXTERNAL_PAYEES_ALL payee

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
603: and ppm.INACTIVE_DATE < trunc(sysdate)

Line 1682: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1678:
1679: l_pay_alone VARCHAR2(1);
1680: l_payment_reason_comments VARCHAR2(240);
1681:
1682: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1683: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1684: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1685: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1686:

Line 1683: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1679: l_pay_alone VARCHAR2(1);
1680: l_payment_reason_comments VARCHAR2(240);
1681:
1682: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1683: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1684: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1685: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1686:
1687:

Line 1684: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1680: l_payment_reason_comments VARCHAR2(240);
1681:
1682: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1683: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1684: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1685: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1686:
1687:
1688: CURSOR payee_override_ent_cur IS

Line 1685: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1681:
1682: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1683: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1684: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1685: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1686:
1687:
1688: CURSOR payee_override_ent_cur IS
1689: SELECT payment_method_at_payee_flag

Line 1738: FROM IBY_EXTERNAL_PAYEES_ALL payee,

1734: payee.exclusive_payment_flag,
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,

Line 1817: IBY_EXTERNAL_PAYEES_ALL payee,

1813: payee.settlement_priority,
1814: d.territory_code delivery_channel_country,
1815: r.territory_code payment_reason_country
1816: FROM
1817: IBY_EXTERNAL_PAYEES_ALL payee,
1818: IBY_FORMATS_VL f,
1819: IBY_DELIVERY_CHANNELS_VL d,
1820: IBY_PAYMENT_REASONS_VL r
1821: WHERE

Line 1866: IBY_EXTERNAL_PAYEES_ALL payee,

1862: m.payment_method_name,
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 (

Line 1938: IBY_EXTERNAL_PAYEES_ALL ibypayee

1934: b.payment_factor_flag,
1935: b.eft_swift_code
1936: FROM IBY_PMT_INSTR_USES_ALL ibyu,
1937: IBY_EXT_BANK_ACCOUNTS_V b,
1938: IBY_EXTERNAL_PAYEES_ALL ibypayee
1939: WHERE ibyu.instrument_id = b.ext_bank_account_id
1940: AND ibyu.instrument_type = 'BANKACCOUNT'
1941: AND (b.currency_code = p_payment_currency
1942: OR b.currency_code is null)

Line 2393: IBY_EXTERNAL_PAYEES_ALL ibypayee

2389: b.payment_factor_flag,
2390: b.eft_swift_code
2391: FROM IBY_PMT_INSTR_USES_ALL ibyu,
2392: IBY_EXT_BANK_ACCOUNTS_V b,
2393: IBY_EXTERNAL_PAYEES_ALL ibypayee
2394: WHERE ibyu.instrument_id = b.ext_bank_account_id
2395: AND ibyu.instrument_type = 'BANKACCOUNT'
2396: AND (b.currency_code = p_payment_currency
2397: OR b.currency_code is null)