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 2503: ----if l_cp_sll_out_tbl.count > 0 then insert lines into oks_level_elements_v

2499: ||', l_cp_sll_out_tbl count = '|| l_cp_sll_out_tbl.count ||')');
2500: END IF;
2501:
2502: -------------errorout_ad('SLL Record FOR SUBLINE = ' || TO_CHAR(l_cp_sll_out_tbl.count));
2503: ----if l_cp_sll_out_tbl.count > 0 then insert lines into oks_level_elements_v
2504: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2505: RAISE G_EXCEPTION_HALT_VALIDATION;
2506: END IF;
2507:

Line 2583: FROM oks_level_elements element, oks_stream_levels_b sll

2579: element.sequence_number, element.date_transaction,
2580: element.date_start, element.date_to_interface,
2581: element.date_completed, element.amount,element.date_end,
2582: element.rul_id
2583: FROM oks_level_elements element, oks_stream_levels_b sll
2584: WHERE sll.id = element.rul_id
2585: AND sll.cle_id = p_cle_id
2586: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2587:

Line 2594: FROM oks_level_elements element, oks_stream_levels_b sll

2590: element.sequence_number, element.date_transaction,
2591: element.date_start, element.date_to_interface,
2592: element.date_completed, element.amount, element.date_end,
2593: element.rul_id
2594: FROM oks_level_elements element, oks_stream_levels_b sll
2595: WHERE sll.id = element.rul_id
2596: AND sll.chr_id = p_chr_id
2597: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2598:

Line 2686: FROM oks_level_elements where rul_id = p_sllid

2682:
2683:
2684: CURSOR l_element_csr(p_sllid Number) IS
2685: SELECT id ,date_start,amount,date_end
2686: FROM oks_level_elements where rul_id = p_sllid
2687: ORDER BY to_number(sequence_number);
2688:
2689:
2690: ----- Bug 5047257 Start

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

2688:
2689:
2690: ----- Bug 5047257 Start
2691: Cursor l_element_count(p_sll_id in number, last_start_date in Date) is
2692: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line
2693: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2694: and a.date_start <= last_start_date
2695: and Line.cle_id = a.cle_id
2696: and Line.billing_schedule_type in ('T','E');

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

2689:
2690: ----- Bug 5047257 Start
2691: Cursor l_element_count(p_sll_id in number, last_start_date in Date) is
2692: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line
2693: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2694: and a.date_start <= last_start_date
2695: and Line.cle_id = a.cle_id
2696: and Line.billing_schedule_type in ('T','E');
2697: ----- Bug 5047257 End

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

2696: and Line.billing_schedule_type in ('T','E');
2697: ----- Bug 5047257 End
2698:
2699: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2700: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2701: oks_stream_levels_b sll1,
2702: oks_stream_levels_b sll2
2703: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2704: and a.date_start <= last_start_date

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

2699: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2700: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2701: oks_stream_levels_b sll1,
2702: oks_stream_levels_b sll2
2703: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2704: and a.date_start <= last_start_date
2705: and a.rul_id = sll1.id
2706: and sll1.sequence_no = sll2.sequence_no
2707: and sll2.id = p_sll_id

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

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

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

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

Line 3000: FROM oks_level_elements

2996: IS
2997:
2998: CURSOR l_tot_amt_csr IS
2999: SELECT nvl(SUM(amount),0) tot_amt
3000: FROM oks_level_elements
3001: WHERE cle_id = p_line_id;
3002:
3003: l_adjusted_amount number;
3004: l_round_level_amt number;

Line 4556: DELETE FROM OKS_LEVEL_ELEMENTS

4552: ---it deletes the level elementwhich are not billed for the given line id.
4553:
4554: x_return_status := 'S';
4555:
4556: DELETE FROM OKS_LEVEL_ELEMENTS
4557: WHERE date_Completed is NULL
4558: AND cle_id = p_cle_id;
4559:
4560:

Line 4587: DELETE FROM OKS_LEVEL_ELEMENTS

4583:
4584: x_return_status := 'S';
4585: ---delete hdr , top line, cp lvl elements together
4586:
4587: DELETE FROM OKS_LEVEL_ELEMENTS
4588: WHERE rul_id IN
4589: (SELECT sll.id
4590: FROM OKS_STREAM_LEVELS_B sll
4591: WHERE sll.dnz_chr_id = p_hdr_id);

Line 5031: FROM OKS_LEVEL_ELEMENTS

5027:
5028: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5029:
5030: SELECT NVL(SUM(AMOUNT),0) INTO l_sll_amt
5031: FROM OKS_LEVEL_ELEMENTS
5032: WHERE rul_id = p_Sll_id;
5033:
5034: RETURN l_sll_amt;
5035:

Line 5090: FROM oks_level_elements

