APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_FNDCPT_SYS_CC_PF_B

Line 46: FROM iby_validation_sets_b vs, iby_fndcpt_sys_cc_pf_b pf,

42:
43: CURSOR c_valsets(ci_bep_id iby_trxn_summaries_all.bepid%TYPE)
44: IS
45: SELECT validation_code_package, validation_code_entry_point
46: FROM iby_validation_sets_b vs, iby_fndcpt_sys_cc_pf_b pf,
47: iby_val_assignments va
48: WHERE (vs.validation_code_language = 'PLSQL')
49: AND (vs.validation_level_code = 'INSTRUCTION' )
50: AND (pf.payment_system_id = ci_bep_id)

Line 2960: IBY_FNDCPT_SYS_CC_PF_B sys_prof

2956: sys_prof.limit_by_settlement_num
2957: FROM
2958: IBY_TRXN_SUMMARIES_ALL txn,
2959: IBY_FNDCPT_USER_CC_PF_B user_prof,
2960: IBY_FNDCPT_SYS_CC_PF_B sys_prof
2961: WHERE
2962: user_prof.user_cc_profile_code = p_profile_code AND
2963: txn.process_profile_code = user_prof.user_cc_profile_code AND
2964: sys_prof.sys_cc_profile_code = user_prof.sys_cc_profile_code AND

Line 3238: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_PF_B';

3234:
3235: /* determine the process profile table and column */
3236:
3237: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';
3238: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_PF_B';
3239: l_user_pf_column_name :='USER_CC_PROFILE_CODE';
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

Line 4078: IBY_FNDCPT_SYS_CC_PF_B sys_prof

4074: sys_prof.limit_by_settlement_num
4075: FROM
4076: IBY_TRXN_SUMMARIES_ALL txn,
4077: IBY_FNDCPT_USER_CC_PF_B user_prof,
4078: IBY_FNDCPT_SYS_CC_PF_B sys_prof
4079: WHERE
4080: user_prof.user_cc_profile_code IN (strProfiles) AND
4081: txn.process_profile_code = user_prof.user_cc_profile_code AND
4082: sys_prof.sys_cc_profile_code = user_prof.sys_cc_profile_code AND

Line 4358: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_PF_B';

4354:
4355: /* determine the process profile table and column */
4356:
4357: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';
4358: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_PF_B';
4359: l_user_pf_column_name :='USER_CC_PROFILE_CODE';
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

Line 6954: FROM iby_fndcpt_user_cc_pf_b up, iby_fndcpt_sys_cc_pf_b sp

6950:
6951:
6952: CURSOR c_payer_notif_cc (c_user_profile iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE) IS
6953: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
6954: FROM iby_fndcpt_user_cc_pf_b up, iby_fndcpt_sys_cc_pf_b sp
6955: WHERE up.sys_cc_profile_code = sp.sys_cc_profile_code
6956: AND up.user_cc_profile_code = c_user_profile;
6957:
6958: CURSOR c_payer_notif_dc (c_user_profile iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE) IS