DBA Data[Home] [Help]

APPS.FUN_AP_TRANSFER dependencies on FUN_TCA_PKG

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

210: h.approval_date,
211: h.ar_invoice_number,
212: b.from_le_id,
213: h.to_le_id ,
214: fun_tca_pkg.get_ou_id(h.initiator_id) from_org_id,
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,

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

211: h.ar_invoice_number,
212: b.from_le_id,
213: h.to_le_id ,
214: fun_tca_pkg.get_ou_id(h.initiator_id) from_org_id,
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,

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

227: b.gl_date BETWEEN nvl(l_date_low, b.gl_date)
228: AND nvl(l_date_high, b.gl_date) AND
229: h.to_le_id = NVL(p_le_id, h.to_le_id) AND
230: NVL(p_org_id, 1) = NVL2(p_org_id,
231: fun_tca_pkg.get_ou_id(h.recipient_id),1) AND
232: h.status = 'XFER_AR' AND
233: h.ar_invoice_number IS NOT NULL
234: ORDER BY to_org_id; -- Order By added to be able to set
235: -- Org Context when submitting AP Import