APPS.OE_1019PC2_LINE_SHIPC dependencies on OE_BLANKET_LINE_SECURITY

Line 29: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER

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

Line 30: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER

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: ;
33:
34: CURSOR C_RSC IS

Line 37: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER

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:
41: BEGIN

Line 38: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER

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:
41: BEGIN
42: x_result := 0;