DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_FNDCPT_USER_CC_PF_B

Line 640: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf

636: CURSOR l_cc_sra_setup_csr (p_trxnmid IN NUMBER) IS
637: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
638: sys_pf.payer_notification_format
639: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
640: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf
641: WHERE txn.trxnmid = p_trxnmid
642: AND txn.mbatchid = bat.mbatchid
643: AND bat.process_profile_code = user_pf.user_cc_profile_code
644: AND user_pf.sys_cc_profile_code = sys_pf.sys_cc_profile_code;

Line 794: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf

790:
791: CURSOR l_cc_format_csr (p_batchid IN VARCHAR2) IS
792: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT
793: FROM iby_batches_all bat,
794: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf
795: WHERE bat.batchid = p_batchid
796: AND bat.process_profile_code = user_pf.user_cc_profile_code
797: AND user_pf.sys_cc_profile_code = sys_pf.sys_cc_profile_code;
798: