DBA Data[Home] [Help]

APPS.FUN_AP_TRANSFER dependencies on FUN_TCA_PKG

Line 218: fun_tca_pkg.get_ou_id(h.initiator_id) from_org_id,

214: h.approval_date,
215: h.ar_invoice_number,
216: b.from_le_id,
217: h.to_le_id ,
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,

Line 219: NVL(p_org_id, fun_tca_pkg.get_ou_id(h.recipient_id)) to_org_id,

215: h.ar_invoice_number,
216: b.from_le_id,
217: h.to_le_id ,
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,

Line 236: fun_tca_pkg.get_ou_id(h.recipient_id),1) AND

232: AND nvl(l_date_high, b.gl_date) AND
233: ps.adjustment_period_flag <> 'Y' AND
234: h.to_le_id = NVL(p_le_id, h.to_le_id) AND
235: NVL(p_org_id, 1) = NVL2(p_org_id,
236: fun_tca_pkg.get_ou_id(h.recipient_id),1) AND
237: h.status = 'XFER_AR' AND
238: h.ar_invoice_number IS NOT NULL
239: ORDER BY to_org_id; -- Order By added to be able to set
240: -- Org Context when submitting AP Import