DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SUBCLASSES_B

Line 566: FROM okc_subclasses_b

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

Line 3653: FROM okc_subclasses_b osb,okc_k_headers_b okb

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

Line 5146: FROM okc_subclasses_b

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

Line 6056: FROM okc_subclasses_b osb,okc_k_headers_b okb

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

Line 10470: FROM okc_subclasses_b osb,okc_k_headers_b okb

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