APPS.OKC_CLE_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 104: FROM OKC_K_HEADERS_ALL_B

100: select 'x'
101: --npalepu 08-11-2005 modified for bug # 4691662.
102: --Replaced table okc_k_headers_b with headers_All_b table
103: /* from OKC_K_HEADERS_B */
104: FROM OKC_K_HEADERS_ALL_B
105: --end npalepu
106: where ID = p_clev_rec.chr_id;
107: Begin
108:

Line 547: FROM OKC_K_HEADERS_ALL_B

543: select 'x'
544: --npalepu 08-11-2005 modified for bug # 4691662.
545: --Replaced table okc_k_headers_b with headers_All_b table
546: /* from OKC_K_HEADERS_B */
547: FROM OKC_K_HEADERS_ALL_B
548: --end npalepu
549: where ID = p_clev_rec.dnz_chr_id;
550: Begin
551:

Line 1162: FROM OKC_K_HEADERS_ALL_B

1158: SELECT START_DATE, END_DATE
1159: --npalepu 08-11-2005 modified for bug # 4691662.
1160: --Replaced table okc_k_headers_b with headers_All_b table
1161: /* FROM OKC_K_HEADERS_B */
1162: FROM OKC_K_HEADERS_ALL_B
1163: --end npalepu
1164: WHERE ID = p_clev_rec.dnz_chr_id;
1165:
1166: -- Cursor to get parent line's start and end dates

Line 1290: FROM OKC_K_HEADERS_ALL_B

1286: SELECT START_DATE, END_DATE
1287: --npalepu 08-11-2005 modified for bug # 4691662.
1288: --Replaced table okc_k_headers_b with headers_All_b table
1289: /* FROM OKC_K_HEADERS_B */
1290: FROM OKC_K_HEADERS_ALL_B
1291: --end npalepu
1292: WHERE ID = p_clev_rec.dnz_chr_id;
1293:
1294: -- Cursor to get parent line's start and end dates

Line 3913: Select application_id from okc_k_headers_all_b

3909: Cursor l_application_csr Is
3910: --npalepu 08-11-2005 modified for bug # 4691662.
3911: --Replaced table okc_k_headers_b with headers_All_b table
3912: /* Select application_id from okc_k_headers_b */
3913: Select application_id from okc_k_headers_all_b
3914: --end npalepu
3915: Where id = p_clev_rec.dnz_chr_id;
3916:
3917: BEGIN

Line 4323: FROM OKC_K_HEADERS_ALL_B

4319: SELECT END_DATE
4320: --npalepu 08-11-2005 modified for bug # 4691662.
4321: --Replaced table okc_k_headers_b with headers_All_b table
4322: /* FROM OKC_K_HEADERS_B */
4323: FROM OKC_K_HEADERS_ALL_B
4324: --end npalepu
4325: WHERE ID = p_clev_rec.dnz_chr_id;
4326: l_end_date DATE;
4327: BEGIN

Line 8203: UPDATE OKC_K_HEADERS_ALL_B

8199: If (ole_rec.active_yn = 'Y') Then
8200: --npalepu 08-11-2005 modified for bug # 4691662.
8201: --Replaced table okc_k_headers_b with headers_All_b table
8202: /* UPDATE okc_k_headers_b */
8203: UPDATE OKC_K_HEADERS_ALL_B
8204: --end npalepu
8205: SET date_renewed = null
8206: WHERE id = ole_rec.object_chr_id
8207: AND date_renewed is not null;

Line 8533: UPDATE OKC_K_HEADERS_ALL_B

8529: If (ole_rec.active_yn = 'Y') Then
8530: --npalepu 08-11-2005 modified for bug # 4691662.
8531: --Replaced table okc_k_headers_b with headers_All_b table
8532: /* UPDATE okc_k_headers_b */
8533: UPDATE OKC_K_HEADERS_ALL_B
8534: --end npalepu
8535: SET date_renewed = null
8536: WHERE id = ole_rec.object_chr_id
8537: AND date_renewed is not null;