[Home] [Help]
1533: WHERE id = p_id;
1534:
1535: CURSOR c_atn(p_id IN NUMBER) IS
1536: SELECT id
1537: FROM okc_article_trans_v
1538: WHERE cat_id = p_id;
1539:
1540: CURSOR c_scc IS
1541: SELECT id
6702: CAT_ID,
6703: CLE_ID,
6704: RUL_ID,
6705: DNZ_CHR_ID
6706: FROM OKC_ARTICLE_TRANS_V
6707: WHERE ID = p_atn_id
6708: AND g_copy_history_yn = 'N'
6709: UNION ALL
6710: SELECT ID,