APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_ASSETS_B

Line 785: FROM OKL_ASSETS_B

781: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
782:
783: CURSOR c_get_assets IS
784: SELECT id
785: FROM OKL_ASSETS_B
786: WHERE PARENT_OBJECT_ID = p_quote_id
787: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
788:
789: CURSOR c_get_fees IS

Line 1631: FROM OKL_ASSETS_B

1627: x_fee_id NUMBER;
1628:
1629: CURSOR c_get_assets IS
1630: SELECT id
1631: FROM OKL_ASSETS_B
1632: WHERE PARENT_OBJECT_ID = p_source_quote_id
1633: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1634:
1635: CURSOR c_get_config_fees IS

Line 2231: (SELECT id FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);

2227: -- cashflow
2228:
2229: -- ASS
2230: DELETE FROM okl_assets_tl WHERE id IN
2231: (SELECT id FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);
2232: DELETE FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2233:
2234: -- FEE
2235: DELETE FROM okl_fees_tl WHERE id IN

Line 2232: DELETE FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;

2228:
2229: -- ASS
2230: DELETE FROM okl_assets_tl WHERE id IN
2231: (SELECT id FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);
2232: DELETE FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2233:
2234: -- FEE
2235: DELETE FROM okl_fees_tl WHERE id IN
2236: (SELECT id FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);

Line 3107: lp_source_table := 'OKL_ASSETS_B';

3103:
3104: lx_error_tbl OKL_API.ERROR_TBL_TYPE;
3105: BEGIN
3106: IF(p_source_object_code = 'QUOTED_ASSET') THEN
3107: lp_source_table := 'OKL_ASSETS_B';
3108: ELSIF(p_source_object_code = 'LEASE_QUOTE') THEN
3109: lp_source_table := 'OKL_LEASE_QUOTES_B';
3110: END IF;
3111: i := 1;

Line 3187: FROM OKL_ASSETS_B

3183:
3184:
3185: CURSOR get_asset_count(lp_quote_id NUMBER) IS
3186: SELECT COUNT(*)
3187: FROM OKL_ASSETS_B
3188: where parent_object_code = 'LEASEQUOTE'
3189: AND parent_object_id = lp_quote_id;
3190:
3191: CURSOR c_get_quote_assets(p_parent_object_id NUMBER) IS

Line 3193: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

3189: AND parent_object_id = lp_quote_id;
3190:
3191: CURSOR c_get_quote_assets(p_parent_object_id NUMBER) IS
3192: select OAB.id
3193: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
3194: where OAB.PARENT_OBJECT_ID = OLQ.ID
3195: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
3196: AND OLQ.ID= p_parent_object_id;
3197:

Line 3515: FROM okl_assets_b

3511: WHERE id = cp_quote_id;
3512:
3513: CURSOR l_get_assets(cp_quote_id IN NUMBER) IS
3514: SELECT id, asset_number
3515: FROM okl_assets_b
3516: WHERE parent_object_id = cp_quote_id
3517: AND parent_object_code = 'LEASEQUOTE';
3518:
3519: CURSOR l_get_asset_tax_amount(cp_quote_id IN NUMBER, cp_asset_number IN VARCHAR2) IS

Line 3546: FROM okl_line_relationships_b lre, okl_fees_b fee, okl_assets_b asset

3542:
3543: CURSOR l_fee_assets_details(cp_quote_id IN NUMBER) IS
3544: SELECT lre.id, lre.object_version_number, asset.asset_number,
3545: lre.source_line_id, lre.related_line_id
3546: FROM okl_line_relationships_b lre, okl_fees_b fee, okl_assets_b asset
3547: WHERE fee.parent_object_id = cp_quote_id
3548: AND fee.parent_object_code = 'LEASEQUOTE'
3549: AND fee.fee_purpose_code = 'SALESTAX'
3550: AND lre.related_line_id = fee.id