114: AND (x_approval_status_list IS NULL
115: OR x_approval_status_list = 'ALL' /*Bug 5717983 This is to consider the 'All Statuses' option.*/
116: OR x_approval_status_list =
117: (SELECT authorization_status
118: FROM PO_REQUISITION_HEADERS PORH
119: WHERE PORH.requisition_header_id =
120: PORL.requisition_header_id))
121: AND (x_requisition_header_id IS NULL
122: OR PORL.requisition_header_id = x_requisition_header_id)
280: AND (x_approval_status_list IS NULL
281: OR x_approval_status_list = 'ALL' /*Bug 5717983 This is to consider the 'All Statuses' option.*/
282: OR x_approval_status_list =
283: (SELECT authorization_status
284: FROM PO_REQUISITION_HEADERS PORH
285: WHERE PORH.requisition_header_id =
286: PORL.requisition_header_id))
287: AND (x_requisition_header_id IS NULL
288: OR PORL.requisition_header_id = x_requisition_header_id)
456: AND (x_approval_status_list IS NULL
457: OR x_approval_status_list = 'ALL' /*Bug 5717983 This is to consider the 'All Statuses' option.*/
458: OR x_approval_status_list =
459: (SELECT authorization_status
460: FROM PO_REQUISITION_HEADERS PORH
461: WHERE PORH.requisition_header_id =
462: PORL.requisition_header_id))
463: AND (x_requisition_header_id IS NULL
464: OR PORL.requisition_header_id = x_requisition_header_id)