APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_FEE_ASSIGNMENTS

Line 580: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_assignments...');

576: IF l_return_status <> 'S' THEN
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_assignments...');
581: update lns_fee_assignments
582: set end_date_active = P_PAYOFF_DATE
583: where loan_id = l_loan_id
584: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);

Line 581: update lns_fee_assignments

577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_assignments...');
581: update lns_fee_assignments
582: set end_date_active = P_PAYOFF_DATE
583: where loan_id = l_loan_id
584: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);
585: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');

Line 585: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');

581: update lns_fee_assignments
582: set end_date_active = P_PAYOFF_DATE
583: where loan_id = l_loan_id
584: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);
585: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');
586:
587: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_schedules...');
588: update lns_fee_schedules
589: set billed_flag = 'Y'

Line 3550: from lns_fee_assignments

3546:
3547: /* check to start billing for 0-th installment */
3548: CURSOR do_billing_cur(P_LOAN_ID number) IS
3549: select nvl(count(1),0)
3550: from lns_fee_assignments
3551: where begin_installment_number = 0
3552: and end_installment_number = 0
3553: and end_date_active is null
3554: and billing_option = 'ORIGINATION'

Line 3556: -- Bug#6961250, The loanId is NULL if for the disbFees in lns_fee_assignments.

3552: and end_installment_number = 0
3553: and end_date_active is null
3554: and billing_option = 'ORIGINATION'
3555: and (loan_id = P_LOAN_ID
3556: -- Bug#6961250, The loanId is NULL if for the disbFees in lns_fee_assignments.
3557: -- So to check any existed 0th installment fees for a loan, also check existed fees for disb_header_id.
3558: OR disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = P_LOAN_ID)
3559: );
3560: /* get statement after its billed */