APPS.OE_6PC6_HDRADJS_DISSUR dependencies on OE_HEADER_ADJ_SECURITY

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

19: WHERE a.LIST_LINE_TYPE_CODE <> 'FREIGHT_CHARGE'
20: AND ( a.PRICE_ADJUSTMENT_ID ) IN
21: ( SELECT b.PRICE_ADJUSTMENT_ID
22: FROM OE_AK_HEADER_PRCADJS_V b
23: WHERE b.HEADER_ID = OE_HEADER_ADJ_SECURITY.g_record.HEADER_ID
24: );
25:
26: CURSOR C_RSC IS
27: SELECT count(*)

Line 29: WHERE b.HEADER_ID = OE_HEADER_ADJ_SECURITY.g_record.HEADER_ID

25:
26: CURSOR C_RSC IS
27: SELECT count(*)
28: FROM OE_AK_HEADER_PRCADJS_V b
29: WHERE b.HEADER_ID = OE_HEADER_ADJ_SECURITY.g_record.HEADER_ID
30: ;
31:
32: BEGIN
33: x_result := 0;