APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_REQUISITION_LINES

Line 381: FROM po_requisition_lines PRL

377: AND (PRH.closed_code = 'FINALLY CLOSED'
378: OR PRH.authorization_status = 'CANCELLED')
379: AND NOT EXISTS
380: (SELECT NULL
381: FROM po_requisition_lines PRL
382: WHERE PRL.requisition_header_id = PRH.requisition_header_id
383: AND NVL(PRL.modified_by_agent_flag, 'N') = 'N'
384: AND (PRL.last_update_date > p_last_activity_date
385: OR

Line 2667: po_requisition_lines RL

2663: WHERE PPD.entity_type = 'REQ LINE'
2664: AND EXISTS (
2665: SELECT NULL
2666: FROM po_purge_req_list PPRL,
2667: po_requisition_lines RL
2668: WHERE PPRL.requisition_header_id =
2669: RL.requisition_header_id
2670: AND RL.requisition_line_id = PPD.entity_id
2671: AND PPRL.double_check_flag = 'Y'

Line 3001: po_requisition_lines PRL

2997:
2998: CURSOR c_req_line IS
2999: SELECT PRL.requisition_line_id
3000: FROM po_purge_req_list PPRL,
3001: po_requisition_lines PRL
3002: WHERE PPRL.requisition_header_id BETWEEN p_range_low AND p_range_high
3003: AND PPRL.double_check_flag = 'Y'
3004: AND PPRL.requisition_header_id = PRL.requisition_header_id;
3005: