DBA Data[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_PAY_SUM_V

Line 509: LNS_PAY_SUM_V sum,

505: head.OBJECT_VERSION_NUMBER,
506: head.loan_id,
507: head.loan_number
508: from
509: LNS_PAY_SUM_V sum,
510: LNS_LOAN_HEADERS head
511: where
512: head.loan_id = nvl(P_LOAN_ID, head.loan_id) and
513: head.loan_id = sum.loan_id and

Line 3563: 'LNS_PAY_SUM_V PAY_SUM, ' ||

3559: 'FROM lns_loan_headers_all_vl loan, ' ||
3560: 'hz_parties party, ' ||
3561: 'fnd_territories_tl terr, ' ||
3562: 'hr_all_organization_units_tl org, ' ||
3563: 'LNS_PAY_SUM_V PAY_SUM, ' ||
3564: 'LNS_PAY_SUM_YEARLY_V PAY_SUM_YEARLY, ' ||
3565: 'LNS_PAY_SUM_OVERDUE_V PAY_SUM_OVERDUE, ' ||
3566: 'lns_amortization_scheds am, ' ||
3567: 'hz_locations loc, ' ||