APPS.FUN_AP_TRANSFER dependencies on FUN_TRX_BATCHES

Line 185: l_conv_type fun_trx_batches.exchange_rate_type%TYPE;

181: l_event_key varchar2(240);
182: l_init_sysdate date;
183: l_source varchar2(100) := 'GLOBAL_INTERCOMPANY';
184: l_request_id number;
185: l_conv_type fun_trx_batches.exchange_rate_type%TYPE;
186: l_counter number;
187: l_trx_num varchar2(15);
188: l_batch_num varchar2(20);
189: l_batch_id number;

Line 222: FROM fun_trx_batches b,

218: fun_tca_pkg.get_ou_id(h.initiator_id) from_org_id,
219: NVL(p_org_id, fun_tca_pkg.get_ou_id(h.recipient_id)) to_org_id,
220: b.initiator_id,
221: h.recipient_id
222: FROM fun_trx_batches b,
223: fun_trx_headers h,
224: gl_period_statuses ps,
225: gl_ledgers ledgers
226: WHERE b.batch_id = h.batch_id AND

Line 620: from fun_trx_headers fth, fun_trx_batches ftb

616: END IF;
617: -- Bug: 7652608
618: select fth.description, fth.to_le_id, ftb.currency_code
619: INTO l_desc_header_level, l_le_id, l_currency_code
620: from fun_trx_headers fth, fun_trx_batches ftb
621: where fth.trx_id = p_trx_id
622: and fth.batch_id = ftb.batch_id;
623:
624: --Bug: 13622727