720:
721: CURSOR C_GET_LINE_LEVEL_AUDIT_VALUE
722: IS
723: SELECT nvl(freight_audit_line_level,'N'),FTE_INVOICE_HEADERS.APPROVED_AMOUNT
724: FROM WSH_CARRIERS, FTE_INVOICE_HEADERS
725: WHERE WSH_CARRIERS.CARRIER_ID = FTE_INVOICE_HEADERS.CARRIER_ID
726: AND FTE_INVOICE_HEADERS.INVOICE_HEADER_ID = p_invoice_header_id;
727:
728:
721: CURSOR C_GET_LINE_LEVEL_AUDIT_VALUE
722: IS
723: SELECT nvl(freight_audit_line_level,'N'),FTE_INVOICE_HEADERS.APPROVED_AMOUNT
724: FROM WSH_CARRIERS, FTE_INVOICE_HEADERS
725: WHERE WSH_CARRIERS.CARRIER_ID = FTE_INVOICE_HEADERS.CARRIER_ID
726: AND FTE_INVOICE_HEADERS.INVOICE_HEADER_ID = p_invoice_header_id;
727:
728:
729: