APPS.LNS_OCM_ADP_PUB dependencies on LNS_ASSETS

Line 657: and exists (select 1 from lns_assets la where la.asset_id = laa.asset_id)) , loan.loan_currency

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
659: FROM lns_loan_headers_all loan
660: WHERE loan.loan_id = l_cr_loan_id ;
661:

Line 791: FROM LNS_ASSETS

787: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
788:
789: CURSOR party_total_assets(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
790: SELECT sum(VALUATION), CURRENCY_CODE
791: FROM LNS_ASSETS
792: WHERE asset_owner_id IN (
793: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
794: WHERE LOAN_ID = ( select loan_id from lns_participants
795: where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID

Line 816: l_asset_currency lns_assets.currency_code%TYPE ;

812: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
813: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
814:
815: l_asset_amount NUMBER ;
816: l_asset_currency lns_assets.currency_code%TYPE ;
817: l_total_assets_amount NUMBER ;
818:
819:
820:

Line 899: FROM LNS_ASSETS LnsAssets

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
902: WHERE LOAN_ID = ( select loan_id from lns_participants
903: where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID

Line 924: l_asset_currency lns_assets.currency_code%TYPE ;

920: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
921: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
922:
923: l_asset_pledged_amt NUMBER ;
924: l_asset_currency lns_assets.currency_code%TYPE ;
925: l_total_assets_pledged_amt NUMBER ;
926:
927:
928:

Line 1008: FROM LNS_ASSETS LnsAssets

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 (
1010: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1011: WHERE LOAN_ID = ( select loan_id from lns_participants where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID and loan_participant_type = 'PRIMARY_BORROWER' )
1012: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )

Line 1031: l_asset_currency lns_assets.currency_code%TYPE ;

1027: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1028: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1029:
1030: l_asset_available_amt NUMBER ;
1031: l_asset_currency lns_assets.currency_code%TYPE ;
1032: l_total_assets_available_amt NUMBER ;
1033:
1034:
1035: