DBA Data[Home] [Help]

APPS.ASO_TRADEIN_PVT dependencies on OE_WF_LINE_ASSIGN_V

Line 48: FROM OE_WF_LINE_ASSIGN_V

44: AND relationship_type_code = 'SERVICE';
45:
46: CURSOR C_workflow IS
47: SELECT start_date_active, end_date_active
48: FROM OE_WF_LINE_ASSIGN_V
49: WHERE order_type_id = p_qte_header_rec.order_type_id
50: and line_type_id = p_qte_line_rec.order_line_type_id
51: and (trunc(sysdate) BETWEEN NVL(start_date_active, sysdate) AND
52: NVL(end_date_active, sysdate));