APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1503: UPDATE ap_invoice_distributions_all

1499: AND sign(amount) = sign(event_dist_rec.dist_amount)
1500: RETURNING invoice_distribution_id BULK COLLECT INTO l_inv_dist_tab;
1501:
1502: FORALL i IN l_inv_dist_tab.FIRST..l_inv_dist_tab.LAST
1503: UPDATE ap_invoice_distributions_all
1504: SET accounting_event_id = l_accounting_event_id
1505: WHERE line_type_lookup_code in ('REC_TAX','NONREC_TAX',
1506: 'TRV','TIPV','TERV') --Bug5455985
1507: AND accounting_event_id IS NULL

Line 2189: from ap_invoice_distributions_all

2185:
2186: --bug 7011943 There are payment time AWT dists.
2187: select count(*)
2188: into l_count
2189: from ap_invoice_distributions_all
2190: where accounting_event_id = l_accounting_event_ids(i)
2191: and invoice_id = l_event_source_info.source_id_int_1
2192: and awt_invoice_payment_id is not null;
2193:

Line 2792: from ap_invoice_distributions_all

2788: END IF;
2789: --bug 7011943
2790: select count(*)
2791: into l_count
2792: from ap_invoice_distributions_all
2793: where accounting_event_id = l_accounting_event_ids(i)
2794: and invoice_id = l_event_source_info.source_id_int_1
2795: and awt_invoice_payment_id is not null;
2796:

Line 3727: UPDATE ap_invoice_distributions_all D

3723: G_MODULE_NAME || l_procedure_name,
3724: l_log_msg);
3725: END IF;
3726:
3727: UPDATE ap_invoice_distributions_all D
3728: SET D.accounting_event_id = p_event_id
3729: WHERE D.accounting_event_id IS NULL
3730: AND D.invoice_id IN
3731: (SELECT AI.invoice_id

Line 3875: UPDATE ap_invoice_distributions_all AID

3871: */
3872:
3873: FORALL i IN 1 .. l_check_ids.count
3874:
3875: UPDATE ap_invoice_distributions_all AID
3876: SET AID.accounting_event_id = l_accounting_event_ids(i)
3877: WHERE AID.accounting_event_id IS NULL
3878: AND AID.invoice_id IN
3879: ( SELECT AI.invoice_id

Line 5725: FROM ap_invoice_distributions_all AID,

5721: AID.invoice_id,
5722: AID.org_id,
5723: AI.legal_entity_id,
5724: AID.set_of_books_id ledger_id
5725: FROM ap_invoice_distributions_all AID,
5726: ap_invoices_all AI
5727: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
5728: = p_period_name
5729: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699

Line 5757: FROM ap_invoice_distributions_all AID,

5753: AID.invoice_id,
5754: AID.org_id,
5755: AI.legal_entity_id,
5756: AID.set_of_books_id ledger_id
5757: FROM ap_invoice_distributions_all AID,
5758: ap_invoices_all AI
5759: WHERE AID.accounting_date BETWEEN p_from_date AND p_to_date
5760: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
5761: AND aid.org_id = ai.org_id