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 791: FROM OKL_FEES_B

787: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
788:
789: CURSOR c_get_fees IS
790: SELECT id
791: FROM OKL_FEES_B
792: WHERE PARENT_OBJECT_ID = p_quote_id
793: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
794:
795: CURSOR c_get_services IS

Line 1637: FROM OKL_FEES_B

1633: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1634:
1635: CURSOR c_get_config_fees IS
1636: SELECT id
1637: FROM OKL_FEES_B
1638: WHERE PARENT_OBJECT_ID = p_source_quote_id
1639: AND PARENT_OBJECT_CODE = 'LEASEQUOTE'
1640: AND FEE_TYPE IN ('FINANCED', 'CAPITALIZED', 'ROLLOVER')
1641: AND FEE_PURPOSE_CODE IS NULL;

Line 1735: FROM OKL_FEES_B

1731: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1732:
1733: CURSOR c_get_nonconfig_fees IS
1734: SELECT id
1735: FROM OKL_FEES_B
1736: WHERE PARENT_OBJECT_ID = p_source_quote_id
1737: AND PARENT_OBJECT_CODE = 'LEASEQUOTE'
1738: AND FEE_TYPE NOT IN ('FINANCED', 'CAPITALIZED', 'ROLLOVER');
1739:

Line 2236: (SELECT id FROM okl_fees_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);
2237: DELETE FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2238:
2239: -- SVC
2240: DELETE FROM okl_services_tl WHERE id IN

Line 2237: DELETE FROM okl_fees_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);
2237: DELETE FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2238:
2239: -- SVC
2240: DELETE FROM okl_services_tl WHERE id IN
2241: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);

Line 3531: FROM okl_fees_b

3527: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3528:
3529: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
3530: SELECT '1'
3531: FROM okl_fees_b
3532: WHERE parent_object_id = cp_quote_id
3533: AND parent_object_code = 'LEASEQUOTE'
3534: AND fee_purpose_code = 'SALESTAX';
3535:

Line 3538: FROM okl_fees_b

3534: AND fee_purpose_code = 'SALESTAX';
3535:
3536: CURSOR l_fee_details(cp_quote_id IN NUMBER) IS
3537: SELECT id, object_version_number
3538: FROM okl_fees_b
3539: WHERE parent_object_id = cp_quote_id
3540: AND parent_object_code = 'LEASEQUOTE'
3541: AND fee_purpose_code = 'SALESTAX';
3542:

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