APPS.LNS_OCM_ADP_PUB dependencies on LNS_ASSET_ASSIGNMENTS

Line 652: from lns_asset_assignments laa

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

Line 895: 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)) )

891: FUNCTION total_assets_pledged_amt (x_resultout OUT NOCOPY VARCHAR2,
892: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
893:
894: CURSOR party_pledged_assets(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
895: 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)) )
896: ,0) ), CURRENCY_CODE
897: FROM LNS_ASSETS LnsAssets
898: WHERE asset_owner_id IN (
899: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

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

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