DBA Data[Home] [Help]

APPS.FV_TREASURY_PAYMENTS_PKG dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 10: g_payment_instr_id iby_pay_instructions_all.payment_instruction_id%TYPE;

6: g_ledger_id gl_ledgers.ledger_id%TYPE;
7: g_org_id fv_operating_units.org_id%TYPE;
8: g_treasury_conf_id fv_treasury_confirmations.treasury_confirmation_id%TYPE;
9: g_accounting_date fv_treasury_confirmations.treasury_doc_date%TYPE;
10: g_payment_instr_id iby_pay_instructions_all.payment_instruction_id%TYPE;
11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;
12: x_err_code NUMBER;
13: x_err_stage VARCHAR2(2000);
14: g_dit_flag VARCHAR2(1);

Line 311: iby_pay_instructions_all ipa

307: CURSOR cur_corr_treas_pay_num IS
308: SELECT fto.corrected_treasury_pay_number, fto.check_id
309: FROM fv_tc_offsets fto,
310: ap_checks ac,
311: iby_pay_instructions_all ipa
312: WHERE ac.check_id = fto.check_id
313: AND ipa.payment_instruction_id = ac.payment_instruction_id
314: AND ipa.payment_instruction_id = g_payment_instr_id;
315: