[Home] [Help]
588: CURSOR security_deposit IS
589: SELECT ste.amount amount
590: FROM okc_k_lines_b kle,
591: okc_line_styles_b lse,
592: okc_k_items ite,
593: okl_strm_type_b sty1,
594: okl_streams stm,
595: okl_strm_type_b sty2,
596: okl_strm_elements ste
790: SELECT 'Y' FROM okc_k_headers_b CHR
791: WHERE id = p_contract_id
792: AND EXISTS
793: (
794: SELECT 'x' FROM okc_k_items cim
795: WHERE cim.object1_id1 = TO_CHAR(CHR.id)
796: AND EXISTS
797: (
798: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
912: SELECT 'Y' FROM okc_k_headers_b CHR
913: WHERE id = p_contract_id
914: AND EXISTS
915: (
916: SELECT 'x' FROM okc_k_items cim
917: WHERE cim.object1_id1 = TO_CHAR(CHR.id)
918: AND EXISTS
919: (
920: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
1674: okc_k_lines_b top_cle,
1675: okc_line_styles_b top_stl,
1676: okc_k_lines_b sub_cle,
1677: okc_line_styles_b sub_stl,
1678: okc_k_items cim
1679: WHERE top_cle.lse_id = top_stl.id
1680: AND top_stl.lty_code in ('SOLD_SERVICE','FEE')
1681: AND top_cle.id = sub_cle.cle_id
1682: AND sub_cle.lse_id = sub_stl.id
1772: CURSOR l_asset_id_csr(cp_kle_id IN NUMBER) IS
1773: SELECT cim1.object1_id1
1774: FROM okc_k_lines_b cle,
1775: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1776: okc_k_items cim, /* to get the one having covered asset */
1777: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1778: okc_line_styles_b lse, /* to get free_form 1 */
1779: okc_line_styles_b lse1, /* to get FIXED_ASSET lty_code */
1780: okc_line_styles_b lse2, /* to get LINK_SERV_ASSET lty_code */
1777: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1778: okc_line_styles_b lse, /* to get free_form 1 */
1779: okc_line_styles_b lse1, /* to get FIXED_ASSET lty_code */
1780: okc_line_styles_b lse2, /* to get LINK_SERV_ASSET lty_code */
1781: okc_k_items cim1 /* to take the actual asset id */
1782: WHERE lse.id = cle.lse_id
1783: AND lse1.id = cle1.lse_id
1784: AND lse1.lty_code = 'FIXED_ASSET'
1785: AND cle.id = cle1.cle_id
1803:
1804: Note: The input for the above query would be the id of the service line.
1805: */
1806:
1807: l_asset_id okc_k_items.object1_id1%TYPE;
1808:
1809: BEGIN
1810:
1811: OPEN l_asset_id_csr(p_kle_id);