APPS.OKS_BILL_REC_PUB dependencies on OKS_SUBSCR_HEADER_B
Line 4152: Select fulfillment_channel from oks_subscr_header_b
4148: and bsl.bcl_id = bcl.id
4149: and bcl.bill_action = 'RI';
4150:
4151: Cursor sub_fullfilment_channel(p_id IN NUMBER) is 4152: Select fulfillment_channel from oks_subscr_header_b 4153: where cle_id = p_id;
4154:
4155: Cursor bcl_amount(p_bcl_id in number) is
4156: Select nvl(amount,0),cle_id ,btn_id,bill_action