DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 993: FROM ap_self_assessed_tax_dist_all ) AID,

989: charge_applicable_to_dist_id ,
990: cancellation_flag ,
991: match_status_flag ,
992: awt_invoice_payment_id
993: FROM ap_self_assessed_tax_dist_all ) AID,
994: financials_system_parameters FSP
995: WHERE AID.invoice_id = P_invoice_id
996: AND AID.awt_invoice_payment_id IS NULL
997: AND AID.org_id = FSP.org_id -- Bug 4516136

Line 1654: UPDATE ap_self_assessed_tax_dist_all

1650: -- We need to stamp the same accounting event id
1651: -- for self assessed tax distributions.
1652: -------------------------------------------------
1653:
1654: UPDATE ap_self_assessed_tax_dist_all
1655: SET accounting_event_id = l_accounting_event_id
1656: WHERE invoice_id = p_invoice_id
1657: AND accounting_date = event_dist_rec.accounting_date
1658: AND awt_invoice_payment_id IS NULL

Line 5912: /* bug 11663644 added ap_self_assessed_tax_dist_all */

5908: p_invoice_id IN NUMBER,
5909: p_calling_sequence IN VARCHAR2)
5910: IS
5911:
5912: /* bug 11663644 added ap_self_assessed_tax_dist_all */
5913: CURSOR inv_cancel_event_dists IS
5914: SELECT accounting_date
5915: FROM ap_invoice_distributions
5916: WHERE invoice_id = p_invoice_id

Line 5924: FROM ap_self_assessed_tax_dist_all

5920: AND cancellation_flag = 'Y'
5921: GROUP BY accounting_date
5922: UNION
5923: SELECT accounting_date
5924: FROM ap_self_assessed_tax_dist_all
5925: WHERE invoice_id = p_invoice_id
5926: AND awt_invoice_payment_id IS NULL
5927: AND prepay_distribution_id IS NULL --prepay_tax_parent_id obsoleted
5928: AND accounting_event_id IS NULL

Line 6057: UPDATE ap_self_assessed_tax_dist_all

6053: -- self assessed tax distributions
6054: --------------------------------------------------
6055:
6056: FORALL i IN 1 .. l_accounting_event_dates.count
6057: UPDATE ap_self_assessed_tax_dist_all
6058: SET accounting_event_id = l_accounting_event_ids(i)
6059: WHERE invoice_id = p_invoice_id
6060: AND accounting_date = l_accounting_event_dates(i)
6061: AND awt_invoice_payment_id IS NULL