DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_STRM_TYPE_B

Line 443: okl_strm_type_b sty_ln_pmt,

439: okl_trx_ar_invoices_b tai,
440: ar_payment_schedules_all aps,
441: ar_receivable_applications_all raa,
442: ar_cash_receipts_all cra,
443: okl_strm_type_b sty_ln_pmt,
444: ar_distributions_all ad
445: WHERE tai.trx_status_code = 'PROCESSED'
446: AND tai.khr_id = p_contract_id
447: AND tld.khr_id = p_contract_id

Line 475: okl_strm_type_b sty_ln_pmt

471: okl_trx_ar_invoices_b tai,
472: ar_payment_schedules_all aps,
473: ar_receivable_applications_all raa,
474: ar_cash_receipts_all cra,
475: okl_strm_type_b sty_ln_pmt
476: WHERE tai.trx_status_code = 'PROCESSED'
477: AND tai.khr_id = p_contract_id
478: AND tld.khr_id = p_contract_id
479: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 509: okl_strm_type_b sty_ln_pmt,

505: okl_trx_ar_invoices_b tai,
506: ar_payment_schedules_all aps,
507: ar_receivable_applications_all raa,
508: ra_customer_trx_all cm,
509: okl_strm_type_b sty_ln_pmt,
510: ar_distributions_all ad
511: WHERE tai.trx_status_code = 'PROCESSED'
512: AND tai.khr_id = p_contract_id
513: AND tld.khr_id = p_contract_id

Line 541: okl_strm_type_b sty_ln_pmt

537: okl_trx_ar_invoices_b tai,
538: ar_payment_schedules_all aps,
539: ar_receivable_applications_all raa,
540: ra_customer_trx_all cm,
541: okl_strm_type_b sty_ln_pmt
542: WHERE tai.trx_status_code = 'PROCESSED'
543: AND tai.khr_id = p_contract_id
544: AND tld.khr_id = p_contract_id
545: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 574: okl_strm_type_b sty,

570: okl_txl_ar_inv_lns_b til,
571: okl_trx_ar_invoices_b tai,
572: ar_payment_schedules_all aps,
573: ar_adjustments_all adj,
574: okl_strm_type_b sty,
575: ar_distributions_all ad
576: WHERE tai.trx_status_code = 'PROCESSED'
577: AND tai.khr_id = p_contract_id
578: AND tld.khr_id = p_contract_id

Line 609: okl_strm_type_b sty

605: okl_trx_ar_invoices_b tai,
606: ar_payment_schedules_all aps,
607: ar_receivable_applications_all raa,
608: ar_cash_receipts_all cra,
609: okl_strm_type_b sty
610: WHERE tai.trx_status_code = 'PROCESSED'
611: AND tai.khr_id = p_contract_id
612: AND tld.khr_id = p_contract_id
613: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 637: okl_strm_type_b sty

633: okl_trx_ar_invoices_b tai,
634: ar_payment_schedules_all aps,
635: ar_receivable_applications_all raa,
636: ra_customer_trx_all cm,
637: okl_strm_type_b sty
638: WHERE tai.trx_status_code = 'PROCESSED'
639: AND tai.khr_id = p_contract_id
640: AND tld.khr_id = p_contract_id
641: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 664: okl_strm_type_b sty

660: okl_txl_ar_inv_lns_b til,
661: okl_trx_ar_invoices_b tai,
662: ar_payment_schedules_all aps,
663: ar_adjustments_all adj,
664: okl_strm_type_b sty
665: WHERE tai.trx_status_code = 'PROCESSED'
666: AND tai.khr_id = p_contract_id
667: AND tld.khr_id = p_contract_id
668: AND ractrl.customer_trx_id = aps.customer_trx_id