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_COPY_CONTRACT_PVT dependencies on OKC_SUBCLASSES_B

Line 565: FROM okc_subclasses_b

561: WHERE code = p_code;
562:
563: CURSOR c_class(p_scs_code IN VARCHAR2) IS
564: SELECT cls_code
565: FROM okc_subclasses_b
566: WHERE code = p_scs_code;
567:
568: BEGIN
569:

Line 3652: FROM okc_subclasses_b osb,okc_k_headers_b okb

3648: -- cursor to get the contract category
3649:
3650: CURSOR l_Service_Contract_csr IS
3651: SELECT osb.cls_code
3652: FROM okc_subclasses_b osb,okc_k_headers_b okb
3653: WHERE okb.id = p_from_chr_id
3654: AND okb.scs_code = osb.code ;
3655:
3656: -- Added for Bug 3764231

Line 5145: FROM okc_subclasses_b

5141: Cursor cop_csr Is
5142: SELECT id
5143: FROM okc_class_operations
5144: WHERE cls_code = ( SELECT cls_code
5145: FROM okc_subclasses_b
5146: WHERE code = p_chrv_rec.scs_code )
5147: AND opn_code = 'RENEWAL';
5148:
5149: l_cop_id NUMBER;

Line 6055: FROM okc_subclasses_b osb,okc_k_headers_b okb

6051: -- cursor to get the contract category
6052:
6053: CURSOR l_Service_Contract_csr IS
6054: SELECT osb.cls_code
6055: FROM okc_subclasses_b osb,okc_k_headers_b okb
6056: WHERE okb.id = p_chr_id
6057: AND okb.scs_code = osb.code ;
6058:
6059: CURSOR c_lines IS

Line 10469: FROM okc_subclasses_b osb,okc_k_headers_b okb

10465: -- cursor to get the contract category
10466:
10467: CURSOR l_Service_Contract_csr IS
10468: SELECT osb.cls_code
10469: FROM okc_subclasses_b osb,okc_k_headers_b okb
10470: WHERE okb.id = p_from_chr_id
10471: AND okb.scs_code = osb.code ;
10472:
10473: -- Added for Bug 3764231