DBA Data[Home] [Help]

APPS.OE_1PC2_LINE_SHIPA dependencies on OE_HEADER_SECURITY

Line 29: WHERE a.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID

25: AND w.activity_status = l_wf_activity_status_code
26: AND w.item_key IN
27: ( SELECT a.LINE_ID || ''
28: FROM OE_AK_ORDER_LINES_V a
29: WHERE a.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID
30: )
31: ;
32:
33: CURSOR C_RSC IS

Line 36: WHERE a.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID

32:
33: CURSOR C_RSC IS
34: SELECT count(*)
35: FROM OE_AK_ORDER_LINES_V a
36: WHERE a.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID
37: ;
38:
39: BEGIN
40: x_result := 0;