APPS.OKC_TERMS_UTIL_PVT dependencies on DUAL

Line 1913: FROM dual

1909: l_global_org_id number;
1910:
1911: CURSOR alt_csr IS
1912: SELECT 1
1913: FROM dual
1914: WHERE exists (select 1
1915: from OKC_ARTICLE_RELATNS_ALL
1916: where org_id = p_org_id
1917: and source_article_id = p_article_id

Line 4407: AND rr.Role_resource_type = 'RS_INDIVIDUAL'

4403: jtf_rs_resource_extns sre
4404: WHERE sales_team.quote_number = p_quote_number
4405: AND rr.ROLE_ID = rl.ROLE_ID
4406: AND NVL(rr.delete_flag,'N') <> 'Y'
4407: AND rr.Role_resource_type = 'RS_INDIVIDUAL'
4408: -- For Bug# 6343627 AND (rr.end_date_active IS NULL OR rr.end_date_active >= SYSDATE)
4409: AND (rr.end_date_active IS NULL OR rr.end_date_active > SYSDATE)
4410: AND (
4411: (rl.role_type_code = 'CONTRACTS' AND rl.role_code = 'CONTRACTS_ADMIN')

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

4427: AND srg.resource_id = sre.resource_id
4428: AND NVL(srg.delete_flag,'N') <> 'Y'
4429: AND rr.ROLE_ID = rl.ROLE_ID
4430: AND NVL(rr.delete_flag,'N') <> 'Y'
4431: -- For Bug# 6343627 AND AND rr.Role_resource_type = 'RS_INDIVIDUAL'
4432: AND rr.Role_resource_type = 'RS_GROUP_MEMBER'
4433: -- For Bug# 6343627 AND (rr.end_date_active IS NULL OR rr.end_date_active >= SYSDATE)
4434: AND (rr.end_date_active IS NULL OR rr.end_date_active > SYSDATE)
4435: AND rl.role_type_code = 'CONTRACTS'

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

4849: fetch get_bsa_lay_templ_csr into l_layout_template_code;
4850: close get_bsa_lay_templ_csr;
4851: END IF;
4852: ELSIF p_doc_type_class = 'QUOTE' THEN
4853: select fnd_profile.value('ASO_DEFAULT_LAYOUT_TEMPLATE') into l_layout_template_code from dual;
4854:
4855: --ER Structured Terms Authoring in Repository - strivedi
4856: ELSIF p_doc_type_class = 'REPOSITORY' THEN
4857: OPEN get_rep_lay_templ_csr;