APPS.OE_2PC2_CONFIG_PRCONF dependencies on OE_LINE_SECURITY

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

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

Line 25: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID

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

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

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

Line 32: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID

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