APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_SUBSCR_HEADER_B

Line 7105: FROM okc_k_items a, oks_subscr_header_b b

7101: -- Checks if the item it's covering is a subscritpion item and then it gets
7102: -- the item instance
7103: CURSOR get_item_inst(subline_id NUMBER) IS
7104: SELECT a.object1_id1
7105: FROM okc_k_items a, oks_subscr_header_b b
7106: WHERE a.cle_id = subline_id
7107: AND b.instance_id = a.object1_id1;
7108:
7109:

Line 7113: FROM okc_k_headers_all_b a, oks_subscr_header_b b

7109:
7110: -- is item instance valid
7111: CURSOR get_subscr(instId NUMBER) IS
7112: SELECT b.dnz_chr_id subscr_chr_id, b.cle_id subscr_line_id
7113: FROM okc_k_headers_all_b a, oks_subscr_header_b b
7114: WHERE b.instance_id = instId AND b.dnz_chr_id = a.id AND
7115: (a.id = p_chr_id OR (a.id <> p_chr_id AND a.sts_code IN ('ACTIVE', 'SIGNED')) );
7116:
7117: -- See if the cp dates fall within the the subscription line start date, end date

Line 7206: FROM oks_subscr_header_b a

7202: ;
7203:
7204: CURSOR is_tangible_item(cleId NUMBER) IS
7205: SELECT a.id
7206: FROM oks_subscr_header_b a
7207: WHERE a.cle_id = cleId AND a.dnz_chr_id = p_chr_id
7208: AND a.fulfillment_channel = 'OM';
7209:
7210: CURSOR get_subscr_element(oshId NUMBER, cleId NUMBER) IS

Line 7414: FROM oks_subscr_header_b b

7410: l_item_inst Get_Item_Inst%ROWTYPE;
7411:
7412: CURSOR is_subscr_item(l_inst_id NUMBER) IS
7413: SELECT b.instance_id
7414: FROM oks_subscr_header_b b
7415: WHERE b.instance_id = l_inst_id;
7416:
7417: l_subscr_inst_id is_subscr_item%ROWTYPE;
7418: