DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_FNDCPT_USER_EFT_PF_B

Line 630: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf

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

Line 786: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf

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;
790: