APPS.LNS_OCM_ADP_PUB dependencies on LNS_ASSETS

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

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

Line 789: FROM LNS_ASSETS

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

Line 814: l_asset_currency lns_assets.currency_code%TYPE ;

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

Line 897: FROM LNS_ASSETS LnsAssets

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

Line 922: l_asset_currency lns_assets.currency_code%TYPE ;

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

Line 1006: FROM LNS_ASSETS LnsAssets

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 (
1008: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1009: 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' )
1010: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )

Line 1029: l_asset_currency lns_assets.currency_code%TYPE ;

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