DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on IBY_FNDCPT_USER_EFT_PF_B

Line 593: FROM iby_fndcpt_user_eft_pf_b up

589: */
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:

Line 1042: FROM iby_fndcpt_user_eft_pf_b up

1038: */
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:

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