APPS.PO_DISTRIBUTIONS_DRAFT_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 411: FROM po_distributions_all

407: amount_ordered,
408: clm_payment_sequence_num, --CLM Phase 4
409: Nvl(revision_num, 0), --
410: amount_changed_flag --13503748 Encumbrance ER
411: FROM po_distributions_all
412: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
413: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
414: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
415:

Line 568: DELETE FROM po_distributions_all PD

564:
565: -- bug5187544
566: -- Delete only records that have not been rejected
567:
568: DELETE FROM po_distributions_all PD
569: WHERE PD.po_distribution_id IN
570: ( SELECT PDD.po_distribution_id -- Bug 5292573
571: FROM po_distributions_draft_all PDD
572: WHERE PDD.draft_id = p_draft_id

Line 607: MERGE INTO po_distributions_all PD

603: --PD.retainage_withheld_amount
604: --PD.retainage_released_amount
605: --
606: --PD.uda_template_id
607: MERGE INTO po_distributions_all PD
608: USING (
609: SELECT
610: PDD.draft_id,
611: PDD.delete_flag,

Line 1184: FROM po_distributions_all

1180: END IF;
1181:
1182: SELECT 1
1183: INTO l_dummy
1184: FROM po_distributions_all
1185: WHERE po_distribution_id = p_po_distribution_id
1186: FOR UPDATE NOWAIT;
1187:
1188: IF (PO_LOG.d_proc) THEN