DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_REMIT_ADVICE_SETUP

Line 4269: iby_payment_profiles pp, iby_remit_advice_setup sra_setup

4265:
4266: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
4267: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
4268: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
4269: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
4270: WHERE pmt.payment_id = p_payment_id
4271: AND pmt.payment_instruction_id = ins.payment_instruction_id
4272: AND pp.payment_profile_id = ins.payment_profile_id
4273: AND pp.system_profile_code = sra_setup.system_profile_code;