APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_BATCHES_ALL

Line 622: FROM iby_trxn_summaries_all txn, iby_batches_all bat

618: l_ps_territory VARCHAR2(60);
619:
620: CURSOR l_instrument_type_csr (p_trxnmid IN NUMBER) IS
621: SELECT bat.instrument_type
622: FROM iby_trxn_summaries_all txn, iby_batches_all bat
623: WHERE txn.trxnmid = p_trxnmid
624: AND txn.mbatchid = bat.mbatchid;
625:
626: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS

Line 629: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

625:
626: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS
627: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
628: sys_pf.payer_notification_format
629: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
630: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf
631: WHERE txn.trxnmid = p_trxnmid
632: AND txn.mbatchid = bat.mbatchid
633: AND bat.process_profile_code = user_pf.user_eft_profile_code

Line 639: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

635:
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

Line 649: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

645:
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

Line 780: FROM iby_batches_all bat

776: IS
777:
778: CURSOR l_instrument_type_csr (p_batchid IN VARCHAR2) IS
779: SELECT bat.instrument_type
780: FROM iby_batches_all bat
781: WHERE bat.batchid = p_batchid;
782:
783: CURSOR l_eft_format_csr (p_batchid IN VARCHAR2) IS
784: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT, sys_pf.ACCOMPANY_LETTER_FORMAT

Line 785: FROM iby_batches_all bat,

781: WHERE bat.batchid = p_batchid;
782:
783: CURSOR l_eft_format_csr (p_batchid IN VARCHAR2) IS
784: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT, sys_pf.ACCOMPANY_LETTER_FORMAT
785: FROM iby_batches_all bat,
786: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf
787: WHERE bat.batchid = p_batchid
788: AND bat.process_profile_code = user_pf.user_eft_profile_code
789: AND user_pf.sys_eft_profile_code = sys_pf.sys_eft_profile_code;

Line 793: FROM iby_batches_all bat,

789: AND user_pf.sys_eft_profile_code = sys_pf.sys_eft_profile_code;
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;

Line 801: FROM iby_batches_all bat,

797: AND user_pf.sys_cc_profile_code = sys_pf.sys_cc_profile_code;
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;