APPS.OKC_AST_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 2394: l_scs_code okc_k_headers_all_b.scs_code%TYPE;

2390: l_user_id okc_k_processes.user_id%TYPE;
2391: --NPALEPU for bug # 4597099 on 13-AUG-2005
2392: /* l_scs_code okc_k_headers_b.scs_code%TYPE;
2393: l_sts_code okc_k_headers_b.sts_code%TYPE; */
2394: l_scs_code okc_k_headers_all_b.scs_code%TYPE;
2395: l_sts_code okc_k_headers_all_b.sts_code%TYPE;
2396: --END NPALEPU
2397: l_cur_user okc_change_requests_b.user_id%TYPE := FND_GLOBAL.USER_ID;
2398:

Line 2395: l_sts_code okc_k_headers_all_b.sts_code%TYPE;

2391: --NPALEPU for bug # 4597099 on 13-AUG-2005
2392: /* l_scs_code okc_k_headers_b.scs_code%TYPE;
2393: l_sts_code okc_k_headers_b.sts_code%TYPE; */
2394: l_scs_code okc_k_headers_all_b.scs_code%TYPE;
2395: l_sts_code okc_k_headers_all_b.sts_code%TYPE;
2396: --END NPALEPU
2397: l_cur_user okc_change_requests_b.user_id%TYPE := FND_GLOBAL.USER_ID;
2398:
2399: l_date_approved DATE;

Line 2406: from okc_k_headers_all_b

2402: cursor hdr_csr is
2403: select sts_code, scs_code,date_approved, date_signed
2404: --NPALEPU for bug # 4597099 on 13-AUG-2005
2405: /* from okc_k_headers_b */
2406: from okc_k_headers_all_b
2407: --END NPALEPU
2408: where id = p_header_id;
2409: --
2410: cursor ast_csr (p_allowed_yn okc_assents_v.allowed_yn%TYPE) is

Line 2564: OKC_K_HEADERS_ALL_B K,

2560: select 'x'
2561: from okc_k_lines_b L,
2562: --NPALEPU for Bug # 4597099 on 13-AUG-2005
2563: /* okc_k_headers_b K, */
2564: OKC_K_HEADERS_ALL_B K,
2565: --END NPALEPU
2566: okc_assents A
2567: where L.ID = p_line_id
2568: and L.DNZ_CHR_ID = K.ID