APPS.FUN_AP_TRANSFER dependencies on FUN_TRX_HEADERS

Line 87: FROM fun_trx_headers

83: IS
84: l_status varchar2(15);
85: BEGIN
86: SELECT status INTO l_status
87: FROM fun_trx_headers
88: WHERE trx_id = p_trx_id
89: FOR UPDATE;
90:
91: IF (l_status = 'XFER_AR') THEN

Line 219: fun_trx_headers h,

215: NVL(p_org_id, fun_tca_pkg.get_ou_id(h.recipient_id)) to_org_id,
216: b.initiator_id,
217: h.recipient_id
218: FROM fun_trx_batches b,
219: fun_trx_headers h,
220: gl_period_statuses ps,
221: gl_ledgers ledgers
222: WHERE b.batch_id = h.batch_id AND
223: ps.ledger_id = h.to_ledger_id AND

Line 336: FROM fun_trx_headers

332:
333: IF (l_error = 1) THEN
334: -- Lock record
335: SELECT trx_id INTO l_trx_id
336: FROM fun_trx_headers
337: WHERE trx_id = l_trx_id
338: FOR UPDATE;
339:
340: BEGIN

Line 585: from fun_trx_headers

581: END IF;
582: -- Bug: 7652608
583: select description
584: INTO l_desc_header_level
585: from fun_trx_headers
586: where trx_id=p_trx_id;
587:
588: INSERT INTO ap_invoices_interface (
589: invoice_id, invoice_num, invoice_date,