APPS.OKC_AST_PVT dependencies on OKC_CHANGE_REQUESTS_B

Line 2397: l_cur_user okc_change_requests_b.user_id%TYPE := FND_GLOBAL.USER_ID;

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;
2400: l_date_signed DATE;
2401: --

Line 2421: okc_change_requests_b crq

2417: --
2418: cursor lock_csr (p_in_process_yn okc_k_processes.in_process_yn%TYPE) is
2419: select prc.user_id
2420: from okc_k_processes prc,
2421: okc_change_requests_b crq
2422: where crq.id = p_crt_id
2423: and crq.chr_id = p_header_id
2424: and crq.datetime_applied is null
2425: and crq.id = prc.crt_id

Line 2431: okc_change_requests_b crq

2427: --
2428: cursor proc_csr (p_in_process_yn okc_k_processes.in_process_yn%TYPE) is
2429: select prc.user_id
2430: from okc_k_processes prc,
2431: okc_change_requests_b crq
2432: where crq.chr_id = p_header_id
2433: and crq.datetime_applied is null
2434: and crq.id = prc.crt_id
2435: and upper(substr(prc.in_process_yn, 1, 1)) = p_in_process_yn;

Line 2439: from okc_change_requests_b crq

2435: and upper(substr(prc.in_process_yn, 1, 1)) = p_in_process_yn;
2436: --
2437: cursor user_csr is
2438: select 'x'
2439: from okc_change_requests_b crq
2440: where crq.id = p_crt_id
2441: and crq.chr_id = p_header_id
2442: and crq.datetime_applied is null
2443: and crq.user_id = l_cur_user;