APPS.LNS_SUBMIT_FOR_APPROVAL_PUB dependencies on LNS_ASSET_ASSIGNMENTS

Line 512: lns_asset_assignments a

508: OR loan.collateral_percent <=
509: (SELECT
510: nvl(sum(a.pledged_amount)/loan.requested_amount,0) * 100
511: FROM
512: lns_asset_assignments a
513: WHERE
514: a.loan_id = loan.loan_id
515: and ( a.end_date_active is null OR trunc(a.end_date_active) >= trunc(loan.loan_maturity_date) )
516: )

Line 589: lns_asset_assignments a

585: OR exists
586: (SELECT
587: 1
588: FROM
589: lns_asset_assignments a
590: WHERE
591: a.loan_id = l.loan_id
592: )
593: );