APPS.OE_2PC2_ATOCON_RCVED dependencies on OE_LINE_SECURITY

Line 25: WHERE b.ATO_LINE_ID = OE_LINE_SECURITY.g_record.ATO_LINE_ID

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

Line 26: AND b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID

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

Line 32: WHERE b.ATO_LINE_ID = OE_LINE_SECURITY.g_record.ATO_LINE_ID

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

Line 33: AND b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID

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