DBA Data[Home] [Help]

APPS.OE_1018PC1_ORDER_PENAPPR dependencies on OE_AK_ORDER_HEADERS_V

Line 18: FROM OE_AK_ORDER_HEADERS_V a

14: l_set_count NUMBER := 0;
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 = 'PENDING_INTERNAL_APPROVAL'
21: ;
22:

Line 25: FROM OE_AK_ORDER_HEADERS_V a

21: ;
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