DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_FNDCPT_SYS_EFT_PF_B

Line 3244: l_sys_pf_table_name :='IBY_FNDCPT_SYS_EFT_PF_B';

3240: l_sys_pf_column_name :='SYS_CC_PROFILE_CODE';
3241: IF (instr_type IS NOT NULL) THEN
3242: if(instr_type =l_bankaccount) THEN
3243: l_user_pf_table_name :='IBY_FNDCPT_USER_EFT_PF_B';
3244: l_sys_pf_table_name :='IBY_FNDCPT_SYS_EFT_PF_B';
3245: l_user_pf_column_name :='USER_EFT_PROFILE_CODE';
3246: l_sys_pf_column_name :='SYS_EFT_PROFILE_CODE';
3247: ELSIF (instr_type =l_pinlessdebitcard) THEN
3248: l_user_pf_table_name :='IBY_FNDCPT_USER_DC_PF_B';

Line 4364: l_sys_pf_table_name :='IBY_FNDCPT_SYS_EFT_PF_B';

4360: l_sys_pf_column_name :='SYS_CC_PROFILE_CODE';
4361: IF (instr_type IS NOT NULL) THEN
4362: if(instr_type =l_bankaccount) THEN
4363: l_user_pf_table_name :='IBY_FNDCPT_USER_EFT_PF_B';
4364: l_sys_pf_table_name :='IBY_FNDCPT_SYS_EFT_PF_B';
4365: l_user_pf_column_name :='USER_EFT_PROFILE_CODE';
4366: l_sys_pf_column_name :='SYS_EFT_PROFILE_CODE';
4367: ELSIF (instr_type =l_pinlessdebitcard) THEN
4368: l_user_pf_table_name :='IBY_FNDCPT_USER_DC_PF_B';

Line 6967: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,

6963: AND up.user_dc_profile_code =c_user_profile;
6964:
6965: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS
6966: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
6967: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,
6968: iby_batches_all b
6969: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
6970: AND up.user_eft_profile_code = c_user_profile;
6971: