APPS.LNS_SUBMIT_FOR_APPROVAL_PUB dependencies on LNS_FEE_ASSIGNMENTS

Line 410: | in table lns_fee_assignments.

406: | PROCEDURE VALIDATE_LOAN
407: |
408: | DESCRIPTION
409: | This procedure checks whether the fee installment has any error
410: | in table lns_fee_assignments.
411: |
412: | PSEUDO CODE/LOGIC
413: |
414: | PARAMETERS

Line 447: lns_fee_assignments

443:
444: SELECT
445: count(1) into l_count
446: FROM
447: lns_fee_assignments
448: WHERE
449: loan_id = p_loan_id
450: and end_installment_number > lns_fin_utils.getnumberinstallments(p_loan_id);
451: