APPS.OKC_XPRT_IMPORT_CLAUSES_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 1124: okc_xprt_rule_hdrs_all r,

1120: SELECT v.object_value_code article_id,
1121: a.article_title
1122: FROM okc_xprt_rule_cond_vals v,
1123: okc_xprt_rule_conditions c,
1124: okc_xprt_rule_hdrs_all r,
1125: okc_articles_all a
1126: WHERE v.rule_condition_id = c.rule_condition_id
1127: AND c.rule_id = r.rule_id
1128: AND a.article_id = to_number(v.object_value_code) -- Fix for bug 5030078.Removed to_char and added to_number

Line 1139: okc_xprt_rule_hdrs_all r,

1135: -- All DISTINCT Clauses from Outcome
1136: SELECT to_char(o.object_value_id) article_id,
1137: a.article_title
1138: FROM okc_xprt_rule_outcomes o,
1139: okc_xprt_rule_hdrs_all r,
1140: okc_articles_all a
1141: WHERE o.rule_id = r.rule_id
1142: AND a.article_id = o.object_value_id
1143: AND o.object_type = 'CLAUSE'

Line 1956: FROM okc_xprt_rule_hdrs_all

1952: -- WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent
1953:
1954: CURSOR csr_intent IS
1955: SELECT DISTINCT INTENT
1956: FROM okc_xprt_rule_hdrs_all
1957: WHERE org_id = p_org_id
1958: AND status_code ='PENDINGPUB';
1959:
1960: CURSOR csr_org_name IS

Line 1974: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

1970: AND deleted_flag=0
1971: AND name = p_folder_name ;
1972: -- AND name = G_CLAUSE_FOLDER_OSR||p_org_id;
1973:
1974: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1975: l_api_version CONSTANT NUMBER := 1;
1976: l_api_name CONSTANT VARCHAR2(30) := 'import_clauses';
1977: l_clause_model_id NUMBER :=NULL;
1978: l_run_id NUMBER;