[Home] [Help]
799: -- Get all the asset, service and fee lines attached to the contract
800: -- These lines may or may not have payments associated with them
801: CURSOR l_okcklines_csr(cp_chr_id IN NUMBER) IS
802: SELECT cle.id, cle.lse_id, lse.lty_code
803: FROM okc_k_lines_b cle, okc_line_styles_b lse
804: WHERE cle.lse_id = lse.id
805: AND cle.sts_code IN ('BOOKED', 'TERMINATED')
806: AND chr_id = cp_chr_id;
807:
842: -- Modified the cursor to get assets for any given line type.
843: -- Get the assets associated with the given line type
844: CURSOR l_lineassets_csr(cp_line_id IN NUMBER, cp_line_type_code IN VARCHAR2) IS
845: SELECT cim.object1_id1, cle.id
846: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
847: WHERE cle.lse_id = lse.id
848: AND lse.lty_code = cp_line_type_code
849: AND cim.cle_id = cle.id
850: AND cle.cle_id = cp_line_id;
2141: -- Modified the cursor to obtain booked assets with the given line type
2142: -- Get all the booked assets associated with the given line type
2143: CURSOR l_lineassets_csr(cp_line_id IN NUMBER, cp_line_type_code IN VARCHAR2) IS
2144: SELECT cim.object1_id1, cle.id
2145: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
2146: WHERE cle.lse_id = lse.id
2147: AND lse.lty_code = cp_line_type_code
2148: AND cim.cle_id = cle.id
2149: AND cle.cle_id = cp_line_id
2163: -- Modified the cursor to obtain financial assets with the given line type
2164: -- Get the financial asset associated with a given line type asset line (subline)
2165: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS
2166: SELECT cim.object1_id1
2167: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
2168: WHERE cle.lse_id = lse.id
2169: AND lse.lty_code = cp_line_type
2170: AND cim.cle_id = cle.id
2171: AND cle.id = cp_fee_serviced_asset_line_id;