APPS.PO_DISTRIBUTIONS_DRAFT_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 377: FROM po_distributions_all

373: retainage_withheld_amount,
374: retainage_released_amount,
375: --
376: tax_attribute_update_code --
377: FROM po_distributions_all
378: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
379: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
380: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
381:

Line 534: DELETE FROM po_distributions_all PD

530:
531: -- bug5187544
532: -- Delete only records that have not been rejected
533:
534: DELETE FROM po_distributions_all PD
535: WHERE PD.po_distribution_id IN
536: ( SELECT PDD.po_distribution_id -- Bug 5292573
537: FROM po_distributions_draft_all PDD
538: WHERE PDD.draft_id = p_draft_id

Line 572: MERGE INTO po_distributions_all PD

568: --PD.amount_recouped
569: --PD.retainage_withheld_amount
570: --PD.retainage_released_amount
571: --
572: MERGE INTO po_distributions_all PD
573: USING (
574: SELECT
575: PDD.draft_id,
576: PDD.delete_flag,

Line 1094: FROM po_distributions_all

1090: END IF;
1091:
1092: SELECT 1
1093: INTO l_dummy
1094: FROM po_distributions_all
1095: WHERE po_distribution_id = p_po_distribution_id
1096: FOR UPDATE NOWAIT;
1097:
1098: IF (PO_LOG.d_proc) THEN