APPS.OE_2PC2_SHIPSET_SHIPC dependencies on OE_LINE_SECURITY

Line 29: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID

25: AND w.activity_status = l_wf_activity_status_code
26: AND w.item_key IN
27: ( SELECT b.LINE_ID || ''
28: FROM OE_AK_ORDER_LINES_V b
29: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
30: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
31: );
32:
33: CURSOR C_RSC IS

Line 30: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID

26: AND w.item_key IN
27: ( SELECT b.LINE_ID || ''
28: FROM OE_AK_ORDER_LINES_V b
29: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
30: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
31: );
32:
33: CURSOR C_RSC IS
34: SELECT count(*)

Line 36: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID

32:
33: CURSOR C_RSC IS
34: SELECT count(*)
35: FROM OE_AK_ORDER_LINES_V b
36: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
37: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
38: ;
39:
40: BEGIN

Line 37: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID

33: CURSOR C_RSC IS
34: SELECT count(*)
35: FROM OE_AK_ORDER_LINES_V b
36: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
37: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
38: ;
39:
40: BEGIN
41: x_result := 0;