APPS.LNS_OCM_ADP_PUB dependencies on LNS_ASSET_ASSIGNMENTS

Line 654: from lns_asset_assignments laa

650: x_resultout := FND_API.G_RET_STS_SUCCESS;
651: BEGIN
652:
653: SELECT (select nvl(sum(laa.pledged_amount),0)
654: from lns_asset_assignments laa
655: where laa.loan_id = loan.loan_id
656: and (laa.end_date_active is null or trunc(laa.end_date_active) > trunc(sysdate))
657: and exists (select 1 from lns_assets la where la.asset_id = laa.asset_id)) , loan.loan_currency
658: INTO l_total_coll_amount , l_loan_currency

Line 897: SELECT sum(nvl( (select sum (assign.pledged_amount) from lns_asset_assignments assign where LnsAssets.asset_id = assign.asset_id(+) and (assign.end_date_active is null or trunc(assign.end_date_active) > trunc(sysdate)) )

893: FUNCTION total_assets_pledged_amt (x_resultout OUT NOCOPY VARCHAR2,
894: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
895:
896: CURSOR party_pledged_assets(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
897: SELECT sum(nvl( (select sum (assign.pledged_amount) from lns_asset_assignments assign where LnsAssets.asset_id = assign.asset_id(+) and (assign.end_date_active is null or trunc(assign.end_date_active) > trunc(sysdate)) )
898: ,0) ), CURRENCY_CODE
899: FROM LNS_ASSETS LnsAssets
900: WHERE asset_owner_id IN (
901: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

Line 1005: SELECT sum( nvl(LnsAssets.valuation,0) - nvl( (select sum (assign.pledged_amount) from lns_asset_assignments

1001: FUNCTION total_assets_available_amt (x_resultout OUT NOCOPY VARCHAR2,
1002: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1003:
1004: CURSOR party_available_assets(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
1005: SELECT sum( nvl(LnsAssets.valuation,0) - nvl( (select sum (assign.pledged_amount) from lns_asset_assignments
1006: assign where LnsAssets.asset_id = assign.asset_id(+) and (assign.end_date_active is null or trunc(assign.end_date_active) > trunc(sysdate)) )
1007: ,0) ), CURRENCY_CODE
1008: FROM LNS_ASSETS LnsAssets
1009: WHERE asset_owner_id IN (