APPS.OKS_BILL_REC_PUB dependencies on OKS_LEVEL_ELEMENTS

Line 170: SELECT lvl.date_end FROM oks_level_elements lvl

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

Line 394: oks_level_elements lvl

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

Line 520: UPDATE oks_level_elements

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

Line 528: UPDATE oks_level_elements

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

Line 2011: oks_level_elements lvl

2007:
2008: Cursor rules_csr(p_line_id in number,p_termination_date in Date) Is
2009: SELECT str.uom_code l_freq
2010: FROM oks_stream_levels_b str,
2011: oks_level_elements lvl
2012: WHERE lvl.cle_id = p_line_id
2013: AND p_termination_date BETWEEN lvl.date_start AND lvl.date_end
2014: AND lvl.rul_id = str.id;
2015:

Line 5757: FROM oks_level_elements

5753: AND bsd.bsl_id = bsl.id;
5754:
5755: CURSOR l_max_date_end (p_cle_id IN NUMBER, p_date IN DATE) IS
5756: SELECT MAX(date_end)
5757: FROM oks_level_elements
5758: WHERE cle_id = p_cle_id
5759: AND trunc(date_end) < trunc(p_date)
5760: AND date_completed is NOT NULL;
5761:

Line 5765: FROM oks_level_elements

5761:
5762:
5763: CURSOR l_min_date_start (p_cle_id IN NUMBER, p_date IN DATE) IS
5764: SELECT MIN(date_start)
5765: FROM oks_level_elements
5766: WHERE cle_id = p_cle_id
5767: AND trunc(date_start) > trunc(p_date)
5768: AND date_completed is NOT NULL;
5769:

Line 9214: FROM oks_level_elements

9210: WHERE id = p_sub_line_id ;
9211:
9212: CURSOR l_bill_amount_csr(p_sub_line_id in NUMBER ) is
9213: SELECT sum(nvl(amount,0)) bill_amount
9214: FROM oks_level_elements
9215: WHERE cle_id = p_sub_line_id ;
9216:
9217: CURSOR l_credit_csr(p_sub_line_id in NUMBER ) is
9218: SELECT sum(bsl.amount) suppressed_credit

Line 10017: FROM oks_level_elements lvl

10013:
10014: Cursor max_billto_date_csr(p_cle_id IN NUMBER)
10015: IS
10016: SELECT max(TRUNC(lvl.date_end))
10017: FROM oks_level_elements lvl
10018: WHERE cle_id = p_cle_id;
10019:
10020: CURSOR L_HDR_CURR_CODE (p_id in number ) is
10021: SELECT currency_code

Line 10028: FROM oks_level_elements

10024:
10025: CURSOR l_line_BS_csr(p_line_id NUMBER,p_date in date) IS
10026: SELECT id,trunc(date_start) date_start,
10027: amount,trunc(date_end) date_end
10028: FROM oks_level_elements
10029: WHERE cle_id = p_line_id
10030: AND TRUNC(date_start) > p_date
10031: ORDER BY date_start;
10032:

Line 10499: FROM oks_level_elements lvl

10495:
10496: Cursor max_billto_date_csr(p_cle_id IN NUMBER)
10497: IS
10498: SELECT max(TRUNC(lvl.date_end))
10499: FROM oks_level_elements lvl
10500: WHERE cle_id = p_cle_id;
10501:
10502: l_quantity NUMBER;
10503: l_termination_amount NUMBER;