APPS.OKS_BILL_SCH dependencies on OKS_SUBSCR_HEADER_B

Line 430: oks_subscr_header_b sub

426:
427: Cursor check_sub_instance IS
428: SELECT 'Y'
429: FROM okc_k_items itm,
430: oks_subscr_header_b sub
431: WHERE itm.cle_id = P_cle_id
432: AND sub.instance_id = itm.object1_id1;
433:
434: CURSOR om_period_csr IS

Line 13159: Select item_type From oks_subscr_header_b Where id = p_id;

13155: Function is_tangible
13156: ( p_id IN NUMBER
13157: ) Return BOOLEAN IS
13158: Cursor subs_hdr Is
13159: Select item_type From oks_subscr_header_b Where id = p_id;
13160: l_type Varchar2(240);
13161: l_tangible Boolean := FALSE;
13162: Begin
13163: Open subs_hdr;