DBA Data[Home] [Help]

APPS.LNS_APPL_ENGINE_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 776: ar_payment_schedules ps,

772: party.party_name,
773: ra.AMOUNT_APPLIED,
774: nvl(ra.amount_applied_from, ra.AMOUNT_APPLIED)
775: from ar_receivable_applications ra,
776: ar_payment_schedules ps,
777: hz_cust_accounts cust,
778: hz_parties party
779: where
780: ra.APPLIED_PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID and

Line 1328: ar_payment_schedules ps,

1324: from
1325: lns_participants par,
1326: lns_loan_headers loan,
1327: hz_cust_accounts cust,
1328: ar_payment_schedules ps,
1329: lns_system_options sys,
1330: gl_sets_of_books books,
1331: hz_parties party,
1332: AR_SYSTEM_PARAMETERS arsys,

Line 1534: ar_payment_schedules ps,

1530: loan.EXCHANGE_RATE
1531: from
1532: lns_amortization_scheds am,
1533: lns_loan_headers loan,
1534: ar_payment_schedules ps,
1535: hz_parties party,
1536: lns_loan_products_vl product,
1537: lns_lookups look
1538: where

Line 1577: ar_payment_schedules ps,

1573: loan.EXCHANGE_RATE
1574: from
1575: lns_amortization_scheds am,
1576: lns_loan_headers loan,
1577: ar_payment_schedules ps,
1578: hz_parties party,
1579: lns_loan_products_vl product,
1580: lns_lookups look
1581: where

Line 1879: ar_payment_schedules ps

1875: product.loan_product_id = loan.product_id and
1876: ((select count(1)
1877: from
1878: lns_amortization_scheds am,
1879: ar_payment_schedules ps
1880: where
1881: am.loan_id = loan.loan_id and
1882: (am.reversed_flag is null or am.reversed_flag = 'N') and
1883: ps.customer_trx_id in (am.principal_trx_id, am.interest_trx_id, am.fee_trx_id) and