DBA Data[Home] [Help]

APPS.OKC_TERMINATE_PVT dependencies on OKC_K_PROCESSES

Line 305: FROM okc_k_processes v

301: l_chrv_rec cur_k_header%rowtype;
302:
303: CURSOR is_k_locked is
304: SELECT 'Y'
305: FROM okc_k_processes v
306: WHERE v.chr_id = p_terminate_in_parameters_rec.p_contract_id
307: and v.in_process_yn='Y';
308:
309: CURSOR cur_sts_code (l_code varchar2) is

Line 1146: FROM okc_k_processes v

1142: l_chrv_rec k_csr%rowtype;
1143:
1144: CURSOR is_k_locked is
1145: SELECT 'x'
1146: FROM okc_k_processes v
1147: WHERE v.chr_id = p_terminate_in_parameters_rec.p_dnz_chr_id
1148: and v.in_process_yn = 'Y';
1149:
1150: -- p_code changed from number to Varchar2