APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_BC_DISTRIBUTIONS

Line 5019: --directly from po_bc_distributions based on online_report_id

5015:
5016: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
5017: --
5018: --Going forward we would populate the events and distribution ids
5019: --directly from po_bc_distributions based on online_report_id
5020: --We stamp all distributions in the current transaction with online
5021: --report_id and then use online_report_id to identify the distributions
5022: --while reporting.
5023: INSERT INTO PSA_BC_REPORT_EVENTS_GT

Line 5030: FROM PO_BC_DISTRIBUTIONS PBD

5026: EVENT_ID
5027: )
5028: SELECT PBD.distribution_id,
5029: PBD.ae_event_id
5030: FROM PO_BC_DISTRIBUTIONS PBD
5031: WHERE PBD.ONLINE_REPORT_ID= p_online_report_id;
5032: --
5033: IF (SQL%ROWCOUNT > 0) THEN
5034: x_events_populated := 'Y';