APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_PAYMENT_PROFILES

Line 8936: l_profile_id IBY_PAYMENT_PROFILES.

8932: /*
8933: * These variables are related to kicking off automatic
8934: * reports.
8935: */
8936: l_profile_id IBY_PAYMENT_PROFILES.
8937: payment_profile_id%TYPE;
8938: l_auto_pi_reg_submit_flag
8939: IBY_SYS_PMT_PROFILES_B.
8940: automatic_pi_reg_submit%TYPE;

Line 8947: l_pos_pay_format IBY_PAYMENT_PROFILES.

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.
8950: pi_register_format%TYPE;
8951:

Line 9132: IBY_PAYMENT_PROFILES prof,

9128: l_processing_type,
9129: l_pmts_complete_code,
9130: l_process_type
9131: FROM
9132: IBY_PAYMENT_PROFILES prof,
9133: IBY_PAY_INSTRUCTIONS_ALL inst
9134: WHERE
9135: prof.payment_profile_id = inst.payment_profile_id AND
9136: inst.payment_instruction_id = p_instr_id

Line 9964: IBY_PAYMENT_PROFILES prof,

9960: l_pi_reg_format,
9961: l_auto_sra_submit_flag,
9962: l_remit_format_code
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

Line 11407: iby_payment_profiles pp,

11403: BEGIN
11404: SELECT temp.template_type_code, temp.default_output_type
11405: INTO l_template_type_code, l_default_output_type
11406: FROM iby_pay_instructions_all ins,
11407: iby_payment_profiles pp,
11408: iby_formats_b format,
11409: XDO_TEMPLATES_B temp
11410: WHERE ins.payment_instruction_id = p_object_id
11411: AND ins.payment_profile_id = pp.payment_profile_id

Line 12528: IBY_PAYMENT_PROFILES prof

12524: SELECT
12525: instr.payment_instruction_id
12526: FROM
12527: IBY_PAY_INSTRUCTIONS_ALL instr,
12528: IBY_PAYMENT_PROFILES prof
12529: WHERE
12530: instr.payment_instruction_id = p_instr_id
12531: AND
12532: prof.payment_profile_id = instr.payment_profile_id

Line 13700: iby_payment_profiles pp

13696:
13697: CURSOR l_ins_csr (p_payment_instruction_id IN NUMBER) IS
13698: SELECT pp.MARK_COMPLETE_EVENT
13699: FROM iby_pay_instructions_all ins,
13700: iby_payment_profiles pp
13701: WHERE ins.payment_instruction_id = p_payment_instruction_id
13702: AND ins.payment_profile_id = pp.payment_profile_id;
13703:
13704: BEGIN