APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_LINE_LOCATIONS

Line 233: FROM po_line_locations PLL

229: AND PPD.last_update_date >
230: p_last_activity_date)))
231: AND NOT EXISTS
232: (SELECT NULL
233: FROM po_line_locations PLL
234: WHERE PLL.po_header_id = PH.po_header_id
235: AND (
236: PLL.last_update_date > p_last_activity_date
237: OR

Line 320: FROM po_line_locations PLL

316: AND PPD.last_update_date >
317: p_last_activity_date)))
318: AND NOT EXISTS
319: (SELECT NULL
320: FROM po_line_locations PLL
321: WHERE PLL.po_header_id = PH.po_header_id
322: AND (
323: PLL.last_update_date > p_last_activity_date
324: OR

Line 2744: po_line_locations PLL

2740: WHERE PPD.entity_type = 'PRICE BREAK'
2741: AND EXISTS (
2742: SELECT NULL
2743: FROM po_purge_po_list PPL,
2744: po_line_locations PLL
2745: WHERE PPL.po_header_id = PLL.po_header_id
2746: AND PLL.line_location_id = PPD.entity_id
2747: AND PPL.double_check_flag = 'Y'
2748: AND PPL.po_header_id BETWEEN p_range_low

Line 2769: po_line_locations PLL

2765: WHERE PPD.entity_type = 'PRICE BREAK'
2766: AND EXISTS (
2767: SELECT NULL
2768: FROM po_purge_po_list PPL,
2769: po_line_locations PLL
2770: WHERE PPL.po_header_id = PLL.po_header_id
2771: AND PLL.line_location_id = PPD.entity_id
2772: AND PPL.double_check_flag = 'Y'
2773: AND PPL.po_header_id BETWEEN p_range_low

Line 3142: po_line_locations POLL

3138:
3139: CURSOR c_po_shipment IS
3140: SELECT POLL.line_location_id
3141: FROM po_purge_po_list PPL,
3142: po_line_locations POLL
3143: WHERE PPL.po_header_id BETWEEN p_range_low AND p_range_high
3144: AND PPL.double_check_flag = 'Y'
3145: AND PPL.po_header_id = POLL.po_header_id;
3146: