DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 302: from OKC_XPRT_TEMPLATE_RULES rules, okc_terms_templates_all temp

298:
299: -- cursor to retrieve templates associated to the rule
300: CURSOR template_cursor IS
301: select distinct(temp.template_id) Template_Id, temp.org_id, temp.intent
302: from OKC_XPRT_TEMPLATE_RULES rules, okc_terms_templates_all temp
303: where rules.rule_id = p_rule_id
304: and rules.template_id = temp.template_id
305: and (sysdate between nvl(temp.start_date, sysdate) and nvl(temp.end_date, sysdate ))
306: UNION

Line 310: FROM okc_terms_templates_all t,

306: UNION
307: -- Org Wide Rule templates. Reverted back the changes done for 5019422 by removing
308: -- join to okc_xprt_template_rules
309: SELECT t.template_id, t.org_id, t.intent
310: FROM okc_terms_templates_all t,
311: okc_xprt_rule_hdrs_all r
312: WHERE t.org_id = r.org_id
313: AND t.intent = r.intent
314: AND t.contract_expert_enabled = 'Y'