APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 1513: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

1509: BEGIN
1510: SELECT NVL(SUM(ADJ.VALUE), 0)
1511: INTO l_down_payment_amount
1512: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1513: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1514: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'DOWN_PAYMENT'
1515: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1516: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1517: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 1553: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

1549: BEGIN
1550: SELECT SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) SUBSIDY_AMOUNT
1551: INTO l_subsidy_amount
1552: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1553: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1554: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1555: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1556: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1557: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 1594: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

1590: BEGIN
1591: SELECT NVL(SUM(ADJ.VALUE), 0)
1592: INTO l_trade_in_amount
1593: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1594: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1595: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'TRADEIN'
1596: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1597: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1598: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 1631: OKL_LEASE_QUOTES_B QUOTE, OKL_COST_ADJUSTMENTS_B ADJ

1627:
1628: CURSOR cAssetNumber IS
1629: SELECT ASSET.ASSET_NUMBER
1630: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1631: OKL_LEASE_QUOTES_B QUOTE, OKL_COST_ADJUSTMENTS_B ADJ
1632: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'TRADEIN'
1633: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1634: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1635: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 2672: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

2668: -- added for bug 6596860 --
2669: CURSOR l_adj_sum_csr(p_lease_app_id IN NUMBER) IS
2670: SELECT NVL(SUM(VALUE),0 )
2671: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2672: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
2673: WHERE ADJ.PARENT_OBJECT_CODE = 'ASSET'
2674: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
2675: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
2676: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 2777: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

2773: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2774: SELECT NVL(SUM(ADJ.VALUE), 0)
2775: INTO ln_down_payment_amount
2776: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2777: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
2778: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE IN ('DOWN_PAYMENT', 'TRADEIN')
2779: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2780: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
2781: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID