APPS.OKC_REP_WF_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 2982: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;

2978: l_master_key wf_items.user_key%TYPE;
2979: l_value VARCHAR2(1);
2980:
2981: CURSOR csr_doc(l_contract_type IN VARCHAR2) IS
2982: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;
2983:
2984: BEGIN
2985:
2986: l_api_name := 'allow_approver_edit';

Line 3066: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;

3062: l_master_key wf_items.user_key%TYPE;
3063: l_value VARCHAR2(1);
3064:
3065: CURSOR csr_doc(l_contract_type IN VARCHAR2) IS
3066: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;
3067:
3068: BEGIN
3069:
3070: l_api_name := 'contract_preview_yn';