APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_PRICE_DIFFERENTIALS

Line 225: FROM po_price_differentials PPD

221: PL.last_update_date > p_last_activity_date
222: OR
223: EXISTS (
224: SELECT NULL
225: FROM po_price_differentials PPD
226: WHERE PPD.entity_type IN ('PO LINE',
227: 'BLANKET LINE')
228: AND PPD.entity_id = PL.po_line_id
229: AND PPD.last_update_date >

Line 240: FROM po_price_differentials PPD

236: PLL.last_update_date > p_last_activity_date
237: OR
238: EXISTS (
239: SELECT NULL
240: FROM po_price_differentials PPD
241: WHERE PPD.entity_type = 'PRICE BREAK'
242: AND PPD.entity_id = PLL.line_location_id
243: AND PPD.last_update_date >
244: p_last_activity_date)))

Line 312: FROM po_price_differentials PPD

308: PL.last_update_date > p_last_activity_date
309: OR
310: EXISTS (
311: SELECT NULL
312: FROM po_price_differentials PPD
313: WHERE PPD.entity_type IN ('PO LINE',
314: 'BLANKET LINE')
315: AND PPD.entity_id = PL.po_line_id
316: AND PPD.last_update_date >

Line 327: FROM po_price_differentials PPD

323: PLL.last_update_date > p_last_activity_date
324: OR
325: EXISTS (
326: SELECT NULL
327: FROM po_price_differentials PPD
328: WHERE PPD.entity_type = 'PRICE BREAK'
329: AND PPD.entity_id = PLL.line_location_id
330: AND PPD.last_update_date >
331: p_last_activity_date)))

Line 390: FROM po_price_differentials PPD

386: PRL.source_type_code = 'INVENTORY'
387: OR
388: EXISTS (
389: SELECT NULL
390: FROM po_price_differentials PPD
391: WHERE PPD.entity_type = 'REQ LINE'
392: AND PPD.entity_id = PRL.requisition_line_id
393: AND PPD.last_update_date >
394: p_last_activity_date)

Line 2608: --Function: Remove records from po_price_differentials when documetns they

2604: --Pre-reqs:
2605: --Modifies:
2606: --Locks:
2607: -- None
2608: --Function: Remove records from po_price_differentials when documetns they
2609: -- associate with are getting purged
2610: --Parameters:
2611: --IN:
2612: --p_purge_entity

Line 2662: FROM po_price_differentials PPD

2658: IF (p_purge_entity = 'REQ') THEN
2659: l_progress := '010';
2660:
2661: DELETE
2662: FROM po_price_differentials PPD
2663: WHERE PPD.entity_type = 'REQ LINE'
2664: AND EXISTS (
2665: SELECT NULL
2666: FROM po_purge_req_list PPRL,

Line 2689: FROM po_price_differentials PPD

2685: ELSIF (p_purge_entity = 'PO') THEN
2686: l_progress := '020';
2687:
2688: DELETE
2689: FROM po_price_differentials PPD
2690: WHERE PPD.entity_type IN ('PO LINE', 'BLANKET LINE')
2691: AND EXISTS (
2692: SELECT NULL
2693: FROM po_purge_po_list PPL,

Line 2714: FROM po_price_differentials_archive PPD

2710:
2711: l_progress := '030';
2712:
2713: DELETE
2714: FROM po_price_differentials_archive PPD
2715: WHERE PPD.entity_type IN ('PO LINE', 'BLANKET LINE')
2716: AND EXISTS (
2717: SELECT NULL
2718: FROM po_purge_po_list PPL,

Line 2739: FROM po_price_differentials PPD

2735:
2736: l_progress := '040';
2737:
2738: DELETE
2739: FROM po_price_differentials PPD
2740: WHERE PPD.entity_type = 'PRICE BREAK'
2741: AND EXISTS (
2742: SELECT NULL
2743: FROM po_purge_po_list PPL,

Line 2764: FROM po_price_differentials_archive PPD

2760:
2761: l_progress := '050';
2762:
2763: DELETE
2764: FROM po_price_differentials_archive PPD
2765: WHERE PPD.entity_type = 'PRICE BREAK'
2766: AND EXISTS (
2767: SELECT NULL
2768: FROM po_purge_po_list PPL,

Line 2866: FROM po_price_differentials PPD

2862:
2863: l_progress := '010';
2864:
2865: DELETE
2866: FROM po_price_differentials PPD
2867: WHERE PPD.entity_type IN ('PO LINE', 'BLANKET LINE')
2868: AND EXISTS (
2869: SELECT NULL
2870: FROM po_purge_po_list PPL,