APPS.OE_2PC2_SHIPSET_INVIFAC dependencies on OE_LINE_SECURITY

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

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

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

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

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

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

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

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