APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_FNDCPT_SYS_CC_PF_B

Line 49: FROM iby_validation_sets_b vs, iby_fndcpt_sys_cc_pf_b pf,

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

Line 3226: IBY_FNDCPT_SYS_CC_PF_B sys_prof

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
3230: sys_prof.sys_cc_profile_code = user_prof.sys_cc_profile_code AND

Line 3516: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_PF_B';

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
3520: if(instr_type =l_bankaccount) THEN

Line 4399: IBY_FNDCPT_SYS_CC_PF_B sys_prof

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
4403: sys_prof.sys_cc_profile_code = user_prof.sys_cc_profile_code AND

Line 4705: l_sys_pf_table_name :='IBY_FNDCPT_SYS_CC_PF_B';

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
4709: if(instr_type =l_bankaccount) THEN

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