APPS.OKS_BILL_REC_PUB dependencies on OKS_SUBSCR_ELEMENTS

Line 1335: FROM oks_subscr_elements

1331: AND bill_action = 'RI';
1332:
1333: Cursor subscr_line_ship_cur (p_id IN NUMBER) is
1334: SELECT nvl(sum(nvl(amount,0)),0),max(end_date)
1335: FROM oks_subscr_elements
1336: WHERE dnz_cle_id = p_id
1337: AND order_header_id is not null;
1338:
1339: Cursor sub_line_billed_cur (p_id IN NUMBER) is

Line 1893: SELECT nvl(sum(amount),0) FROM oks_subscr_elements

1889: WHERE cle_id = p_line_id
1890: AND bill_action = 'RI';
1891:
1892: Cursor ship_amount_cur(p_line_id in number,p_term_date in DATE) is
1893: SELECT nvl(sum(amount),0) FROM oks_subscr_elements
1894: WHERE dnz_cle_id = p_line_id
1895: AND trunc(start_date) < trunc(p_term_date);
1896:
1897: l_ship_amount NUMBER;

Line 3487: SELECT id from oks_subscr_elements

3483:
3484: l_elems_tbl_del_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
3485:
3486: CURSOR del_fulfillment_schedule(p_id in number) is
3487: SELECT id from oks_subscr_elements
3488: where dnz_cle_id = p_id
3489: and order_header_id is null
3490: and start_date >= p_termination_date;
3491:

Line 3536: From oks_subscr_elements

3532: and trunc(date_billed_to ) = trunc(p_date_billed_to);
3533:
3534: Cursor fullfilled_subscr_amount(p_id IN NUMBER) is
3535: Select nvl(sum(nvl(amount,0)),0)
3536: From oks_subscr_elements
3537: Where dnz_cle_id = p_id
3538: and start_date <= p_termination_date;
3539:
3540: Cursor bill_amount_cur(p_line_id in number,p_term_date in DATE) is

Line 3547: Select nvl(sum(amount),0) from oks_subscr_elements

3543: and bill_action = 'RI'
3544: and trunc(date_billed_From) <= trunc(p_term_date);
3545:
3546: Cursor ship_amount_cur(p_line_id in number,p_term_date in DATE) is
3547: Select nvl(sum(amount),0) from oks_subscr_elements
3548: Where dnz_cle_id = p_line_id;
3549: --and trunc(start_date) < trunc(p_term_date);
3550:
3551: Cursor l_get_bcl_count(l_termination_date in date, l_next_ship_date in date, l_line_id in NUMBER ) is

Line 4115: From oks_subscr_elements

4111: WHERE id = p_hdr_id;
4112:
4113: Cursor fullfilled_subscr_amount(p_id IN NUMBER) is
4114: Select nvl(sum(nvl(amount,0)),0),max(end_date)
4115: From oks_subscr_elements
4116: Where dnz_cle_id = p_id
4117: And order_header_id is not null;
4118:
4119: Cursor fullfilled_subscr_date(p_id IN NUMBER,p_termination_date IN date) is

Line 4121: From oks_subscr_elements

4117: And order_header_id is not null;
4118:
4119: Cursor fullfilled_subscr_date(p_id IN NUMBER,p_termination_date IN date) is
4120: Select max(end_date)
4121: From oks_subscr_elements
4122: Where dnz_cle_id = p_id
4123: and start_date <= p_termination_date - 1 ;
4124:
4125:

Line 4134: from oks_subscr_elements

4130: and bcl.bill_action = 'RI';
4131:
4132: Cursor unbilled_subscr_date (p_id in NUMBER) is
4133: Select min(om_interface_date)
4134: from oks_subscr_elements
4135: Where dnz_Cle_id = p_id
4136: and order_header_id is null;
4137:
4138: