APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_FEE_ASSIGNMENTS

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

583: IF l_return_status <> 'S' THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_assignments...');
588: update lns_fee_assignments
589: set end_date_active = P_PAYOFF_DATE
590: where loan_id = l_loan_id
591: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);

Line 588: update lns_fee_assignments

584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_assignments...');
588: update lns_fee_assignments
589: set end_date_active = P_PAYOFF_DATE
590: where loan_id = l_loan_id
591: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);
592: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');

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

588: update lns_fee_assignments
589: set end_date_active = P_PAYOFF_DATE
590: where loan_id = l_loan_id
591: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);
592: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');
593:
594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_schedules...');
595: update lns_fee_schedules
596: set billed_flag = 'Y'

Line 3871: from lns_fee_assignments

3867:
3868: /* check to start billing for 0-th installment */
3869: CURSOR do_billing_cur(C_LOAN_ID number, C_PHASE varchar2) IS
3870: select nvl(count(1),0)
3871: from lns_fee_assignments
3872: where begin_installment_number = 0
3873: and end_installment_number = 0
3874: and end_date_active is null
3875: and (billing_option = 'ORIGINATION'