APPS.OKC_TERMS_UTIL_PVT dependencies on DUAL

Line 1871: FROM dual

1867: l_global_org_id number;
1868:
1869: CURSOR alt_csr IS
1870: SELECT 1
1871: FROM dual
1872: WHERE exists (select 1
1873: from OKC_ARTICLE_RELATNS_ALL
1874: where org_id = p_org_id
1875: and source_article_id = p_article_id

Line 4358: AND rr.Role_resource_type = 'RS_INDIVIDUAL'

4354: jtf_rs_resource_extns sre
4355: WHERE sales_team.quote_number = p_quote_number
4356: AND rr.ROLE_ID = rl.ROLE_ID
4357: AND NVL(rr.delete_flag,'N') <> 'Y'
4358: AND rr.Role_resource_type = 'RS_INDIVIDUAL'
4359: -- For Bug# 6343627 AND (rr.end_date_active IS NULL OR rr.end_date_active >= SYSDATE)
4360: AND (rr.end_date_active IS NULL OR rr.end_date_active > SYSDATE)
4361: AND (
4362: (rl.role_type_code = 'CONTRACTS' AND rl.role_code = 'CONTRACTS_ADMIN')

Line 4382: -- For Bug# 6343627 AND AND rr.Role_resource_type = 'RS_INDIVIDUAL'

4378: AND srg.resource_id = sre.resource_id
4379: AND NVL(srg.delete_flag,'N') <> 'Y'
4380: AND rr.ROLE_ID = rl.ROLE_ID
4381: AND NVL(rr.delete_flag,'N') <> 'Y'
4382: -- For Bug# 6343627 AND AND rr.Role_resource_type = 'RS_INDIVIDUAL'
4383: AND rr.Role_resource_type = 'RS_GROUP_MEMBER'
4384: -- For Bug# 6343627 AND (rr.end_date_active IS NULL OR rr.end_date_active >= SYSDATE)
4385: AND (rr.end_date_active IS NULL OR rr.end_date_active > SYSDATE)
4386: AND rl.role_type_code = 'CONTRACTS'

Line 4804: select fnd_profile.value('ASO_DEFAULT_LAYOUT_TEMPLATE') into l_layout_template_code from dual;

4800: fetch get_bsa_lay_templ_csr into l_layout_template_code;
4801: close get_bsa_lay_templ_csr;
4802: END IF;
4803: ELSIF p_doc_type_class = 'QUOTE' THEN
4804: select fnd_profile.value('ASO_DEFAULT_LAYOUT_TEMPLATE') into l_layout_template_code from dual;
4805:
4806: --ER Structured Terms Authoring in Repository - strivedi
4807: ELSIF p_doc_type_class = 'REPOSITORY' THEN
4808: OPEN get_rep_lay_templ_csr;