eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_PAY_INVOICES_DISB_PVT

Line 1: PACKAGE BODY OKL_PAY_INVOICES_DISB_PVT AS

1: PACKAGE BODY OKL_PAY_INVOICES_DISB_PVT AS
2: /* $Header: OKLRPIDB.pls 120.27.12020000.2 2012/08/07 12:18:33 bkatraga ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.RECEIVABLES';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 1678: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1674: AND pph.payout_basis = 'BILLING'
1675: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1676: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1677: --added for evergreen change request 08_nov_2005
1678: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1679: OR
1680: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1681: --added for evergreen change request 08_nov_2005
1682: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1682: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1678: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1679: OR
1680: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1681: --added for evergreen change request 08_nov_2005
1682: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1683: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
1684: AND NVL (TRUNC(p_to_date), SYSDATE+10000)
1685: UNION ALL
1686: SELECT

Line 1757: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1753: --rkuttiya R12 B Billing Architecture replaced arv.date_consolidated by arv.date_consolidated
1754: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1755: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1756: --added for evergreen change request 08_nov_2005
1757: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1758: OR
1759: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1760: --added for evergreen change request 08_nov_2005
1761: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1761: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1757: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1758: OR
1759: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1760: --added for evergreen change request 08_nov_2005
1761: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1762: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
1763: AND NVL (TRUNC(p_to_date), SYSDATE+10000);
1764: --rkuttiya R12 B Billing Architecture end changes for this cursor
1765:

Line 1781: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date

1777: NULL cnr_id
1778: ,arl.receivables_invoice_number
1779: ,tai.set_of_books_id
1780: ,arv.org_id
1781: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1782: ,arv.currency_code
1783: ,tai.khr_id
1784: ,til.kle_id
1785: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607

Line 1785: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607

1781: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1782: ,arv.currency_code
1783: ,tai.khr_id
1784: ,til.kle_id
1785: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607
1786: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id,arl.receivables_invoice_line_id) amount --21-Jan-2011 sechawla 10282607
1787: ,arl.sty_id
1788: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1789: -- ,arl.id lsm_id

Line 1786: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id,arl.receivables_invoice_line_id) amount --21-Jan-2011 sechawla 10282607

1782: ,arv.currency_code
1783: ,tai.khr_id
1784: ,til.kle_id
1785: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607
1786: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id,arl.receivables_invoice_line_id) amount --21-Jan-2011 sechawla 10282607
1787: ,arl.sty_id
1788: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1789: -- ,arl.id lsm_id
1790: ,tld.id tld_id

Line 1844: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1840: AND pph.payout_basis = 'FULL_RECEIPT'
1841: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1842: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1843: --added for evergreen change request 08_nov_2005
1844: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1845: OR
1846: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1847: --added for evergreen change request 08_nov_2005
1848: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1848: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1844: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1845: OR
1846: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1847: --added for evergreen change request 08_nov_2005
1848: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1849: AND arl.receivables_invoice_id = aps.customer_trx_id
1850: AND aps.class = 'INV'
1851: AND aps.status = 'CL'
1852: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)

Line 1860: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date

1856: NULL cnr_id
1857: ,arl.receivables_invoice_number
1858: ,tai.set_of_books_id
1859: ,arv.org_id
1860: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1861: ,arv.currency_code
1862: ,tai.khr_id
1863: ,til.kle_id
1864: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607

Line 1864: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607

1860: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1861: ,arv.currency_code
1862: ,tai.khr_id
1863: ,til.kle_id
1864: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607
1865: , okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id,arl.receivables_invoice_line_id) amount --21-Jan-2011 sechawla 10282607
1866:
1867: ,arl.sty_id
1868: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts

Line 1865: , okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id,arl.receivables_invoice_line_id) amount --21-Jan-2011 sechawla 10282607

1861: ,arv.currency_code
1862: ,tai.khr_id
1863: ,til.kle_id
1864: -- ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount --21-Jan-2011 sechawla 10282607
1865: , okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id,arl.receivables_invoice_line_id) amount --21-Jan-2011 sechawla 10282607
1866:
1867: ,arl.sty_id
1868: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1869: -- ,arl.id lsm_id

Line 1931: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1927: AND pph.payout_basis = 'FULL_RECEIPT'
1928: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1929: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1930: --added for evergreen change request 08_nov_2005
1931: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1932: OR
1933: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1934: --added for evergreen change request 08_nov_2005
1935: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1935: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1931: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1932: OR
1933: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1934: --added for evergreen change request 08_nov_2005
1935: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1936: AND arl.receivables_invoice_id = aps.customer_trx_id
1937: AND aps.class = 'INV'
1938: AND aps.status = 'CL'
1939: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)

Line 1955: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date

1951: NULL cnr_id
1952: ,arl.receivables_invoice_number
1953: ,tai.set_of_books_id
1954: ,arv.org_id
1955: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
1956: ,arv.currency_code
1957: ,tai.khr_id
1958: ,til.kle_id
1959: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

Line 1959: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

1955: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
1956: ,arv.currency_code
1957: ,tai.khr_id
1958: ,til.kle_id
1959: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount
1960: ,arl.sty_id
1961: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1962: -- ,arl.id lsm_id
1963: ,tld.id tld_id

Line 2014: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0

2010: --commented for evergreen change request 08_nov_2005
2011: --AND kle.id = pph.cle_id
2012: AND kle.dnz_chr_id = pph.dnz_chr_id
2013: AND pph.payout_basis = 'PARTIAL_RECEIPT'
2014: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
2015: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
2016: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
2017: --added for evergreen change request 08_nov_2005
2018: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

Line 2018: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2014: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
2015: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
2016: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
2017: --added for evergreen change request 08_nov_2005
2018: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2019: OR
2020: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
2021: --added for evergreen change request 08_nov_2005
2022: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 2022: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

2018: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2019: OR
2020: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
2021: --added for evergreen change request 08_nov_2005
2022: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
2023: AND arl.receivables_invoice_id = aps.customer_trx_id
2024: AND aps.class = 'INV'
2025: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
2026: AND NVL (TRUNC(p_to_date), SYSDATE+10000)

Line 2033: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date

2029: NULL cnr_id
2030: ,arl.receivables_invoice_number
2031: ,tai.set_of_books_id
2032: ,arv.org_id
2033: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
2034: ,arv.currency_code
2035: ,tai.khr_id
2036: ,til.kle_id
2037: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

Line 2037: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

2033: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
2034: ,arv.currency_code
2035: ,tai.khr_id
2036: ,til.kle_id
2037: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount
2038: ,arl.sty_id
2039: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
2040: -- ,arl.id lsm_id
2041: ,tld.id tld_id

Line 2098: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0

2094: --commented for evergreen change request 08_nov_2005
2095: --AND kle.id = pph.cle_id
2096: AND kle.dnz_chr_id = pph.dnz_chr_id
2097: AND pph.payout_basis = 'PARTIAL_RECEIPT'
2098: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
2099: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
2100: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
2101: --added for evergreen change request 08_nov_2005
2102: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

Line 2102: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2098: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
2099: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
2100: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
2101: --added for evergreen change request 08_nov_2005
2102: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2103: OR
2104: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
2105: --added for evergreen change request 08_nov_2005
2106: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 2106: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

2102: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2103: OR
2104: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
2105: --added for evergreen change request 08_nov_2005
2106: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
2107: AND arl.receivables_invoice_id = aps.customer_trx_id
2108: AND aps.class = 'INV'
2109: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
2110: AND NVL (TRUNC(p_to_date), SYSDATE+10000);

Line 2186: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2182: --commented for evergreen change request 08_nov_2005
2183: --AND kle.id = pph.cle_id
2184: AND kle.dnz_chr_id = pph.dnz_chr_id
2185: --added for evergreen change request 08_nov_2005
2186: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2187: AND pph.payout_basis = 'DUE_DATE'
2188: AND trunc(ste.stream_element_date) >= trunc(NVL(pph.passthru_start_date, ste.stream_element_date))
2189: AND trunc(ste.stream_element_date) <= trunc(kle.end_date)
2190: AND pph.passthru_term = 'BASE'

Line 2263: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2259: --commented for evergreen change request 08_nov_2005
2260: --AND kle.id = pph.cle_id
2261: AND kle.dnz_chr_id = pph.dnz_chr_id
2262: --added for evergreen change request 08_nov_2005
2263: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2264: AND pph.payout_basis = 'DUE_DATE'
2265: AND trunc(ste.stream_element_date) >= trunc(NVL(pph.passthru_start_date, ste.stream_element_date))
2266: AND trunc(ste.stream_element_date) <= trunc(kle.end_date)
2267: AND pph.passthru_term = 'BASE';

Line 2318: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id

2314: --added for evergreen change request 08_nov_2005
2315: AND kle.lse_id = lse.id
2316: AND kle.dnz_chr_id = pph.dnz_chr_id
2317: --added for evergreen change request 08_nov_2005
2318: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id
2319: --commented for evergreen change request 08_nov_2005
2320: --AND kle.id = pph.cle_id
2321: AND pph.passthru_term = 'EVERGREEN'
2322: AND pph.payout_basis = 'FORMULA';

Line 2768: END OKL_PAY_INVOICES_DISB_PVT;

2764:
2765: END credit_check;
2766:
2767:
2768: END OKL_PAY_INVOICES_DISB_PVT;