APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_ASSETS_B

Line 795: FROM OKL_ASSETS_B

791: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
792:
793: CURSOR c_get_assets IS
794: SELECT id
795: FROM OKL_ASSETS_B
796: WHERE PARENT_OBJECT_ID = p_quote_id
797: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
798:
799: CURSOR c_get_fees IS

Line 1657: FROM OKL_ASSETS_B

1653: x_fee_id NUMBER;
1654:
1655: CURSOR c_get_assets IS
1656: SELECT id
1657: FROM OKL_ASSETS_B
1658: WHERE PARENT_OBJECT_ID = p_source_quote_id
1659: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1660:
1661: CURSOR c_get_config_fees IS

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

2283: -- cashflow
2284:
2285: -- ASS
2286: DELETE FROM okl_assets_tl WHERE id IN
2287: (SELECT id FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);
2288: DELETE FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2289:
2290: -- FEE
2291: DELETE FROM okl_fees_tl WHERE id IN

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

2284:
2285: -- ASS
2286: DELETE FROM okl_assets_tl WHERE id IN
2287: (SELECT id FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);
2288: DELETE FROM okl_assets_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2289:
2290: -- FEE
2291: DELETE FROM okl_fees_tl WHERE id IN
2292: (SELECT id FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);

Line 3207: lp_source_table := 'OKL_ASSETS_B';

3203:
3204: lx_error_tbl OKL_API.ERROR_TBL_TYPE;
3205: BEGIN
3206: IF(p_source_object_code = 'QUOTED_ASSET') THEN
3207: lp_source_table := 'OKL_ASSETS_B';
3208: ELSIF(p_source_object_code = 'LEASE_QUOTE') THEN
3209: lp_source_table := 'OKL_LEASE_QUOTES_B';
3210: END IF;
3211: i := 1;

Line 3287: FROM OKL_ASSETS_B

3283:
3284:
3285: CURSOR get_asset_count(lp_quote_id NUMBER) IS
3286: SELECT COUNT(*)
3287: FROM OKL_ASSETS_B
3288: where parent_object_code = 'LEASEQUOTE'
3289: AND parent_object_id = lp_quote_id;
3290:
3291: CURSOR c_get_quote_assets(p_parent_object_id NUMBER) IS

Line 3293: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

3289: AND parent_object_id = lp_quote_id;
3290:
3291: CURSOR c_get_quote_assets(p_parent_object_id NUMBER) IS
3292: select OAB.id
3293: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
3294: where OAB.PARENT_OBJECT_ID = OLQ.ID
3295: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
3296: AND OLQ.ID= p_parent_object_id;
3297:

Line 3615: FROM okl_assets_b

3611: WHERE id = cp_quote_id;
3612:
3613: CURSOR l_get_assets(cp_quote_id IN NUMBER) IS
3614: SELECT id, asset_number
3615: FROM okl_assets_b
3616: WHERE parent_object_id = cp_quote_id
3617: AND parent_object_code = 'LEASEQUOTE';
3618:
3619: CURSOR l_get_asset_tax_amount(cp_quote_id IN NUMBER, cp_asset_number IN VARCHAR2) IS

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

3643:
3644: CURSOR l_fee_assets_details(cp_quote_id IN NUMBER) IS
3645: SELECT lre.id, lre.object_version_number, asset.asset_number,
3646: lre.source_line_id, lre.related_line_id
3647: FROM okl_line_relationships_b lre, okl_fees_b fee, okl_assets_b asset
3648: WHERE fee.parent_object_id = cp_quote_id
3649: AND fee.parent_object_code = 'LEASEQUOTE'
3650: AND fee.fee_purpose_code = 'SALESTAX'
3651: AND lre.related_line_id = fee.id