APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 1075: FROM OKL_TXL_QUOTE_LINES_B

1071: CURSOR get_qte_asset_details_csr(c_quote_id NUMBER) IS
1072: SELECT KLE_ID, -- STY_ID,
1073: SUM(AMOUNT) AMOUNT
1074: --, QLT_CODE
1075: FROM OKL_TXL_QUOTE_LINES_B
1076: WHERE QTE_ID = c_quote_id
1077: AND QLT_CODE IN ('AMBCOC','AMCTUR','AMCTOC') -- qualify as CO lines
1078: GROUP BY KLE_ID, STY_ID, QLT_CODE
1079: ORDER BY KLE_ID;

Line 1097: FROM OKL_TXL_QUOTE_LINES_B

1093: -- get the quoted assets
1094: CURSOR get_qte_assets_csr(c_quote_id NUMBER) IS
1095: SELECT KLE_ID,
1096: 0 AMOUNT
1097: FROM OKL_TXL_QUOTE_LINES_B
1098: WHERE QTE_ID = c_quote_id
1099: AND QLT_CODE IN ('AMCFIA');
1100:
1101: -- Bug# 7009075 - Added - Start