DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_FNDCPT_SYS_DC_PF_B

Line 650: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf

646: CURSOR l_dc_sra_setup_csr (p_trxnmid IN NUMBER) IS
647: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
648: sys_pf.payer_notification_format
649: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
650: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf
651: WHERE txn.trxnmid = p_trxnmid
652: AND txn.mbatchid = bat.mbatchid
653: AND bat.process_profile_code = user_pf.user_dc_profile_code
654: AND user_pf.sys_dc_profile_code = sys_pf.sys_dc_profile_code;

Line 802: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf

798:
799: CURSOR l_dc_format_csr (p_batchid IN VARCHAR2) IS
800: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT
801: FROM iby_batches_all bat,
802: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf
803: WHERE bat.batchid = p_batchid
804: AND bat.process_profile_code = user_pf.user_dc_profile_code
805: AND user_pf.sys_dc_profile_code = sys_pf.sys_dc_profile_code;
806: