APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 1198: SELECT EXT_PAYEE_ID FROM IBY_EXTERNAL_PAYEES_ALL

1194: WHERE instrument_type = 'BANKACCOUNT'
1195: AND INSTRUMENT_ID = l_docs_tab(i).ext_bank_acct_id
1196: AND payment_flow = 'DISBURSEMENTS'
1197: AND EXT_PMT_PARTY_ID IN (
1198: SELECT EXT_PAYEE_ID FROM IBY_EXTERNAL_PAYEES_ALL
1199: WHERE PAYEE_PARTY_ID = l_docs_tab(i).payee_party_id
1200: AND(
1201: (supplier_site_id = l_docs_tab(i).supplier_site_id AND nvl(party_site_id,-99) = nvl(l_docs_tab(i).party_site_id,-99)
1202: AND org_id = l_docs_tab(i).org_id AND org_type = l_docs_tab(i).org_type)

Line 1450: * -1. The user is expected to seed the IBY_EXTERNAL_PAYEES_ALL

1446: * ext payee id for the document, then the ext payee id
1447: * would be set to -1 for that document.
1448: *
1449: * Fail all document that have the ext payee id set to
1450: * -1. The user is expected to seed the IBY_EXTERNAL_PAYEES_ALL
1451: * table such that the ext payee id is always available for
1452: * payee context on the document (otherwise, the
1453: * document cannot be paid!).
1454: */

Line 6507: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

6503: l_return_flag BOOLEAN;
6504: l_module_name CONSTANT VARCHAR2(200)
6505: := G_PKG_NAME || '.checkProfileFormatCompat';
6506:
6507: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
6508: l_payee_format_cd IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
6509:
6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;

Line 6508: l_payee_format_cd IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;

6504: l_module_name CONSTANT VARCHAR2(200)
6505: := G_PKG_NAME || '.checkProfileFormatCompat';
6506:
6507: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
6508: l_payee_format_cd IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
6509:
6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
6512: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;

Line 6590: FROM IBY_EXTERNAL_PAYEES_ALL payee

6586: print_debuginfo(l_module_name, 'Getting the data from DB For Payee Id: ' || p_payee_id);
6587: END IF;
6588: SELECT payee.ext_payee_id, payee.payment_format_code
6589: INTO l_payee_id, l_payee_format_cd
6590: FROM IBY_EXTERNAL_PAYEES_ALL payee
6591: WHERE payee.ext_payee_id = p_payee_id;
6592:
6593:
6594: EXCEPTION