DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PUB dependencies on QP_LIST_HEADERS_B

Line 1158: FROM OKC_PRICE_ADJUSTMENTS A, qp_list_headers_b B

1154: -- HEADERS --
1155: DELETE FROM OKC_PRICE_ADJUSTMENTS
1156: WHERE ID IN
1157: (SELECT A.ID
1158: FROM OKC_PRICE_ADJUSTMENTS A, qp_list_headers_b B
1159: WHERE A.CHR_ID = P_CHR_ID
1160: AND B.LIST_HEADER_ID = A.LIST_HEADER_ID
1161: AND B.CURRENCY_CODE <> P_HEADER_CURRENCY
1162: AND B.CURRENCY_CODE IS NOT NULL ) ;

Line 1166: FROM OKC_PRICE_ADJUSTMENTS A, QP_LIST_HEADERS_B B

1162: AND B.CURRENCY_CODE IS NOT NULL ) ;
1163: -- LINES AND SUBLINES --
1164: DELETE FROM OKC_PRICE_ADJUSTMENTS WHERE
1165: ID IN (SELECT A.ID
1166: FROM OKC_PRICE_ADJUSTMENTS A, QP_LIST_HEADERS_B B
1167: WHERE A.CLE_ID IN
1168: (SELECT ID FROM OKC_K_LINES_B WHERE
1169: DNZ_CHR_ID = P_CHR_ID
1170: AND LSE_ID IN (1, 12, 46, 19, 7, 8, 9, 10, 11, 13, 35, 25))