eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CTC_PVT dependencies on OKC_STATUSES_B

Line 60: FROM okc_k_headers_all_b,okc_statuses_b

56: x_return_status OUT NOCOPY VARCHAR2) IS
57:
58: CURSOR c_get_contract_status(p_chr_id IN NUMBER) IS
59: SELECT ste_code
60: FROM okc_k_headers_all_b,okc_statuses_b
61: WHERE id= p_chr_id AND okc_statuses_b.code=okc_k_headers_all_b.sts_code;
62:
63: l_ste_code varchar2(30);
64:

Line 61: WHERE id= p_chr_id AND okc_statuses_b.code=okc_k_headers_all_b.sts_code;

57:
58: CURSOR c_get_contract_status(p_chr_id IN NUMBER) IS
59: SELECT ste_code
60: FROM okc_k_headers_all_b,okc_statuses_b
61: WHERE id= p_chr_id AND okc_statuses_b.code=okc_k_headers_all_b.sts_code;
62:
63: l_ste_code varchar2(30);
64:
65: BEGIN

Line 2753: FROM okc_k_headers_all_b KH,okc_statuses_b STB

2749: l_ste_code VARCHAR2(30);
2750:
2751: CURSOR get_k_status(p_chr_id IN NUMBER) IS
2752: SELECT ste_code
2753: FROM okc_k_headers_all_b KH,okc_statuses_b STB
2754: WHERE KH.sts_code = STB.code
2755: AND id= p_chr_id;
2756:
2757: /*added for bug 6882512*/

Line 3888: FROM okc_k_headers_all_b KH,okc_statuses_b STB

3884: j number;
3885: /*added for bug 6882512*/
3886: CURSOR get_k_status(p_chr_id IN NUMBER) IS
3887: SELECT ste_code
3888: FROM okc_k_headers_all_b KH,okc_statuses_b STB
3889: WHERE KH.sts_code = STB.code
3890: AND id= p_chr_id;
3891: /*added for bug 6882512*/
3892: