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