APPS.IBY_TRANSACTIONEFT_PKG dependencies on IBY_FNDCPT_SYS_EFT_PF_B

Line 476: l_system_prof_code iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%type;

472: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
473:
474: l_index NUMBER;
475:
476: l_system_prof_code iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%type;
477:
478: BEGIN
479:
480: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 594: ,iby_fndcpt_sys_eft_pf_b sp

590:
591: SELECT sp.funds_xfer_format_code
592: INTO l_system_prof_code
593: FROM iby_fndcpt_user_eft_pf_b up
594: ,iby_fndcpt_sys_eft_pf_b sp
595: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
596: AND up.user_eft_profile_code = profile_code_in;
597:
598: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 895: l_system_prof_code iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%type;

891: TYPE dyn_transactions IS REF CURSOR;
892: l_trxn_cursor dyn_transactions;
893:
894: l_index NUMBER;
895: l_system_prof_code iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%type;
896:
897: BEGIN
898:
899: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1043: ,iby_fndcpt_sys_eft_pf_b sp

1039:
1040: SELECT sp.funds_xfer_format_code
1041: INTO l_system_prof_code
1042: FROM iby_fndcpt_user_eft_pf_b up
1043: ,iby_fndcpt_sys_eft_pf_b sp
1044: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
1045: AND up.user_eft_profile_code = profile_code_array(1);
1046:
1047: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1758: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp

1754: -- of the same request type
1755:
1756: CURSOR c_payer_notif_eft (i_user_fcpp_code iby_trxn_summaries_all.process_profile_code%TYPE) IS
1757: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
1758: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp
1759: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
1760: AND up.user_eft_profile_code = i_user_fcpp_code;
1761:
1762: BEGIN

Line 2122: p_funds_xfer_format_code IN iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%TYPE

2118: PROCEDURE validate_open_batch
2119: (
2120: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
2121: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
2122: p_funds_xfer_format_code IN iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%TYPE
2123: )
2124: IS
2125:
2126: l_call_string VARCHAR2(1000);

Line 2137: FROM iby_validation_sets_b vs, iby_fndcpt_sys_eft_pf_b pf,

2133:
2134: CURSOR c_valsets
2135: IS
2136: SELECT distinct validation_code_package, validation_code_entry_point
2137: FROM iby_validation_sets_b vs, iby_fndcpt_sys_eft_pf_b pf,
2138: iby_val_assignments va
2139: WHERE (vs.validation_code_language = 'PLSQL')
2140: AND (vs.validation_level_code = 'INSTRUCTION' )
2141: -- AND (pf.payment_system_id = ci_bep_id)