DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PUB dependencies on OKC_K_ITEMS_V

Line 1184: FROM oks_subscr_header_b sub, okc_k_items_v item

1180: FUNCTION is_not_subscrip(p_cle_id NUMBER) RETURN VARCHAR2
1181: IS
1182: CURSOR chk_subscr_item_csr IS
1183: SELECT COUNT(instance_id) cnt
1184: FROM oks_subscr_header_b sub, okc_k_items_v item
1185: WHERE sub.instance_id = item.object1_id1
1186: AND item.cle_id = p_cle_id;
1187: chk_subscr_item_rec chk_subscr_item_csr%ROWTYPE;
1188: