DBA Data[Home] [Help]

APPS.OKS_BILL_REC_PUB dependencies on OKS_SUBSCR_HEADER_B

Line 4126: Select fulfillment_channel from oks_subscr_header_b

4122: and bsl.bcl_id = bcl.id
4123: and bcl.bill_action = 'RI';
4124:
4125: Cursor sub_fullfilment_channel(p_id IN NUMBER) is
4126: Select fulfillment_channel from oks_subscr_header_b
4127: where cle_id = p_id;
4128:
4129: Cursor bcl_amount(p_bcl_id in number) is
4130: Select nvl(amount,0),cle_id ,btn_id,bill_action