eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILL_SCH dependencies on OKS_LEVEL_ELEMENTS

Line 1007: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements

1003: IF x_return_status <> 'S' THEN
1004: RAISE G_EXCEPTION_HALT_VALIDATION;
1005: END IF;
1006:
1007: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements
1008: IF l_sll_out_tbl.count > 0 then
1009: -------------------------------------------------------------------------
1010: -- Begin partial period computation logic
1011: -- Developer Mani Choudhary

Line 1220: FROM oks_level_elements

1216:
1217: SELECT id,trunc(date_start) date_start,
1218: amount,trunc(date_end) date_end,object_version_number,
1219: date_to_interface, date_transaction
1220: FROM oks_level_elements
1221: WHERE cle_id = p_line_id
1222: ORDER BY date_start;
1223:
1224:

Line 1459: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements

1455: IF x_return_status <> 'S' THEN
1456: RAISE G_EXCEPTION_HALT_VALIDATION;
1457: END IF;
1458:
1459: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements
1460: IF l_sll_out_tbl.count <= 0 THEN
1461: -----errorout_ad('sll count = ' || to_char(0));
1462: x_return_status := 'E';
1463: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1502: DELETE FROM OKS_LEVEL_ELEMENTS

1498:
1499: --if full credit flag is 'Y' just delete the unbilled lvl elements
1500:
1501: IF nvl(l_Line_Csr_Rec.full_credit, 'N') = 'Y' Then
1502: DELETE FROM OKS_LEVEL_ELEMENTS
1503: WHERE date_completed IS NULL
1504: AND cle_id = l_Line_Csr_Rec.id;
1505:
1506:

Line 1806: DELETE FROM oks_level_elements WHERE cle_id = l_subline_csr_rec.subline_id;

1802: IF nvl(l_subline_csr_rec.billing_schedule_type,p_billing_type) <> p_billing_type THEN
1803: ---Delete all the sll and lvl element for the sub line as billing type from
1804: ---the form can only be changed if no records are billed.
1805:
1806: DELETE FROM oks_level_elements WHERE cle_id = l_subline_csr_rec.subline_id;
1807:
1808: DELETE FROM oks_stream_levels_b WHERE cle_id = l_subline_csr_rec.subline_id;
1809: END IF; --if sub line billing type <> p_billing_type
1810:

Line 2520: ----if l_cp_sll_out_tbl.count > 0 then insert lines into oks_level_elements_v

2516: ||', l_cp_sll_out_tbl count = '|| l_cp_sll_out_tbl.count ||')');
2517: END IF;
2518:
2519: -------------errorout_ad('SLL Record FOR SUBLINE = ' || TO_CHAR(l_cp_sll_out_tbl.count));
2520: ----if l_cp_sll_out_tbl.count > 0 then insert lines into oks_level_elements_v
2521: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2522: RAISE G_EXCEPTION_HALT_VALIDATION;
2523: END IF;
2524:

Line 2600: FROM oks_level_elements element, oks_stream_levels_b sll

2596: element.sequence_number, element.date_transaction,
2597: element.date_start, element.date_to_interface,
2598: element.date_completed, element.amount,element.date_end,
2599: element.rul_id
2600: FROM oks_level_elements element, oks_stream_levels_b sll
2601: WHERE sll.id = element.rul_id
2602: AND sll.cle_id = p_cle_id
2603: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2604:

Line 2611: FROM oks_level_elements element, oks_stream_levels_b sll

2607: element.sequence_number, element.date_transaction,
2608: element.date_start, element.date_to_interface,
2609: element.date_completed, element.amount, element.date_end,
2610: element.rul_id
2611: FROM oks_level_elements element, oks_stream_levels_b sll
2612: WHERE sll.id = element.rul_id
2613: AND sll.chr_id = p_chr_id
2614: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2615:

Line 2703: FROM oks_level_elements where rul_id = p_sllid

2699:
2700:
2701: CURSOR l_element_csr(p_sllid Number) IS
2702: SELECT id ,date_start,amount,date_end
2703: FROM oks_level_elements where rul_id = p_sllid
2704: ORDER BY to_number(sequence_number);
2705:
2706:
2707: ----- Bug 5047257 Start

Line 2709: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line

2705:
2706:
2707: ----- Bug 5047257 Start
2708: Cursor l_element_count(p_sll_id in number, last_start_date in Date) is
2709: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line
2710: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2711: and a.date_start <= last_start_date
2712: and Line.cle_id = a.cle_id
2713: and Line.billing_schedule_type in ('T','E');

