APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_FEES_B

Line 54: FROM okl_fees_b

50: WHERE id = cp_quote_id;
51:
52: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
53: SELECT id
54: FROM okl_fees_b
55: WHERE parent_object_id = cp_quote_id
56: AND parent_object_code = 'LEASEQUOTE'
57: AND fee_purpose_code = 'SALESTAX';
58:

Line 801: FROM OKL_FEES_B

797: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
798:
799: CURSOR c_get_fees IS
800: SELECT id
801: FROM OKL_FEES_B
802: WHERE PARENT_OBJECT_ID = p_quote_id
803: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
804:
805: CURSOR c_get_services IS

Line 1663: FROM OKL_FEES_B

1659: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1660:
1661: CURSOR c_get_config_fees IS
1662: SELECT id
1663: FROM OKL_FEES_B
1664: WHERE PARENT_OBJECT_ID = p_source_quote_id
1665: AND PARENT_OBJECT_CODE = 'LEASEQUOTE'
1666: AND FEE_TYPE IN ('FINANCED', 'CAPITALIZED', 'ROLLOVER');
1667: -- AND FEE_PURPOSE_CODE IS NULL; Bug#9708535

Line 1764: FROM OKL_FEES_B

1760: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1761:
1762: CURSOR c_get_nonconfig_fees IS
1763: SELECT id
1764: FROM OKL_FEES_B
1765: WHERE PARENT_OBJECT_ID = p_source_quote_id
1766: AND PARENT_OBJECT_CODE = 'LEASEQUOTE'
1767: AND FEE_TYPE NOT IN ('FINANCED', 'CAPITALIZED', 'ROLLOVER');
1768:

Line 2292: (SELECT id FROM okl_fees_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);
2293: DELETE FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2294:
2295: -- SVC
2296: DELETE FROM okl_services_tl WHERE id IN

Line 2293: DELETE FROM okl_fees_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);
2293: DELETE FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2294:
2295: -- SVC
2296: DELETE FROM okl_services_tl WHERE id IN
2297: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);

Line 3631: FROM okl_fees_b

3627: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3628:
3629: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
3630: SELECT '1'
3631: FROM okl_fees_b
3632: WHERE parent_object_id = cp_quote_id
3633: AND parent_object_code = 'LEASEQUOTE'
3634: AND fee_purpose_code = 'SALESTAX';
3635:

Line 3639: FROM okl_fees_b

3635:
3636: CURSOR l_fee_details(cp_quote_id IN NUMBER) IS
3637: SELECT id, object_version_number
3638: , effective_from, supplier_id --sechawla 5-aug-2010 9962315 : added
3639: FROM okl_fees_b
3640: WHERE parent_object_id = cp_quote_id
3641: AND parent_object_code = 'LEASEQUOTE'
3642: AND fee_purpose_code = 'SALESTAX';
3643:

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