APPS.OE_1019PC2_LINE_RTLREJD dependencies on OE_BLANKET_LINE_SECURITY

Line 31: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_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.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V a
31: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
32: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
33: )
34: ;
35:

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

28: AND w.item_key IN
29: ( SELECT a.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V a
31: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
32: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
33: )
34: ;
35:
36: CURSOR C_RSC IS

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

35:
36: CURSOR C_RSC IS
37: SELECT count(*)
38: FROM OE_AK_ORDER_LINES_V a
39: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
40: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
41: ;
42:
43: BEGIN

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

36: CURSOR C_RSC IS
37: SELECT count(*)
38: FROM OE_AK_ORDER_LINES_V a
39: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
40: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
41: ;
42:
43: BEGIN
44: x_result := 0;