5086: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
5087: SELECT id, trunc(date_start) date_start,
5088: amount,trunc(date_end) date_end,object_version_number,
5089: date_to_interface, date_transaction
5090: FROM oks_level_elements
5091: WHERE cle_id = p_line_id
5092: ORDER BY date_start;
5093:
5094:

Line 6765: DELETE FROM OKS_LEVEL_ELEMENTS

6761: x_return_status := 'S';
6762:
6763:
6764: ----delete lvl elements for cp
6765: DELETE FROM OKS_LEVEL_ELEMENTS
6766: WHERE cle_id IN (SELECT id
6767: FROM OKC_K_LINES_B cp
6768: WHERE cp.cle_id = p_top_line_id
6769: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 6774: DELETE FROM OKS_LEVEL_ELEMENTS

6770:
6771:
6772:
6773: --------delete lvl elemets for top line
6774: DELETE FROM OKS_LEVEL_ELEMENTS
6775: WHERE cle_id = p_top_line_id;
6776:
6777:
6778: ---delete sll of all cp

Line 6817: FROM oks_level_elements element

6813:
6814: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS
6815: SELECT id, trunc(date_start) date_start,
6816: amount, trunc(date_end) date_end
6817: FROM oks_level_elements element
6818: WHERE cle_id = p_cp_id
6819: ORDER by date_start;
6820:
6821: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;

Line 7139: DELETE FROM OKS_LEVEL_ELEMENTS

7135: x_return_status := 'S';
7136:
7137:
7138: ----delete lvl elements for cp
7139: DELETE FROM OKS_LEVEL_ELEMENTS
7140: WHERE cle_id IN (SELECT cp.id
7141: FROM OKC_k_LINES_B cp
7142: WHERE cp.cle_id = p_top_line_id
7143: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 7147: DELETE FROM OKS_LEVEL_ELEMENTS

7143: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7144:
7145:
7146: --------delete lvl elemets for top line
7147: DELETE FROM OKS_LEVEL_ELEMENTS
7148: WHERE cle_id = p_top_line_id;
7149:
7150:
7151: ---delete sll of cp

Line 7209: FROM oks_level_elements

7205:
7206: CURSOR l_line_BS_csr IS
7207: SELECT id, trunc(date_start) date_start,
7208: amount, TRUNC(DATE_end) date_end, object_version_number
7209: FROM oks_level_elements
7210: WHERE cle_id = p_top_line_id
7211: ORDER BY date_start;
7212:
7213: CURSOR l_cp_BS_csr IS

Line 7216: FROM oks_level_elements

7212:
7213: CURSOR l_cp_BS_csr IS
7214: SELECT id, trunc(date_start) date_start,
7215: amount
7216: FROM oks_level_elements
7217: WHERE cle_id = p_sub_line_id
7218: ORDER BY date_start;
7219:
7220:

Line 7361: DELETE FROM OKS_LEVEL_ELEMENTS

7357: END IF; ---l_bill_type = 'T'
7358:
7359:
7360: ----delete lvl elements for cp
7361: DELETE FROM OKS_LEVEL_ELEMENTS
7362: WHERE cle_id = p_sub_line_id;
7363:
7364:
7365: ----Delete sll of cp

Line 7413: FROM oks_level_elements

7409:
7410: CURSOR l_Line_BS_csr IS
7411: SELECT id, trunc(date_start) date_start,
7412: date_to_interface, date_transaction, date_end
7413: FROM oks_level_elements
7414: WHERE cle_id = p_top_line_id
7415: AND date_completed IS NOT NULL
7416: ORDER BY date_start;
7417:

Line 7661: FROM oks_level_elements

7657:
7658: CURSOR l_lvl_element_csr(l_sll_id NUMBER) IS
7659: SELECT id,date_start, date_end, date_to_interface,
7660: date_transaction , object_version_number
7661: FROM oks_level_elements
7662: WHERE rul_id = l_sll_id AND date_completed IS NULL
7663: ORDER BY date_start;
7664:
7665:

Line 8434: DELETE FROM OKS_LEVEL_ELEMENTS

8430: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8431: l_update_end_date := 'N';
8432:
8433: IF nvl(p_full_credit, 'N') = 'Y' Then
8434: DELETE FROM OKS_LEVEL_ELEMENTS
8435: WHERE date_completed IS NULL
8436: AND cle_id = p_top_line_id;
8437:
8438: RETURN;

Line 8781: FROM oks_level_elements element

8777: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
8778: SELECT id, trunc(element.date_start) date_start,
8779: amount,trunc(date_end) date_end,
8780: object_version_number,date_transaction,date_to_interface
8781: FROM oks_level_elements element
8782: WHERE cle_id = p_line_id
8783: ORDER BY date_start;
8784:
8785:

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

10454: IF x_return_status <> 'S' THEN
10455: RAISE G_EXCEPTION_HALT_VALIDATION;
10456: END IF;
10457:
10458: ----if l_sll_out_tbl.count > 0 then insert lines into oks_level_elements
10459: IF l_sll_out_tbl.count > 0 then
10460:
10461: l_currency_code := Find_Currency_Code(
10462: p_cle_id => NULL,

Line 10531: DELETE FROM OKS_LEVEL_ELEMENTS

10527: x_return_status := 'S';
10528:
10529:
10530: --------delete lvl elemets for line
10531: DELETE FROM OKS_LEVEL_ELEMENTS
10532: WHERE rul_id IN (SELECT sll.id
10533: FROM OKS_STREAM_LEVELS_B sll
10534: WHERE sll.cle_id = p_line_id);
10535:

Line 10574: DELETE FROM OKS_LEVEL_ELEMENTS

10570: x_return_status := 'S';
10571:
10572:
10573: --------delete lvl elemets for the whole contract
10574: DELETE FROM OKS_LEVEL_ELEMENTS
10575: WHERE dnz_chr_id = p_contract_id;
10576:
10577:
10578: ---delete sll info for contract (header,line and subline)

Line 10609: FROM oks_level_elements element, oks_stream_levels_b sll

10605: Cursor l_LineSch_Csr is
10606: SELECT sll.start_date,sll.uom_code, sll.uom_per_period,
10607: element.id,element.sequence_number,element.date_start,
10608: element.date_end,element.date_completed
10609: FROM oks_level_elements element, oks_stream_levels_b sll
10610: WHERE sll.id = element.rul_id
10611: AND sll.cle_id = p_line_id
10612: ORDER BY element.date_start;
10613:

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

10647:
10648: BEGIN
10649:
10650: --The procedure update the sll end date and level elements end date for a line and subline.
10651: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
10652:
10653: x_return_status := 'S';
10654: l_period_end_dt := null;
10655:

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

10745:
10746: FOR i IN l_lvl_ele_tbl_in.FIRST .. l_lvl_ele_tbl_in.LAST
10747: LOOP
10748:
10749: UPDATE oks_level_elements SET date_end = TRUNC(l_lvl_ele_tbl_in(i).date_end)
10750: WHERE id = l_lvl_ele_tbl_in(i).id;
10751: END LOOP;
10752: END IF; ---tbl count chk.
10753:

Line 10775: FROM oks_level_elements element, oks_stream_levels_b sll

10771:
10772: Cursor l_hdrSch_Csr Is
10773: SELECT sll.uom_code, sll.uom_per_period,
10774: element.id,element.date_start
10775: FROM oks_level_elements element, oks_stream_levels_b sll
10776: WHERE sll.id = element.rul_id
10777: AND sll.chr_id = p_chr_id
10778: ORDER BY element.date_start;
10779:

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

10810:
10811: BEGIN
10812:
10813: --The procedure update the sll end date and level elements end date for a hdr schedule.
10814: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
10815:
10816:
10817:
10818: x_return_status := 'S';

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

10856:
10857: FOR i IN l_lvl_ele_tbl_in.FIRST .. l_lvl_ele_tbl_in.LAST
10858: LOOP
10859:
10860: UPDATE oks_level_elements SET date_end = TRUNC(l_lvl_ele_tbl_in(i).date_end)
10861: WHERE id = l_lvl_ele_tbl_in(i).id;
10862: END LOOP;
10863: END IF;
10864:

Line 10940: FROM oks_level_elements element

10936:
10937: CURSOR l_cp_BS_csr(p_cp_id NUMBER) IS
10938: SELECT id, trunc(date_start) date_start,
10939: amount, trunc(date_end) date_end
10940: FROM oks_level_elements element
10941: WHERE cle_id = p_cp_id
10942: ORDER by date_start;
10943:
10944: l_cp_BS_rec l_cp_BS_csr%ROWTYPE;

Line 11066: FROM oks_level_elements

11062:
11063: CURSOR l_cp_BS_csr IS
11064: SELECT id, trunc(date_start) date_start,
11065: date_to_interface, date_transaction, object_version_number
11066: FROM oks_level_elements
11067: WHERE cle_id = p_SubLine_id
11068: AND date_completed IS NULL
11069: ORDER BY date_start;
11070:

Line 11562: UPDATE oks_level_elements

11558: 'sll rule id = ' || l_strm_lvl_tbl_out(l_sll_index).id
11559: ||', sll end date = '|| l_sll_end_date);
11560: END IF;
11561:
11562: UPDATE oks_level_elements
11563: SET rul_id = l_strm_lvl_tbl_out(l_sll_index).id,
11564: cle_id = p_new_cp_id
11565: WHERE TRUNC(date_start) <= TRUNC(l_sll_end_date)
11566: AND TRUNC(date_start) >= TRUNC(l_strm_lvl_tbl_out(l_sll_index).start_date)

Line 11669: FROM oks_level_elements

11665:
11666: SELECT id,trunc(date_start) date_start,
11667: amount,trunc(date_end) date_end,object_version_number,
11668: date_to_interface, date_transaction,date_completed
11669: FROM oks_level_elements
11670: WHERE cle_id = p_line_id
11671: ORDER BY date_start;
11672:
11673:

Line 11676: FROM oks_level_elements

11672:
11673:
11674: CURSOR chk_subline_bs_csr(p_line_id NUMBER) IS
11675: SELECT id
11676: FROM oks_level_elements
11677: WHERE cle_id = p_line_id;
11678:
11679: CURSOR l_amt_csr(p_line_id NUMBER) IS
11680:

Line 11682: FROM oks_level_elements

11678:
11679: CURSOR l_amt_csr(p_line_id NUMBER) IS
11680:
11681: SELECT SUM(NVL(amount,0)) tot_amt
11682: FROM oks_level_elements
11683: WHERE cle_id = p_line_id;
11684:
11685: Cursor l_line_amt_csr (p_id in number) IS
11686: Select line.price_negotiated

Line 12364: UPDATE OKS_LEVEL_ELEMENTS

12360:
12361: FOR l_index IN l_top_bs_tbl.FIRST .. l_top_bs_tbl.LAST
12362: LOOP
12363:
12364: UPDATE OKS_LEVEL_ELEMENTS
12365: SET amount = l_top_bs_tbl(l_index).amount
12366: WHERE id = l_top_bs_tbl(l_index).id;
12367:
12368: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 12491: FROM oks_level_elements

12487: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
12488:
12489: SELECT id,trunc(date_start) date_start,
12490: amount,trunc(date_end) date_end,date_completed
12491: FROM oks_level_elements
12492: WHERE cle_id = p_line_id
12493: ORDER BY date_start;
12494:
12495: l_line_BS_rec l_line_BS_csr%ROWTYPE;

Line 12538: UPDATE OKS_LEVEL_ELEMENTS

12534:
12535: p_old_cp_bs_tbl(l_index).amount := p_old_cp_bs_tbl(l_index).amount - x_new_cp_bs_tbl(l_index).amount;
12536: x_new_cp_bs_tbl(l_index).date_completed := sysdate;
12537:
12538: UPDATE OKS_LEVEL_ELEMENTS
12539: SET amount = p_old_cp_bs_tbl(l_index).amount
12540: WHERE id = p_old_cp_bs_tbl(l_index).id;
12541:
12542: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 12593: FROM oks_level_elements

12589:
12590: CURSOR l_line_BS_csr(l_top_line_id Number) IS
12591: SELECT id, trunc(date_start) date_start,
12592: amount, TRUNC(DATE_end) date_end, object_version_number
12593: FROM oks_level_elements
12594: WHERE cle_id = l_top_line_id
12595: ORDER BY date_start;
12596:
12597: -- to get the sub-line details.

Line 12601: FROM oks_level_elements

12597: -- to get the sub-line details.
12598: CURSOR l_cp_BS_csr IS
12599: SELECT id, trunc(date_start) date_start,
12600: amount
12601: FROM oks_level_elements
12602: WHERE cle_id = p_cle_id
12603: ORDER BY date_start;
12604:
12605: -- to get the billing schedule of the sub-line on which the status changes action is taken.

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

12617:
12618:
12619: -- 18-JAN-2006-maanand-Fixed Enhancement#4930700
12620: -- CURSOR to check if price_negotiated of topline equals to total SLL amount for this topline
12621: -- on billing form (table- oks_level_elements, column- amount)
12622:
12623: CURSOR csr_CheckBillSllAmount_PN (p_top_line_id number) IS
12624: SELECT 1
12625: FROM okc_k_lines_b

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

12623: CURSOR csr_CheckBillSllAmount_PN (p_top_line_id number) IS
12624: SELECT 1
12625: FROM okc_k_lines_b
12626: WHERE id = p_top_line_id
12627: AND price_negotiated = (select sum(amount) from oks_level_elements ole1
12628: where ole1.parent_cle_id = p_top_line_id
12629: and ole1.object_version_number = ( select max(object_version_number)
12630: from oks_level_elements ole2
12631: where ole2.parent_cle_id = p_top_line_id

Line 12630: from oks_level_elements ole2

12626: WHERE id = p_top_line_id
12627: AND price_negotiated = (select sum(amount) from oks_level_elements ole1
12628: where ole1.parent_cle_id = p_top_line_id
12629: and ole1.object_version_number = ( select max(object_version_number)
12630: from oks_level_elements ole2
12631: where ole2.parent_cle_id = p_top_line_id
12632: )
12633: );
12634: