DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on OE_WF_LINE_ASSIGN_V

Line 5249: FROM OE_WF_LINE_ASSIGN_V

5245: --passed in p_qte_header_rec using the following query:
5246:
5247: Cursor c_ln_type_for_ord_type is
5248: SELECT start_date_active, end_date_active
5249: FROM OE_WF_LINE_ASSIGN_V
5250: WHERE order_type_id = p_qte_header_rec.order_type_id
5251: and line_type_id = p_qte_line_rec.order_line_type_id
5252: and (trunc(sysdate) BETWEEN NVL(start_date_active, sysdate) AND
5253: NVL(end_date_active, sysdate));