DBA Data[Home] [Help]

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: