APPS.IBY_FD_USER_API_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 468: from IBY_PAY_INSTRUCTIONS_ALL

464: END IF;
465:
466: select count(*)
467: into l_instr_sra_ok
468: from IBY_PAY_INSTRUCTIONS_ALL
469: where generate_sep_remit_advice_flag = 'Y'
470: and (REMITTANCE_ADVICE_CREATED_FLAG = 'N' or
471: IBY_FD_POST_PICP_PROGS_PVT.get_allow_multiple_sra_flag(p_instr_id) = 'Y')
472: and payment_instruction_status not in ('CREATION_ERROR', 'RETRY_CREATION', 'TERMINATED')

Line 485: from iby_pay_instructions_all ins,

481: select sra_setup.remittance_advice_format_code,
482: f.format_name
483: into x_default_sra_format_code,
484: x_default_sra_format_name
485: from iby_pay_instructions_all ins,
486: iby_payment_profiles pp,
487: iby_remit_advice_setup sra_setup,
488: iby_formats_vl f
489: where ins.payment_instruction_id = p_instr_id