APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_BEPKEYS

Line 271: l_bepkey iby_bepkeys.key%TYPE;

267: l_ar_msg_count NUMBER;
268: l_ar_msg_data VARCHAR2(2000);
269: l_ship_to_zip VARCHAR2(80);
270: l_ship_to_country VARCHAR2(10);
271: l_bepkey iby_bepkeys.key%TYPE;
272:
273: cursor level2_trxn is
274: select ts.instrtype,
275: tc.card_data_level,

Line 364: IBY_BEPKEYS key,

360: INTO
361: l_security_code
362: FROM
363: IBY_BEP_ACCT_OPT_VALS val,
364: IBY_BEPKEYS key,
365: IBY_PAYEE payee
366: WHERE
367: val.bep_account_id = key.bep_account_id
368: AND payee.payeeid = key.ownerid

Line 386: -- Added another filter condition with IBY_BEPKEYS

382: * linked to the payee account (not by the
383: * payee id itself).
384: */
385: --Bug# 13977390
386: -- Added another filter condition with IBY_BEPKEYS
387: SELECT
388: COUNT(*)
389: INTO
390: l_batch_count

Line 393: IBY_BEPKEYS bepkey,

389: INTO
390: l_batch_count
391: FROM
392: IBY_BEP_ACCT_OPT_VALS val,
393: IBY_BEPKEYS bepkey,
394: IBY_PAYEE payee,
395: IBY_BATCHES_ALL batch
396: WHERE
397: val.account_option_code = 'SEC_CODE'

Line 1052: ,iby_bepkeys keys

1048: is
1049: select vals.account_option_code
1050: ,vals.account_option_value
1051: from iby_trxn_summaries_all ts
1052: ,iby_bepkeys keys
1053: ,iby_bep_acct_opt_vals vals
1054: ,iby_payee payee
1055: where ts.trxnmid = ci_trxnmid
1056: and ts.payeeid = payee.payeeid