DBA Data[Home] [Help]

APPS.LNS_APPL_ENGINE_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 739: ar_payment_schedules psa,

735: party.party_name,
736: ra.AMOUNT_APPLIED,
737: nvl(ra.amount_applied_from, ra.AMOUNT_APPLIED)
738: from ar_receivable_applications ra,
739: ar_payment_schedules psa,
740: hz_cust_accounts cust,
741: hz_parties party
742: where
743: ra.APPLIED_PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID and

Line 1275: ar_payment_schedules psa,

1271: from
1272: lns_participants par,
1273: lns_loan_headers loan,
1274: hz_cust_accounts cust,
1275: ar_payment_schedules psa,
1276: lns_system_options sys,
1277: gl_sets_of_books books,
1278: hz_parties party,
1279: AR_SYSTEM_PARAMETERS arsys

Line 1464: ar_payment_schedules psa,

1460: loan.EXCHANGE_RATE
1461: from
1462: lns_amortization_scheds am,
1463: lns_loan_headers loan,
1464: ar_payment_schedules psa,
1465: hz_parties party,
1466: lns_loan_products_vl product,
1467: lns_lookups look
1468: where

Line 1507: ar_payment_schedules psa,

1503: loan.EXCHANGE_RATE
1504: from
1505: lns_amortization_scheds am,
1506: lns_loan_headers loan,
1507: ar_payment_schedules psa,
1508: hz_parties party,
1509: lns_loan_products_vl product,
1510: lns_lookups look
1511: where

Line 1803: ar_payment_schedules psa

1799: product.loan_product_id = loan.product_id and
1800: ((select count(1)
1801: from
1802: lns_amortization_scheds am,
1803: ar_payment_schedules psa
1804: where
1805: am.loan_id = loan.loan_id and
1806: (am.reversed_flag is null or am.reversed_flag = 'N') and
1807: psa.customer_trx_id in (am.principal_trx_id, am.interest_trx_id, am.fee_trx_id) and