APPS.OKS_BILL_REC_PUB dependencies on OKS_SUBSCR_ELEMENTS

Line 1315: FROM oks_subscr_elements

1311: AND bill_action = 'RI';
1312:
1313: Cursor subscr_line_ship_cur (p_id IN NUMBER) is
1314: SELECT nvl(sum(nvl(amount,0)),0),max(end_date)
1315: FROM oks_subscr_elements
1316: WHERE dnz_cle_id = p_id
1317: AND order_header_id is not null;
1318:
1319: Cursor sub_line_billed_cur (p_id IN NUMBER) is

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

1875: WHERE cle_id = p_line_id
1876: AND bill_action = 'RI';
1877:
1878: Cursor ship_amount_cur(p_line_id in number,p_term_date in DATE) is
1879: SELECT nvl(sum(amount),0) FROM oks_subscr_elements
1880: WHERE dnz_cle_id = p_line_id
1881: AND trunc(start_date) < trunc(p_term_date);
1882:
1883: l_ship_amount NUMBER;

Line 3461: SELECT id from oks_subscr_elements

3457:
3458: l_elems_tbl_del_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
3459:
3460: CURSOR del_fulfillment_schedule(p_id in number) is
3461: SELECT id from oks_subscr_elements
3462: where dnz_cle_id = p_id
3463: and order_header_id is null
3464: and start_date >= p_termination_date;
3465:

Line 3510: From oks_subscr_elements

3506: and trunc(date_billed_to ) = trunc(p_date_billed_to);
3507:
3508: Cursor fullfilled_subscr_amount(p_id IN NUMBER) is
3509: Select nvl(sum(nvl(amount,0)),0)
3510: From oks_subscr_elements
3511: Where dnz_cle_id = p_id
3512: and start_date <= p_termination_date;
3513:
3514: Cursor bill_amount_cur(p_line_id in number,p_term_date in DATE) is

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

3517: and bill_action = 'RI'
3518: and trunc(date_billed_From) <= trunc(p_term_date);
3519:
3520: Cursor ship_amount_cur(p_line_id in number,p_term_date in DATE) is
3521: Select nvl(sum(amount),0) from oks_subscr_elements
3522: Where dnz_cle_id = p_line_id;
3523: --and trunc(start_date) < trunc(p_term_date);
3524:
3525: Cursor l_get_bcl_count(l_termination_date in date, l_next_ship_date in date, l_line_id in NUMBER ) is

Line 4089: From oks_subscr_elements

4085: WHERE id = p_hdr_id;
4086:
4087: Cursor fullfilled_subscr_amount(p_id IN NUMBER) is
4088: Select nvl(sum(nvl(amount,0)),0),max(end_date)
4089: From oks_subscr_elements
4090: Where dnz_cle_id = p_id
4091: And order_header_id is not null;
4092:
4093: Cursor fullfilled_subscr_date(p_id IN NUMBER,p_termination_date IN date) is

Line 4095: From oks_subscr_elements

4091: And order_header_id is not null;
4092:
4093: Cursor fullfilled_subscr_date(p_id IN NUMBER,p_termination_date IN date) is
4094: Select max(end_date)
4095: From oks_subscr_elements
4096: Where dnz_cle_id = p_id
4097: and start_date <= p_termination_date - 1 ;
4098:
4099:

Line 4108: from oks_subscr_elements

4104: and bcl.bill_action = 'RI';
4105:
4106: Cursor unbilled_subscr_date (p_id in NUMBER) is
4107: Select min(om_interface_date)
4108: from oks_subscr_elements
4109: Where dnz_Cle_id = p_id
4110: and order_header_id is null;
4111:
4112: