DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on OE_WF_LINE_ASSIGN_V

Line 5252: FROM OE_WF_LINE_ASSIGN_V

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