APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 555: from po_distributions_all pd, po_distributions_draft_all pdd

551: /*124*/ ,pdd.WIP_RESOURCE_SEQ_NUM
552: /*pd.po_distribution_id,
553: pd.quantity_billed,
554: pd.amount_billed*/
555: from po_distributions_all pd, po_distributions_draft_all pdd
556: where pdd.po_distribution_id = pd.po_distribution_id
557: and pdd.draft_id = p_draft_id
558: and (pdd.quantity_billed <> pd.quantity_billed or
559: pdd.amount_billed <> pd.amount_billed);

Line 2268: FROM po_distributions_all pla

2264: l_draft_amount_tbl,
2265: l_draft_old_amount_tbl,
2266: l_po_distribution_tbl,
2267: l_change_status_tbl
2268: FROM po_distributions_all pla
2269: ,po_distributions_draft_all plda
2270: WHERE pla.po_distribution_id = plda.po_distribution_id
2271: AND plda.draft_id = p_draft_id
2272: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 2302: po_distributions_all pla

2298: BULK COLLECT INTO l_po_dist_s_no_lck_tbl
2299: ,l_draft_id_tbl
2300: ,l_delete_flag_tbl
2301: FROM po_distributions_draft_all plda,
2302: po_distributions_all pla
2303: WHERE plda.draft_id = p_draft_id
2304: AND pla.po_distribution_id = plda.po_distribution_id
2305: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2306: AND NOT EXISTS (SELECT 'P/F locks'