24: AND wpa.activity_name = l_wf_activity_name
25: AND w.activity_status = l_wf_activity_status_code
26: AND w.item_key IN
27: ( SELECT a.LINE_ID || ''
28: FROM OE_AK_ORDER_LINES_V a
29: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
30: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
31: )
32: ;
32: ;
33:
34: CURSOR C_RSC IS
35: SELECT count(*)
36: FROM OE_AK_ORDER_LINES_V a
37: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
38: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
39: ;
40: