DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 340: from OKC_XPRT_TEMPLATE_RULES rules, okc_terms_templates_all temp

336:
337: -- cursor to retrieve templates associated to the rule
338: CURSOR template_cursor IS
339: select distinct(temp.template_id) Template_Id, temp.org_id, temp.intent
340: from OKC_XPRT_TEMPLATE_RULES rules, okc_terms_templates_all temp
341: where rules.rule_id = p_rule_id
342: and rules.template_id = temp.template_id
343: and (sysdate between nvl(temp.start_date, sysdate) and nvl(temp.end_date, sysdate ))
344: UNION

Line 348: FROM okc_terms_templates_all t,

344: UNION
345: -- Org Wide Rule templates. Reverted back the changes done for 5019422 by removing
346: -- join to okc_xprt_template_rules
347: SELECT t.template_id, t.org_id, t.intent
348: FROM okc_terms_templates_all t,
349: okc_xprt_rule_hdrs_all r
350: WHERE t.org_id = r.org_id
351: AND t.intent = r.intent
352: AND t.contract_expert_enabled = 'Y'