DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 571: FROM okc_bus_doc_types_b

567: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
568:
569: CURSOR contract_type_csr IS
570: SELECT signature_workflow_name
571: FROM okc_bus_doc_types_b
572: WHERE document_type = p_contract_type;
573:
574: CURSOR contacts_csr IS
575: SELECT Count(*) contact_count FROM okc_rep_party_contacts WHERE contract_id=p_contract_id AND

Line 2249: FROM okc_bus_doc_types_b

2245: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2246:
2247: CURSOR contract_type_csr IS
2248: SELECT approval_workflow_name
2249: FROM okc_bus_doc_types_b
2250: WHERE document_type = p_contract_type;
2251:
2252: contract_type_rec contract_type_csr%ROWTYPE;
2253: