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_PAYGROUP_PUB dependencies on CE_BANK_BRANCHES_V

Line 18104: l_country CE_BANK_BRANCHES_V.country%TYPE;

18100:
18101:
18102: int_bnk_index VARCHAR2(2000);
18103: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
18104: l_country CE_BANK_BRANCHES_V.country%TYPE;
18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;

Line 18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;

18101:
18102: int_bnk_index VARCHAR2(2000);
18103: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
18104: l_country CE_BANK_BRANCHES_V.country%TYPE;
18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;

Line 18123: p_country CE_BANK_BRANCHES_V.country%TYPE)

18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
18123: p_country CE_BANK_BRANCHES_V.country%TYPE)
18124: IS
18125: SELECT DISTINCT
18126: val_asgn.validation_assignment_id,
18127: val_asgn.val_assignment_entity_type,

Line 18240: FROM CE_BANK_ACCOUNTS cba, CE_BANK_BRANCHES_V cb

18236: INTO l_int_bank_acct_id,
18237: l_country,
18238: l_bank_home_country,
18239: l_allow_zero_pmt_flag
18240: FROM CE_BANK_ACCOUNTS cba, CE_BANK_BRANCHES_V cb
18241: WHERE cba.bank_branch_id = cb.branch_party_id
18242: AND cba.bank_account_id = IBY_PAYGROUP_PUB.pmtTable.INTERNAL_BANK_ACCOUNT_ID(l_trx_valid_index);
18243:
18244:

Line 24040: CE_BANK_BRANCHES_V iba_bnk_branch,

24036: FROM
24037:
24038: /* Payer bank */
24039: CE_BANK_ACCOUNTS iba,
24040: CE_BANK_BRANCHES_V iba_bnk_branch,
24041: HZ_PARTY_SITES iba_branch_party_site,
24042: /* RFC */
24043: HZ_CODE_ASSIGNMENTS rfc_ca
24044:

Line 25417: CE_BANK_BRANCHES_V eba_bank_branch

25413: FROM
25414: /* Payee bank */
25415: IBY_EXT_BANK_ACCOUNTS_V eba,
25416: IBY_EXT_BANK_ACCOUNTS ext_ba_table,
25417: CE_BANK_BRANCHES_V eba_bank_branch
25418:
25419: WHERE
25420: /* payee bank */
25421: IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id(l_trx_index) = eba.ext_bank_account_id(+)

Line 25448: CE_BANK_BRANCHES_V EBA_BANK_BRANCH,

25444: EBA.BANK_ACCOUNT_NUM_ELECTRONIC,
25445: hzps.LOCATION_ID BANK_BRANCH_ADDRESS_ID,
25446: hzp.party_name PRIMARY_ACCT_OWNER_NAME
25447: FROM IBY_EXT_BANK_ACCOUNTS EBA,
25448: CE_BANK_BRANCHES_V EBA_BANK_BRANCH,
25449: IBY_ACCOUNT_OWNERS OW,
25450: HZ_PARTIES hzp,
25451: HZ_PARTY_SITES hzps
25452: WHERE IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id(l_trx_index) = EBA.EXT_BANK_ACCOUNT_ID(+)