APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_SUBSCR_ELEMENTS

Line 7212: FROM oks_subscr_elements b

7208: AND a.fulfillment_channel = 'OM';
7209:
7210: CURSOR get_subscr_element(oshId NUMBER, cleId NUMBER) IS
7211: SELECT b.id
7212: FROM oks_subscr_elements b
7213: WHERE b.dnz_cle_id = cleId AND b.dnz_chr_id = p_chr_id
7214: AND b.osh_id = oshId;
7215:
7216: l_sh_id NUMBER;