APPS.OKS_BILL_REC_PUB dependencies on OKS_LEVEL_ELEMENTS

Line 168: SELECT lvl.date_end FROM oks_level_elements lvl

164: AND line.dnz_chr_id = hdr.chr_id;
165:
166:
167: Cursor Termination_csr(p_cle_id NUMBER,p_termination_date DATE) IS
168: SELECT lvl.date_end FROM oks_level_elements lvl
169: WHERE lvl.cle_id = p_cle_id
170: AND trunc(p_termination_date ) BETWEEN trunc(lvl.date_start) AND
171: trunc(lvl.date_end);
172:

Line 391: oks_level_elements lvl

387:
388: Cursor rules_csr(l_termination_date IN DATE,p_cov_line_id IN NUMBER) IS
389: SELECT str.uom_code l_freq
390: FROM oks_stream_levels_b str,
391: oks_level_elements lvl
392: WHERE lvl.cle_id = p_cov_line_id
393: AND lvl.rul_id = str.id
394: AND l_termination_date between lvl.date_start and lvl.date_end;
395:

Line 517: UPDATE oks_level_elements

513: --greater than the termination amount and termination date
514: --is less than or equal to the max billed to date
515: IF p_period_start is NOT NULL and p_period_type IS NOT NULL
516: THEN
517: UPDATE oks_level_elements
518: SET date_completed = p_date_to,
519: amount = p_con_terminate_amount
520: WHERE cle_id = p_cov_line_id
521: AND date_completed is null

Line 525: UPDATE oks_level_elements

521: AND date_completed is null
522: AND date_start = p_date_from
523: AND date_end = p_date_to;
524:
525: UPDATE oks_level_elements
526: SET date_completed = p_date_to,
527: amount = amount-p_amount+p_con_terminate_amount
528: WHERE cle_id = p_top_line_id
529: AND date_completed is null

Line 1997: oks_level_elements lvl

1993:
1994: Cursor rules_csr(p_line_id in number,p_termination_date in Date) Is
1995: SELECT str.uom_code l_freq
1996: FROM oks_stream_levels_b str,
1997: oks_level_elements lvl
1998: WHERE lvl.cle_id = p_line_id
1999: AND p_termination_date BETWEEN lvl.date_start AND lvl.date_end
2000: AND lvl.rul_id = str.id;
2001:

Line 5731: FROM oks_level_elements

5727: AND bsd.bsl_id = bsl.id;
5728:
5729: CURSOR l_max_date_end (p_cle_id IN NUMBER, p_date IN DATE) IS
5730: SELECT MAX(date_end)
5731: FROM oks_level_elements
5732: WHERE cle_id = p_cle_id
5733: AND trunc(date_end) < trunc(p_date)
5734: AND date_completed is NOT NULL;
5735:

Line 5739: FROM oks_level_elements

5735:
5736:
5737: CURSOR l_min_date_start (p_cle_id IN NUMBER, p_date IN DATE) IS
5738: SELECT MIN(date_start)
5739: FROM oks_level_elements
5740: WHERE cle_id = p_cle_id
5741: AND trunc(date_start) > trunc(p_date)
5742: AND date_completed is NOT NULL;
5743:

Line 9172: FROM oks_level_elements

9168: WHERE id = p_sub_line_id ;
9169:
9170: CURSOR l_bill_amount_csr(p_sub_line_id in NUMBER ) is
9171: SELECT sum(nvl(amount,0)) bill_amount
9172: FROM oks_level_elements
9173: WHERE cle_id = p_sub_line_id ;
9174:
9175: CURSOR l_credit_csr(p_sub_line_id in NUMBER ) is
9176: SELECT sum(bsl.amount) suppressed_credit

Line 9927: FROM oks_level_elements lvl

9923:
9924: Cursor max_billto_date_csr(p_cle_id IN NUMBER)
9925: IS
9926: SELECT max(TRUNC(lvl.date_end))
9927: FROM oks_level_elements lvl
9928: WHERE cle_id = p_cle_id;
9929:
9930: CURSOR L_HDR_CURR_CODE (p_id in number ) is
9931: SELECT currency_code

Line 9938: FROM oks_level_elements

9934:
9935: CURSOR l_line_BS_csr(p_line_id NUMBER,p_date in date) IS
9936: SELECT id,trunc(date_start) date_start,
9937: amount,trunc(date_end) date_end
9938: FROM oks_level_elements
9939: WHERE cle_id = p_line_id
9940: AND TRUNC(date_start) > p_date
9941: ORDER BY date_start;
9942:

Line 10381: FROM oks_level_elements lvl

10377:
10378: Cursor max_billto_date_csr(p_cle_id IN NUMBER)
10379: IS
10380: SELECT max(TRUNC(lvl.date_end))
10381: FROM oks_level_elements lvl
10382: WHERE cle_id = p_cle_id;
10383:
10384: l_quantity NUMBER;
10385: l_termination_amount NUMBER;