APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_FNDCPT_USER_CC_PF_B

Line 3028: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.

3024: | NOTES:
3025: |
3026: *---------------------------------------------------------------------*/
3027: PROCEDURE performTransactionGrouping(
3028: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
3029: user_cc_profile_code%TYPE,
3030: instr_type IN IBY_TRXN_SUMMARIES_ALL.
3031: instrtype%TYPE,
3032: req_type IN IBY_BATCHES_ALL.

Line 3225: IBY_FNDCPT_USER_CC_PF_B user_prof,

3221: sys_prof.limit_by_total_amt,
3222: sys_prof.limit_by_settlement_num
3223: FROM
3224: IBY_TRXN_SUMMARIES_ALL txn,
3225: IBY_FNDCPT_USER_CC_PF_B user_prof,
3226: IBY_FNDCPT_SYS_CC_PF_B sys_prof
3227: WHERE
3228: user_prof.user_cc_profile_code = p_profile_code AND
3229: txn.process_profile_code = user_prof.user_cc_profile_code AND

Line 3515: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';

3511:
3512: END IF;
3513: /* determine the process profile table and column */
3514:
3515: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';
3516: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_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

Line 4398: IBY_FNDCPT_USER_CC_PF_B user_prof,

4394: sys_prof.limit_by_total_amt,
4395: sys_prof.limit_by_settlement_num
4396: FROM
4397: IBY_TRXN_SUMMARIES_ALL txn,
4398: IBY_FNDCPT_USER_CC_PF_B user_prof,
4399: IBY_FNDCPT_SYS_CC_PF_B sys_prof
4400: WHERE
4401: user_prof.user_cc_profile_code IN (strProfiles) AND
4402: txn.process_profile_code = user_prof.user_cc_profile_code AND

Line 4704: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';

4700:
4701: END IF;
4702: /* determine the process profile table and column */
4703:
4704: l_user_pf_table_name :='IBY_FNDCPT_USER_CC_PF_B';
4705: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_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

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

7445: l_payer_notif_flag VARCHAR2(1);
7446: l_instrument_type iby_batches_all.instrument_type%TYPE;
7447:
7448:
7449: CURSOR c_payer_notif_cc (c_user_profile iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE) IS
7450: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
7451: FROM iby_fndcpt_user_cc_pf_b up, iby_fndcpt_sys_cc_pf_b sp
7452: WHERE up.sys_cc_profile_code = sp.sys_cc_profile_code
7453: AND up.user_cc_profile_code = c_user_profile;

Line 7451: FROM iby_fndcpt_user_cc_pf_b up, iby_fndcpt_sys_cc_pf_b sp

7447:
7448:
7449: CURSOR c_payer_notif_cc (c_user_profile iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE) IS
7450: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
7451: FROM iby_fndcpt_user_cc_pf_b up, iby_fndcpt_sys_cc_pf_b sp
7452: WHERE up.sys_cc_profile_code = sp.sys_cc_profile_code
7453: AND up.user_cc_profile_code = c_user_profile;
7454:
7455: CURSOR c_payer_notif_dc (c_user_profile iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE) IS