APPS.OE_2PC2_CONFIG_BOOKED dependencies on OE_LINE_SECURITY

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

19: WHERE a.BOOKED_FLAG = 'Y'
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.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
25: );
26:
27: CURSOR C_RSC IS

Line 24: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_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.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_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.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
32: ;
33:
34: BEGIN

Line 31: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_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.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
32: ;
33:
34: BEGIN
35: x_result := 0;