DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_FNDCPT_USER_EFT_PF_B

Line 3521: l_user_pf_table_name :='IBY_FNDCPT_USER_EFT_PF_B';

3517: l_user_pf_column_name :='USER_CC_PROFILE_CODE';
3518: l_sys_pf_column_name :='SYS_CC_PROFILE_CODE';
3519: IF (instr_type IS NOT NULL) THEN
3520: if(instr_type =l_bankaccount) THEN
3521: l_user_pf_table_name :='IBY_FNDCPT_USER_EFT_PF_B';
3522: l_sys_pf_table_name :='IBY_FNDCPT_SYS_EFT_PF_B';
3523: l_user_pf_column_name :='USER_EFT_PROFILE_CODE';
3524: l_sys_pf_column_name :='SYS_EFT_PROFILE_CODE';
3525: ELSIF (instr_type =l_pinlessdebitcard) THEN

Line 4710: l_user_pf_table_name :='IBY_FNDCPT_USER_EFT_PF_B';

4706: l_user_pf_column_name :='USER_CC_PROFILE_CODE';
4707: l_sys_pf_column_name :='SYS_CC_PROFILE_CODE';
4708: IF (instr_type IS NOT NULL) THEN
4709: if(instr_type =l_bankaccount) THEN
4710: l_user_pf_table_name :='IBY_FNDCPT_USER_EFT_PF_B';
4711: l_sys_pf_table_name :='IBY_FNDCPT_SYS_EFT_PF_B';
4712: l_user_pf_column_name :='USER_EFT_PROFILE_CODE';
4713: l_sys_pf_column_name :='SYS_EFT_PROFILE_CODE';
4714: ELSIF (instr_type =l_pinlessdebitcard) THEN

Line 7462: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS

7458: iby_batches_all b
7459: WHERE up.sys_dc_profile_code = sp.sys_dc_profile_code
7460: AND up.user_dc_profile_code =c_user_profile;
7461:
7462: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS
7463: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
7464: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,
7465: iby_batches_all b
7466: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code

Line 7464: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,

7460: AND up.user_dc_profile_code =c_user_profile;
7461:
7462: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS
7463: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
7464: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,
7465: iby_batches_all b
7466: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
7467: AND up.user_eft_profile_code = c_user_profile;
7468: