DBA Data[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_FEES_ALL

Line 10698: FROM LNS_AMORTIZATION_SCHEDS scheds,lns_amortization_lines lines, lns_fees_all fee, lns_fee_schedules feeSchd

10694:
10695: -- At present Reversing only SubmitForApproval Fees
10696: CURSOR c_billed_submitAppFee(c_amortization_id NUMBER) IS
10697: SELECT lines.fee_schedule_id, feeSchd.object_version_number
10698: FROM LNS_AMORTIZATION_SCHEDS scheds,lns_amortization_lines lines, lns_fees_all fee, lns_fee_schedules feeSchd
10699: WHERE scheds.amortization_schedule_id = lines.amortization_schedule_id
10700: AND scheds.amortization_schedule_id = C_AMORTIZATION_ID
10701: AND lines.line_type = 'FEE'
10702: AND fee.fee_id = lines.fee_id