APPS.OE_2PC2_SHIPSET_STANDAR dependencies on OE_LINE_SECURITY

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

19: WHERE a.ITEM_TYPE_CODE = 'STANDARD'
20: AND ( a.LINE_ID ) IN
21: ( SELECT b.LINE_ID
22: FROM OE_AK_ORDER_LINES_V b
23: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
24: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
25: );
26:
27: CURSOR C_RSC IS

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

20: AND ( a.LINE_ID ) IN
21: ( SELECT b.LINE_ID
22: FROM OE_AK_ORDER_LINES_V b
23: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
24: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
25: );
26:
27: CURSOR C_RSC IS
28: SELECT count(*)

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

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

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

27: CURSOR C_RSC IS
28: SELECT count(*)
29: FROM OE_AK_ORDER_LINES_V b
30: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
31: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
32: ;
33:
34: BEGIN
35: x_result := 0;