DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_REMIT_ADVICE_SETUP

Line 3060: iby_payment_profiles pp, iby_remit_advice_setup sra_setup

3056:
3057: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
3058: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
3059: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
3060: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
3061: WHERE pmt.payment_id = p_payment_id
3062: AND pmt.payment_instruction_id = ins.payment_instruction_id
3063: AND pp.payment_profile_id = ins.payment_profile_id
3064: AND pp.system_profile_code = sra_setup.system_profile_code;