APPS.OKC_CLM_PKG dependencies on DUAL

Line 314: p_mode => :6) from dual'

310: pk1_value => :2,
311: pk2_value => :3,
312: p_attr_grp_int_name => :4,
313: p_attr_int_name => :5,
314: p_mode => :6) from dual'
315: INTO l_variable_value
316: USING l_entity_name,l_pk1_value,l_pk2_value,l_attr_grp,l_attr,p_uda_mode;
317:
318: ELSIF p_clm_ref1='address' THEN

Line 366: p_address_type => :12) from dual'

362: p_attr_grp_id => NULL,
363: p_attr_grp_int_name => :9,
364: p_attr_id => NULL,
365: p_attr_int_name => :11,
366: p_address_type => :12) from dual'
367: INTO l_variable_value
368: USING l_entity_name,l_pk1_value,l_pk2_value,p_clm_ref2,p_clm_ref3,p_clm_ref4;
369:
370:

Line 1709: SELECT 'Y' FROM dual WHERE p_template_id IN (

1705: IS
1706: l_api_name CONSTANT VARCHAR2(30) := 'check_dup_templates';
1707:
1708: CURSOR l_template_exists_csr IS
1709: SELECT 'Y' FROM dual WHERE p_template_id IN (
1710: SELECT template_id FROM okc_template_usages
1711: WHERE document_type = p_document_type AND document_id = p_document_id
1712: UNION ALL
1713: SELECT template_id FROM okc_mlp_template_usages