APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_PAYMENT_PROFILES

Line 7731: l_profile_id IBY_PAYMENT_PROFILES.

7727: /*
7728: * These variables are related to kicking off automatic
7729: * reports.
7730: */
7731: l_profile_id IBY_PAYMENT_PROFILES.
7732: payment_profile_id%TYPE;
7733: l_auto_pi_reg_submit_flag
7734: IBY_SYS_PMT_PROFILES_B.
7735: automatic_pi_reg_submit%TYPE;

Line 7742: l_pos_pay_format IBY_PAYMENT_PROFILES.

7738: automatic_sra_submit_flag%TYPE;
7739: l_remit_format_code
7740: IBY_REMIT_ADVICE_SETUP.
7741: remittance_advice_format_code%TYPE;
7742: l_pos_pay_format IBY_PAYMENT_PROFILES.
7743: positive_pay_format_code%TYPE;
7744: l_pi_reg_format IBY_SYS_PMT_PROFILES_B.
7745: pi_register_format%TYPE;
7746:

Line 7848: IBY_PAYMENT_PROFILES prof,

7844: l_processing_type,
7845: l_pmts_complete_code,
7846: l_process_type
7847: FROM
7848: IBY_PAYMENT_PROFILES prof,
7849: IBY_PAY_INSTRUCTIONS_ALL inst
7850: WHERE
7851: prof.payment_profile_id = inst.payment_profile_id AND
7852: inst.payment_instruction_id = p_instr_id;

Line 8485: IBY_PAYMENT_PROFILES prof,

8481: l_pi_reg_format,
8482: l_auto_sra_submit_flag,
8483: l_remit_format_code
8484: FROM
8485: IBY_PAYMENT_PROFILES prof,
8486: IBY_SYS_PMT_PROFILES_B sys_prof,
8487: IBY_PAY_INSTRUCTIONS_ALL inst,
8488: IBY_REMIT_ADVICE_SETUP remit
8489: WHERE

Line 10719: IBY_PAYMENT_PROFILES prof

10715: SELECT
10716: instr.payment_instruction_id
10717: FROM
10718: IBY_PAY_INSTRUCTIONS_ALL instr,
10719: IBY_PAYMENT_PROFILES prof
10720: WHERE
10721: instr.payment_instruction_id = p_instr_id
10722: AND
10723: prof.payment_profile_id = instr.payment_profile_id