DBA Data[Home] [Help]

APPS.OKC_PO_INT_GRP dependencies on OKC_TEMPLATE_USAGES

Line 337: FROM okc_template_usages

333: INTO l_tmpl_change
334: FROM dual
335: WHERE NOT exists
336: (SELECT 'Y'
337: FROM okc_template_usages
338: WHERE DOCUMENT_TYPE = p_doc_type
339: AND DOCUMENT_ID = p_doc_id )
340: AND 0 = (SELECT Count(1)
341: FROM okc_deliverables

Line 361: FROM okc_template_usages

357: INTO l_tmpl_change
358: FROM dual
359: WHERE NOT exists
360: (SELECT 'Y'
361: FROM okc_template_usages
362: WHERE DOCUMENT_TYPE = p_doc_type
363: AND DOCUMENT_ID = p_doc_id )
364: AND 1 = (SELECT Count(1)
365: FROM okc_deliverables