APPS.FUN_AP_TRANSFER dependencies on FUN_TRX_HEADERS

Line 89: FROM fun_trx_headers

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

Line 223: fun_trx_headers h,

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
227: ps.ledger_id = h.to_ledger_id AND

Line 342: FROM fun_trx_headers

338:
339: IF (l_error = 1) THEN
340: -- Lock record
341: SELECT trx_id INTO l_trx_id
342: FROM fun_trx_headers
343: WHERE trx_id = l_trx_id
344: FOR UPDATE;
345:
346: BEGIN

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