APPS.PO_QUOTES_SV dependencies on PO_QUOTATION_APPROVALS
Line 499: FROM po_quotation_approvals
495: ** X_approval_status to 'Y', else it is 'N'.
496: */
497: SELECT MAX('Y')
498: INTO X_approval_status 499: FROM po_quotation_approvals 500: WHERE line_location_id = X_line_location_id
501: AND sysdate BETWEEN nvl(start_date_active, sysdate-1)
502: AND nvl(end_date_active, sysdate+1);
503: