APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_BATCHES_ALL

Line 734: FROM iby_trxn_summaries_all txn, iby_batches_all bat

730: l_email_sub VARCHAR2(200);
731:
732: CURSOR l_instrument_type_csr (p_trxnmid IN NUMBER) IS
733: SELECT bat.instrument_type
734: FROM iby_trxn_summaries_all txn, iby_batches_all bat
735: WHERE txn.trxnmid = p_trxnmid
736: AND txn.mbatchid = bat.mbatchid;
737:
738: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS

Line 741: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

737:
738: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS
739: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
740: sys_pf.payer_notification_format, sys_pf.PAYER_NOTIFICATION_CONDITION, sys_pf.PN_COND_NUM_OF_RECEIPTS
741: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
742: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf
743: WHERE txn.trxnmid = p_trxnmid
744: AND txn.mbatchid = bat.mbatchid
745: AND bat.process_profile_code = user_pf.user_eft_profile_code

Line 751: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

747:
748: CURSOR l_cc_sra_setup_csr (p_trxnmid IN NUMBER) IS
749: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
750: sys_pf.payer_notification_format, sys_pf.PAYER_NOTIFICATION_CONDITION, sys_pf.PN_COND_NUM_OF_RECEIPTS
751: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
752: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf
753: WHERE txn.trxnmid = p_trxnmid
754: AND txn.mbatchid = bat.mbatchid
755: AND bat.process_profile_code = user_pf.user_cc_profile_code

Line 761: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

757:
758: CURSOR l_dc_sra_setup_csr (p_trxnmid IN NUMBER) IS
759: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
760: sys_pf.payer_notification_format, sys_pf.PAYER_NOTIFICATION_CONDITION, sys_pf.PN_COND_NUM_OF_RECEIPTS
761: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
762: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf
763: WHERE txn.trxnmid = p_trxnmid
764: AND txn.mbatchid = bat.mbatchid
765: AND bat.process_profile_code = user_pf.user_dc_profile_code

Line 921: FROM iby_batches_all bat

917: IS
918:
919: CURSOR l_instrument_type_csr (p_batchid IN VARCHAR2) IS
920: SELECT bat.instrument_type
921: FROM iby_batches_all bat
922: WHERE bat.batchid = p_batchid;
923:
924: CURSOR l_eft_format_csr (p_batchid IN VARCHAR2) IS
925: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT, sys_pf.ACCOMPANY_LETTER_FORMAT

Line 926: FROM iby_batches_all bat,

922: WHERE bat.batchid = p_batchid;
923:
924: CURSOR l_eft_format_csr (p_batchid IN VARCHAR2) IS
925: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT, sys_pf.ACCOMPANY_LETTER_FORMAT
926: FROM iby_batches_all bat,
927: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf
928: WHERE bat.batchid = p_batchid
929: AND bat.process_profile_code = user_pf.user_eft_profile_code
930: AND user_pf.sys_eft_profile_code = sys_pf.sys_eft_profile_code;

Line 934: FROM iby_batches_all bat,

930: AND user_pf.sys_eft_profile_code = sys_pf.sys_eft_profile_code;
931:
932: CURSOR l_cc_format_csr (p_batchid IN VARCHAR2) IS
933: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT
934: FROM iby_batches_all bat,
935: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf
936: WHERE bat.batchid = p_batchid
937: AND bat.process_profile_code = user_pf.user_cc_profile_code
938: AND user_pf.sys_cc_profile_code = sys_pf.sys_cc_profile_code;

Line 942: FROM iby_batches_all bat,

938: AND user_pf.sys_cc_profile_code = sys_pf.sys_cc_profile_code;
939:
940: CURSOR l_dc_format_csr (p_batchid IN VARCHAR2) IS
941: SELECT sys_pf.PAYER_NOTIFICATION_FORMAT
942: FROM iby_batches_all bat,
943: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf
944: WHERE bat.batchid = p_batchid
945: AND bat.process_profile_code = user_pf.user_dc_profile_code
946: AND user_pf.sys_dc_profile_code = sys_pf.sys_dc_profile_code;