Line 2710: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )

2706:
2707: ----- Bug 5047257 Start
2708: Cursor l_element_count(p_sll_id in number, last_start_date in Date) is
2709: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line
2710: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2711: and a.date_start <= last_start_date
2712: and Line.cle_id = a.cle_id
2713: and Line.billing_schedule_type in ('T','E');
2714: ----- Bug 5047257 End

Line 2717: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,

2713: and Line.billing_schedule_type in ('T','E');
2714: ----- Bug 5047257 End
2715:
2716: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2717: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2718: oks_stream_levels_b sll1,
2719: oks_stream_levels_b sll2
2720: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2721: and a.date_start <= last_start_date

Line 2720: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )

2716: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2717: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2718: oks_stream_levels_b sll1,
2719: oks_stream_levels_b sll2
2720: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2721: and a.date_start <= last_start_date
2722: and a.rul_id = sll1.id
2723: and sll1.sequence_no = sll2.sequence_no
2724: and sll2.id = p_sll_id

Line 2729: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line

2725: and Line.cle_id = a.cle_id
2726: and Line.billing_schedule_type in ('T','E');
2727:
2728: Cursor l_element_count2(p_sll_id in number, last_start_date in Date) is
2729: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line
2730: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2731: and a.date_start <= last_start_date
2732: and Line.cle_id = a.cle_id
2733: and Line.billing_schedule_type in ('T','E');

Line 2730: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )

2726: and Line.billing_schedule_type in ('T','E');
2727:
2728: Cursor l_element_count2(p_sll_id in number, last_start_date in Date) is
2729: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line
2730: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2731: and a.date_start <= last_start_date
2732: and Line.cle_id = a.cle_id
2733: and Line.billing_schedule_type in ('T','E');
2734: ----- Bug 5047257 End

Line 3017: FROM oks_level_elements

3013: IS
3014:
3015: CURSOR l_tot_amt_csr IS
3016: SELECT nvl(SUM(amount),0) tot_amt
3017: FROM oks_level_elements
3018: WHERE cle_id = p_line_id;
3019:
3020: l_adjusted_amount number;
3021: l_round_level_amt number;

Line 4573: DELETE FROM OKS_LEVEL_ELEMENTS

4569: ---it deletes the level elementwhich are not billed for the given line id.
4570:
4571: x_return_status := 'S';
4572:
4573: DELETE FROM OKS_LEVEL_ELEMENTS
4574: WHERE date_Completed is NULL
4575: AND cle_id = p_cle_id;
4576:
4577:

Line 4604: DELETE FROM OKS_LEVEL_ELEMENTS

4600:
4601: x_return_status := 'S';
4602: ---delete hdr , top line, cp lvl elements together
4603:
4604: DELETE FROM OKS_LEVEL_ELEMENTS
4605: WHERE rul_id IN
4606: (SELECT sll.id
4607: FROM OKS_STREAM_LEVELS_B sll
4608: WHERE sll.dnz_chr_id = p_hdr_id);

Line 5048: FROM OKS_LEVEL_ELEMENTS

5044:
5045: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5046:
5047: SELECT NVL(SUM(AMOUNT),0) INTO l_sll_amt
5048: FROM OKS_LEVEL_ELEMENTS
5049: WHERE rul_id = p_Sll_id;
5050:
5051: RETURN l_sll_amt;
5052:

Line 5107: FROM oks_level_elements

5103: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
5104: SELECT id, trunc(date_start) date_start,
5105: amount,trunc(date_end) date_end,object_version_number,
5106: date_to_interface, date_transaction
5107: FROM oks_level_elements
5108: WHERE cle_id = p_line_id
5109: ORDER BY date_start;
5110:
5111:

Line 6977: DELETE FROM OKS_LEVEL_ELEMENTS

