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 1133: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl

1129: AND DOCUMENT_ID = P_DOC_ID
1130: AND CONTRACT_ADMIN_ID IS NOT NULL;
1131:
1132: CURSOR contract_admin_emp is
1133: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1134: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1135: AND USG.DOCUMENT_ID = P_DOC_ID
1136: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1137: AND USG.contract_admin_id = ctrtadm.user_id

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

1138: AND ctrtadm.employee_id = adminppl.person_id
1139: and rownum < 2;
1140:
1141: CURSOR contract_admin_valid_emp is
1142: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1143: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1144: AND USG.DOCUMENT_ID = P_DOC_ID
1145: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1146: AND USG.contract_admin_id = ctrtadm.user_id

Line 2711: OKC_TEMPLATE_USAGES USG

2707: CURSOR l_get_template_crs IS
2708: SELECT status_code,end_date,template_name
2709: FROM
2710: OKC_TERMS_TEMPLATES_ALL TMPL,
2711: OKC_TEMPLATE_USAGES USG
2712: WHERE USG.DOCUMENT_TYPE = p_doc_type
2713: AND USG.DOCUMENT_ID = p_doc_id
2714: AND TMPL.TEMPLATE_ID = USG.TEMPLATE_ID;
2715:

Line 2721: FROM OKC_TEMPLATE_USAGES

2717: CURSOR l_get_template_usg_csr IS
2718: SELECT 'Y'
2719: FROM OKC_ALLOWED_TMPL_USAGES
2720: WHERE TEMPLATE_ID = (SELECT TEMPLATE_ID
2721: FROM OKC_TEMPLATE_USAGES
2722: WHERE DOCUMENT_ID = p_doc_id
2723: AND DOCUMENT_TYPE = p_doc_type)
2724: AND DOCUMENT_TYPE = p_doc_type;
2725: --Bug 4126819 Added cursor to get the document type

Line 3020: OKC_TEMPLATE_USAGES USG,

3016: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
3017: FROM OKC_K_ARTICLES_B KART,
3018: OKC_ARTICLE_VERSIONS VERS,
3019: OKC_ARTICLE_VERSIONS VERS1,
3020: OKC_TEMPLATE_USAGES USG,
3021: OKC_TERMS_TEMPLATES_ALL TMPL
3022: WHERE KART.DOCUMENT_TYPE=p_doc_type
3023: AND KART.DOCUMENT_ID =p_doc_id
3024: AND KART.DOCUMENT_TYPE= USG.DOCUMENT_TYPE

Line 4509: FROM OKC_TEMPLATE_USAGES

4505: AND DOCUMENT_ID = p_doc_id;
4506:
4507: CURSOR l_get_effective_date IS
4508: SELECT nvl(ARTICLE_EFFECTIVE_DATE ,sysdate)
4509: FROM OKC_TEMPLATE_USAGES
4510: WHERE DOCUMENT_TYPE=p_doc_type
4511: AND DOCUMENT_ID=p_doc_id;
4512:
4513: /* Modified in 11.5.10+ to get additonal template information