8938: l_auto_pi_reg_submit_flag
8939: IBY_SYS_PMT_PROFILES_B.
8940: automatic_pi_reg_submit%TYPE;
8941: l_auto_sra_submit_flag
8942: IBY_REMIT_ADVICE_SETUP.
8943: automatic_sra_submit_flag%TYPE;
8944: l_remit_format_code
8945: IBY_REMIT_ADVICE_SETUP.
8946: remittance_advice_format_code%TYPE;
8941: l_auto_sra_submit_flag
8942: IBY_REMIT_ADVICE_SETUP.
8943: automatic_sra_submit_flag%TYPE;
8944: l_remit_format_code
8945: IBY_REMIT_ADVICE_SETUP.
8946: remittance_advice_format_code%TYPE;
8947: l_pos_pay_format IBY_PAYMENT_PROFILES.
8948: positive_pay_format_code%TYPE;
8949: l_pi_reg_format IBY_SYS_PMT_PROFILES_B.
9963: FROM
9964: IBY_PAYMENT_PROFILES prof,
9965: IBY_SYS_PMT_PROFILES_B sys_prof,
9966: IBY_PAY_INSTRUCTIONS_ALL inst,
9967: IBY_REMIT_ADVICE_SETUP remit
9968: WHERE
9969: prof.payment_profile_id = inst.payment_profile_id AND
9970: sys_prof.system_profile_code = prof.system_profile_code AND
9971: remit.system_profile_code = prof.system_profile_code AND