6973: x_return_status := 'S';
6974:
6975:
6976: ----delete lvl elements for cp
6977: DELETE FROM OKS_LEVEL_ELEMENTS
6978: WHERE cle_id IN (SELECT id
6979: FROM OKC_K_LINES_B cp
6980: WHERE cp.cle_id = p_top_line_id
6981: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 6986: DELETE FROM OKS_LEVEL_ELEMENTS

6982:
6983:
6984:
6985: --------delete lvl elemets for top line
6986: DELETE FROM OKS_LEVEL_ELEMENTS
6987: WHERE cle_id = p_top_line_id;
6988:
6989:
6990: ---delete sll of all cp

Line 7029: FROM oks_level_elements element

7025:
7026: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS
7027: SELECT id, trunc(date_start) date_start,
7028: amount, trunc(date_end) date_end
7029: FROM oks_level_elements element
7030: WHERE cle_id = p_cp_id
7031: ORDER by date_start;
7032:
7033: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;

Line 7351: DELETE FROM OKS_LEVEL_ELEMENTS

7347: x_return_status := 'S';
7348:
7349:
7350: ----delete lvl elements for cp
7351: DELETE FROM OKS_LEVEL_ELEMENTS
7352: WHERE cle_id IN (SELECT cp.id
7353: FROM OKC_k_LINES_B cp
7354: WHERE cp.cle_id = p_top_line_id
7355: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 7359: DELETE FROM OKS_LEVEL_ELEMENTS

7355: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7356:
7357:
7358: --------delete lvl elemets for top line
7359: DELETE FROM OKS_LEVEL_ELEMENTS
7360: WHERE cle_id = p_top_line_id;
7361:
7362:
7363: ---delete sll of cp

Line 7421: FROM oks_level_elements

7417:
7418: CURSOR l_line_BS_csr IS
7419: SELECT id, trunc(date_start) date_start,
7420: amount, TRUNC(DATE_end) date_end, object_version_number
7421: FROM oks_level_elements
7422: WHERE cle_id = p_top_line_id
7423: ORDER BY date_start;
7424:
7425: CURSOR l_cp_BS_csr IS

Line 7428: FROM oks_level_elements

7424:
7425: CURSOR l_cp_BS_csr IS
7426: SELECT id, trunc(date_start) date_start,
7427: amount
7428: FROM oks_level_elements
7429: WHERE cle_id = p_sub_line_id
7430: ORDER BY date_start;
7431:
7432:

Line 7574: DELETE FROM OKS_LEVEL_ELEMENTS

7570: END IF; ---l_bill_type = 'T'
7571:
7572:
7573: ----delete lvl elements for cp
7574: DELETE FROM OKS_LEVEL_ELEMENTS
7575: WHERE cle_id = p_sub_line_id;
7576:
7577:
7578: ----Delete sll of cp

Line 7626: FROM oks_level_elements

7622:
7623: CURSOR l_Line_BS_csr IS
7624: SELECT id, trunc(date_start) date_start,
7625: date_to_interface, date_transaction, date_end
7626: FROM oks_level_elements
7627: WHERE cle_id = p_top_line_id
7628: AND date_completed IS NOT NULL
7629: ORDER BY date_start;
7630:

Line 7874: FROM oks_level_elements

7870:
7871: CURSOR l_lvl_element_csr(l_sll_id NUMBER) IS
7872: SELECT id,date_start, date_end, date_to_interface,
7873: date_transaction , object_version_number
7874: FROM oks_level_elements
7875: WHERE rul_id = l_sll_id AND date_completed IS NULL
7876: ORDER BY date_start;
7877:
7878:

Line 8647: DELETE FROM OKS_LEVEL_ELEMENTS

8643: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8644: l_update_end_date := 'N';
8645:
8646: IF nvl(p_full_credit, 'N') = 'Y' Then
8647: DELETE FROM OKS_LEVEL_ELEMENTS
8648: WHERE date_completed IS NULL
8649: AND cle_id = p_top_line_id;
8650:
8651: RETURN;

Line 8994: FROM oks_level_elements element

8990: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
8991: SELECT id, trunc(element.date_start) date_start,
8992: amount,trunc(date_end) date_end,
8993: object_version_number,date_transaction,date_to_interface
8994: FROM oks_level_elements element
8995: WHERE cle_id = p_line_id
8996: ORDER BY date_start;
8997:
8998:

Line 10701: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements

10697: IF x_return_status <> 'S' THEN
10698: RAISE G_EXCEPTION_HALT_VALIDATION;
10699: END IF;
10700:
10701: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements
10702: IF l_sll_out_tbl.count > 0 then
10703:
10704: l_currency_code := Find_Currency_Code(
10705: p_cle_id => NULL,

Line 10774: DELETE FROM OKS_LEVEL_ELEMENTS

10770: x_return_status := 'S';
10771:
10772:
10773: --------delete lvl elemets for line
10774: DELETE FROM OKS_LEVEL_ELEMENTS
10775: WHERE rul_id IN (SELECT sll.id
10776: FROM OKS_STREAM_LEVELS_B sll
10777: WHERE sll.cle_id = p_line_id);
10778:

Line 10817: DELETE FROM OKS_LEVEL_ELEMENTS

10813: x_return_status := 'S';
10814:
10815:
10816: --------delete lvl elemets for the whole contract
10817: DELETE FROM OKS_LEVEL_ELEMENTS
10818: WHERE dnz_chr_id = p_contract_id;
10819:
10820:
10821: ---delete sll info for contract (header,line and subline)

Line 10852: FROM oks_level_elements element, oks_stream_levels_b sll

10848: Cursor l_LineSch_Csr is
10849: SELECT sll.start_date,sll.uom_code, sll.uom_per_period,
10850: element.id,element.sequence_number,element.date_start,
10851: element.date_end,element.date_completed
10852: FROM oks_level_elements element, oks_stream_levels_b sll
10853: WHERE sll.id = element.rul_id
10854: AND sll.cle_id = p_line_id
10855: ORDER BY element.date_start;
10856:

Line 10894: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .

10890:
10891: BEGIN
10892:
10893: --The procedure update the sll end date and level elements end date for a line and subline.
10894: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
10895:
10896: x_return_status := 'S';
10897: l_period_end_dt := null;
10898:

Line 10992: UPDATE oks_level_elements SET date_end = TRUNC(l_lvl_ele_tbl_in(i).date_end)

10988:
10989: FOR i IN l_lvl_ele_tbl_in.FIRST .. l_lvl_ele_tbl_in.LAST
10990: LOOP
10991:
10992: UPDATE oks_level_elements SET date_end = TRUNC(l_lvl_ele_tbl_in(i).date_end)
10993: WHERE id = l_lvl_ele_tbl_in(i).id;
10994: END LOOP;
10995: END IF; ---tbl count chk.
10996:

Line 11018: FROM oks_level_elements element, oks_stream_levels_b sll

11014:
11015: Cursor l_hdrSch_Csr Is
11016: SELECT sll.uom_code, sll.uom_per_period,
11017: element.id,element.date_start
11018: FROM oks_level_elements element, oks_stream_levels_b sll
11019: WHERE sll.id = element.rul_id
11020: AND sll.chr_id = p_chr_id
11021: ORDER BY element.date_start;
11022:

Line 11057: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .

11053:
11054: BEGIN
11055:
11056: --The procedure update the sll end date and level elements end date for a hdr schedule.
11057: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
11058:
11059:
11060:
11061: x_return_status := 'S';

Line 11103: UPDATE oks_level_elements SET date_end = TRUNC(l_lvl_ele_tbl_in(i).date_end)

11099:
11100: FOR i IN l_lvl_ele_tbl_in.FIRST .. l_lvl_ele_tbl_in.LAST
11101: LOOP
11102:
11103: UPDATE oks_level_elements SET date_end = TRUNC(l_lvl_ele_tbl_in(i).date_end)
11104: WHERE id = l_lvl_ele_tbl_in(i).id;
11105: END LOOP;
11106: END IF;
11107:

Line 11183: FROM oks_level_elements element

11179:
11180: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS
11181: SELECT id, trunc(date_start) date_start,
11182: amount, trunc(date_end) date_end
11183: FROM oks_level_elements element
11184: WHERE cle_id = p_cp_id
11185: ORDER by date_start;
11186:
11187: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;

Line 11309: FROM oks_level_elements

11305:
11306: CURSOR l_cp_BS_csr IS
11307: SELECT id, trunc(date_start) date_start,
11308: date_to_interface, date_transaction, object_version_number
11309: FROM oks_level_elements
11310: WHERE cle_id = p_SubLine_id
11311: AND date_completed IS NULL
11312: ORDER BY date_start;
11313:

Line 11805: UPDATE oks_level_elements

11801: 'sll rule id = ' || l_strm_lvl_tbl_out(l_sll_index).id
11802: ||', sll end date = '|| l_sll_end_date);
11803: END IF;
11804:
11805: UPDATE oks_level_elements
11806: SET rul_id = l_strm_lvl_tbl_out(l_sll_index).id,
11807: cle_id = p_new_cp_id
11808: WHERE TRUNC(date_start) <= TRUNC(l_sll_end_date)
11809: AND TRUNC(date_start) >= TRUNC(l_strm_lvl_tbl_out(l_sll_index).start_date)

Line 11912: FROM oks_level_elements

11908:
11909: SELECT id,trunc(date_start) date_start,
11910: amount,trunc(date_end) date_end,object_version_number,
11911: date_to_interface, date_transaction,date_completed
11912: FROM oks_level_elements
11913: WHERE cle_id = p_line_id
11914: ORDER BY date_start;
11915:
11916:

Line 11919: FROM oks_level_elements

11915:
11916:
11917: CURSOR chk_subline_bs_csr(p_line_id NUMBER) IS
11918: SELECT id
11919: FROM oks_level_elements
11920: WHERE cle_id = p_line_id;
11921:
11922: CURSOR l_amt_csr(p_line_id NUMBER) IS
11923:

Line 11925: FROM oks_level_elements

11921:
11922: CURSOR l_amt_csr(p_line_id NUMBER) IS
11923:
11924: SELECT SUM(NVL(amount,0)) tot_amt
11925: FROM oks_level_elements
11926: WHERE cle_id = p_line_id;
11927:
11928: Cursor l_line_amt_csr (p_id in number) IS
11929: Select line.price_negotiated

Line 12630: UPDATE OKS_LEVEL_ELEMENTS

12626:
12627: FOR l_index IN l_top_bs_tbl.FIRST .. l_top_bs_tbl.LAST
12628: LOOP
12629:
12630: UPDATE OKS_LEVEL_ELEMENTS
12631: SET amount = l_top_bs_tbl(l_index).amount
12632: WHERE id = l_top_bs_tbl(l_index).id;
12633:
12634: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 12757: FROM oks_level_elements

12753: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
12754:
12755: SELECT id,trunc(date_start) date_start,
12756: amount,trunc(date_end) date_end,date_completed
12757: FROM oks_level_elements
12758: WHERE cle_id = p_line_id
12759: ORDER BY date_start;
12760:
12761: l_line_BS_rec l_line_BS_csr%ROWTYPE;

Line 12804: UPDATE OKS_LEVEL_ELEMENTS

12800:
12801: p_old_cp_bs_tbl(l_index).amount := p_old_cp_bs_tbl(l_index).amount - x_new_cp_bs_tbl(l_index).amount;
12802: x_new_cp_bs_tbl(l_index).date_completed := sysdate;
12803:
12804: UPDATE OKS_LEVEL_ELEMENTS
12805: SET amount = p_old_cp_bs_tbl(l_index).amount
12806: WHERE id = p_old_cp_bs_tbl(l_index).id;
12807:
12808: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 12859: FROM oks_level_elements

12855:
12856: CURSOR l_line_BS_csr(l_top_line_id Number) IS
12857: SELECT id, trunc(date_start) date_start,
12858: amount, TRUNC(DATE_end) date_end, object_version_number
12859: FROM oks_level_elements
12860: WHERE cle_id = l_top_line_id
12861: ORDER BY date_start;
12862:
12863: -- to get the sub-line details.

Line 12867: FROM oks_level_elements

12863: -- to get the sub-line details.
12864: CURSOR l_cp_BS_csr IS
12865: SELECT id, trunc(date_start) date_start,
12866: amount
12867: FROM oks_level_elements
12868: WHERE cle_id = p_cle_id
12869: ORDER BY date_start;
12870:
12871: -- to get the billing schedule of the sub-line on which the status changes action is taken.

Line 12887: -- on billing form (table- oks_level_elements, column- amount)

12883:
12884:
12885: -- 18-JAN-2006-maanand-Fixed Enhancement#4930700
12886: -- CURSOR to check if price_negotiated of topline equals to total SLL amount for this topline
12887: -- on billing form (table- oks_level_elements, column- amount)
12888:
12889: CURSOR csr_CheckBillSllAmount_PN (p_top_line_id number) IS
12890: SELECT 1
12891: FROM okc_k_lines_b

Line 12893: AND price_negotiated = (select sum(amount) from oks_level_elements ole1

12889: CURSOR csr_CheckBillSllAmount_PN (p_top_line_id number) IS
12890: SELECT 1
12891: FROM okc_k_lines_b
12892: WHERE id = p_top_line_id
12893: AND price_negotiated = (select sum(amount) from oks_level_elements ole1
12894: where ole1.parent_cle_id = p_top_line_id
12895: and ole1.object_version_number = ( select max(object_version_number)
12896: from oks_level_elements ole2
12897: where ole2.parent_cle_id = p_top_line_id

Line 12896: from oks_level_elements ole2

12892: WHERE id = p_top_line_id
12893: AND price_negotiated = (select sum(amount) from oks_level_elements ole1
12894: where ole1.parent_cle_id = p_top_line_id
12895: and ole1.object_version_number = ( select max(object_version_number)
12896: from oks_level_elements ole2
12897: where ole2.parent_cle_id = p_top_line_id
12898: )
12899: );
12900: