APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_FNDCPT_USER_CC_PF_B

Line 2762: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.

2758: | NOTES:
2759: |
2760: *---------------------------------------------------------------------*/
2761: PROCEDURE performTransactionGrouping(
2762: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
2763: user_cc_profile_code%TYPE,
2764: instr_type IN IBY_TRXN_SUMMARIES_ALL.
2765: instrtype%TYPE,
2766: req_type IN IBY_BATCHES_ALL.

Line 2959: IBY_FNDCPT_USER_CC_PF_B user_prof,

2955: sys_prof.limit_by_total_amt,
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

Line 3237: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';

3233: || l_sql_str);
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

Line 4077: IBY_FNDCPT_USER_CC_PF_B user_prof,

4073: sys_prof.limit_by_total_amt,
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

Line 4357: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';

4353: || l_sql_str);
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

Line 6952: CURSOR c_payer_notif_cc (c_user_profile iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE) IS

6948: l_payer_notif_flag VARCHAR2(1);
6949: l_instrument_type iby_batches_all.instrument_type%TYPE;
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;

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