APPS.OE_1018PC1_ORDER_INTAPPR dependencies on OE_BLANKET_HEADER_SECURITY
Line 31: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
27: AND w.activity_result_code = l_wf_activity_result_code
28: AND w.item_key IN
29: ( SELECT a.HEADER_ID || ''
30: FROM OE_AK_ORDER_HEADERS_V a 31: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER 32: )
33: ;
34:
35: CURSOR C_RSC IS
Line 38: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
34:
35: CURSOR C_RSC IS
36: SELECT count(*)
37: FROM OE_AK_ORDER_HEADERS_V a 38: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER 39: ;
40:
41: BEGIN
42: x_result := 0;