APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LINE_RELATIONSHIPS_B

Line 1490: FROM okl_line_relationships_b olrb

1486: --Get the assets details linked with fee lines
1487: CURSOR c_fee_srv_asset_dtls(lp_fee_srv_id OKL_FEES_B.ID%TYPE) IS
1488: SELECT olrb.SOURCE_LINE_ID,
1489: olrb.amount
1490: FROM okl_line_relationships_b olrb
1491: WHERE olrb.RELATED_LINE_ID = lp_fee_srv_id
1492: AND olrb.RELATED_LINE_TYPE = p_line_type
1493: AND olrb.SOURCE_LINE_TYPE= 'ASSET';
1494:

Line 2444: FROM okl_line_relationships_b olrb

2440: -- Logic: Cursor to fetch the Origination Income details for only the INCOME Fees
2441: CURSOR get_orig_inc_amt_csr(p_inc_fee_id NUMBER)
2442: IS
2443: SELECT SUM(NVL(olrb.origination_income,0)) origination_income
2444: FROM okl_line_relationships_b olrb
2445: WHERE olrb.RELATED_LINE_ID = p_inc_fee_id
2446: AND olrb.RELATED_LINE_TYPE = 'INCOME'
2447: AND olrb.SOURCE_LINE_TYPE= 'ASSET';
2448: BEGIN