APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_SUBSCR_ELEMENTS

Line 7361: FROM oks_subscr_elements b

7357: AND a.fulfillment_channel = 'OM';
7358:
7359: CURSOR get_subscr_element(oshId NUMBER, cleId NUMBER) IS
7360: SELECT b.id
7361: FROM oks_subscr_elements b
7362: WHERE b.dnz_cle_id = cleId AND b.dnz_chr_id = p_chr_id
7363: AND b.osh_id = oshId;
7364:
7365: l_sh_id NUMBER;