APPS.OE_1018PC1_ORDER_LOST dependencies on OE_BLANKET_HEADER_SECURITY

Line 19: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER

15:
16: CURSOR C_VC IS
17: SELECT count(*)
18: FROM OE_AK_ORDER_HEADERS_V a
19: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
20: AND a.FLOW_STATUS_CODE = 'LOST'
21: ;
22:
23: CURSOR C_RSC IS

Line 26: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER

22:
23: CURSOR C_RSC IS
24: SELECT count(*)
25: FROM OE_AK_ORDER_HEADERS_V a
26: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
27: ;
28:
29: BEGIN
30: x_result := 0;