APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_HEADER_V

Line 37: From oks_subscr_header_v

33: fulfillment_channel,
34: comments,
35: status,
36: item_type
37: From oks_subscr_header_v
38: Where id = p_template_id;
39:
40: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
41: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;

Line 1049: from oks_subscr_header_v

1045: l_schv_tbl_out OKS_SUBSCR_HDR_PUB.schv_tbl_type;
1046: Cursor src_osh_cur Is
1047: select name, description, instance_id, subscription_type, media_type, frequency,
1048: fulfillment_channel, offset, comments, item_type
1049: from oks_subscr_header_v
1050: where cle_id = p_source_cle_id;
1051: Begin
1052: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1053: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.copy_subscription.copy_osh.begin',' ');

Line 2156: FROM oks_subscr_header_v

2152: fulfillment_channel,
2153: comments,
2154: status,
2155: item_type
2156: FROM oks_subscr_header_v
2157: WHERE id = p_template_id
2158: AND dnz_chr_id = -1;
2159:
2160: l_sub_template_rec get_template_dtls_csr%RowTYPE;