APPS.OKC_TERMS_QA_PVT dependencies on OKC_TEMPLATE_USAGES

Line 1127: SELECT 'Y' FROM OKC_TEMPLATE_USAGES

1123: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
1124: AND QA.QA_CODE(+) = G_OKC_CHECK_CONTRACT_ADMIN;
1125:
1126: CURSOR contract_admin_exists is
1127: SELECT 'Y' FROM OKC_TEMPLATE_USAGES
1128: WHERE DOCUMENT_TYPE = P_DOC_TYPE
1129: AND DOCUMENT_ID = P_DOC_ID
1130: AND CONTRACT_ADMIN_ID IS NOT NULL;
1131:

Line 1143: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl

1139: -- Fix for 13435490 end
1140:
1141:
1142: CURSOR contract_admin_emp is
1143: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1144: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1145: AND USG.DOCUMENT_ID = P_DOC_ID
1146: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1147: AND USG.contract_admin_id = ctrtadm.user_id

Line 1152: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl

1148: AND ctrtadm.employee_id = adminppl.person_id
1149: and rownum < 2;
1150:
1151: CURSOR contract_admin_valid_emp is
1152: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1153: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1154: AND USG.DOCUMENT_ID = P_DOC_ID
1155: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1156: AND USG.contract_admin_id = ctrtadm.user_id

Line 2745: OKC_TEMPLATE_USAGES USG

2741: CURSOR l_get_template_crs IS
2742: SELECT status_code,end_date,template_name
2743: FROM
2744: OKC_TERMS_TEMPLATES_ALL TMPL,
2745: OKC_TEMPLATE_USAGES USG
2746: WHERE USG.DOCUMENT_TYPE = p_doc_type
2747: AND USG.DOCUMENT_ID = p_doc_id
2748: AND TMPL.TEMPLATE_ID = USG.TEMPLATE_ID;
2749:

Line 2755: FROM OKC_TEMPLATE_USAGES

2751: CURSOR l_get_template_usg_csr IS
2752: SELECT 'Y'
2753: FROM OKC_ALLOWED_TMPL_USAGES
2754: WHERE TEMPLATE_ID = (SELECT TEMPLATE_ID
2755: FROM OKC_TEMPLATE_USAGES
2756: WHERE DOCUMENT_ID = p_doc_id
2757: AND DOCUMENT_TYPE = p_doc_type)
2758: AND DOCUMENT_TYPE = p_doc_type;
2759: --Bug 4126819 Added cursor to get the document type

Line 3054: OKC_TEMPLATE_USAGES USG,

3050: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
3051: FROM OKC_K_ARTICLES_B KART,
3052: OKC_ARTICLE_VERSIONS VERS,
3053: OKC_ARTICLE_VERSIONS VERS1,
3054: OKC_TEMPLATE_USAGES USG,
3055: OKC_TERMS_TEMPLATES_ALL TMPL
3056: WHERE KART.DOCUMENT_TYPE=p_doc_type
3057: AND KART.DOCUMENT_ID =p_doc_id
3058: AND KART.DOCUMENT_TYPE= USG.DOCUMENT_TYPE

Line 4543: FROM OKC_TEMPLATE_USAGES

4539: AND DOCUMENT_ID = p_doc_id;
4540:
4541: CURSOR l_get_effective_date IS
4542: SELECT nvl(ARTICLE_EFFECTIVE_DATE ,sysdate)
4543: FROM OKC_TEMPLATE_USAGES
4544: WHERE DOCUMENT_TYPE=p_doc_type
4545: AND DOCUMENT_ID=p_doc_id;
4546:
4547: /* Modified in 11.5.10+ to get additonal template information