APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_FEE_SCHEDULES

Line 485: -- Bug # 4728114 - Insert Fee Record in lns_fee_schedules for Origination Fees

481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'THe feeType is '||l_fee_assignment_rec.FEE_TYPE||' and loan_id is '||l_fee_assignment_rec.LOAN_ID);
482: END IF;
483:
484: /*
485: -- Bug # 4728114 - Insert Fee Record in lns_fee_schedules for Origination Fees
486: IF( ('EVENT_ORIGINATION'=l_fee_assignment_rec.FEE_TYPE) OR ('EVENT_CONVERSION'=l_fee_assignment_rec.FEE_TYPE) ) THEN
487:
488: l_loan_id := l_fee_assignment_rec.LOAN_ID ;
489:

Line 1440: EXISTS ( SELECT NULL FROM LNS_FEE_SCHEDULES sched

1436: AND nvl(trunc(fasgn.END_DATE_ACTIVE), trunc(SYSDATE)) >= trunc(SYSDATE)
1437: AND nvl(trunc(fasgn.START_DATE_ACTIVE), trunc(SYSDATE)) <= trunc(SYSDATE)
1438: )
1439: AND
1440: EXISTS ( SELECT NULL FROM LNS_FEE_SCHEDULES sched
1441: WHERE (sched.loan_id = c_loan_id OR sched.DISB_HEADER_ID = c_disb_header_id)
1442: AND sched.fee_id = c_fee_id
1443: AND sched.ACTIVE_FLAG = 'Y'
1444: AND sched.BILLED_FLAG = 'N'