[Home] [Help]
184: ,p_term IN VARCHAR2) RETURN NUMBER IS
185:
186: CURSOR l_pph_csr(cp_khr_id NUMBER, cp_kle_id NUMBER, cp_term VARCHAR2) IS
187: SELECT id FROM
188: OKL_PARTY_PAYMENT_HDR
189: WHERE dnz_chr_id = cp_khr_id
190: AND NVL(cle_id, -99) = cp_kle_id
191: AND passthru_term = cp_term;
192:
738: ppd.processing_fee_basis,
739: ppd.processing_fee_fixed_amount,
740: ppd.processing_fee_percent
741: --ppd.processing_fee_formula
742: FROM okl_party_payment_hdr pph,
743: okl_party_payment_dtls ppd,
744: okc_k_headers_b khr,
745: po_vendor_sites pvs
746: WHERE pph.id = cp_pph_id
1591: ,okl_bpd_ar_invoices_v arv
1592: ,okl_trx_ar_invoices_v tai
1593: ,okl_txl_ar_inv_lns_v til
1594: ,okl_txd_ar_ln_dtls_b tld
1595: ,okl_party_payment_hdr pph
1596: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1597: AND khr.id = kle.dnz_chr_id
1598: AND kle.id = til.kle_id
1599: AND til.id = tld.til_id_details
1666: ,okl_bpd_ar_invoices_v arv
1667: ,okl_trx_ar_invoices_v tai
1668: ,okl_txl_ar_inv_lns_v til
1669: ,okl_txd_ar_ln_dtls_b tld
1670: ,okl_party_payment_hdr pph
1671: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1672: AND khr.id = sub_kle.dnz_chr_id
1673: AND sub_kle.chr_id is null
1674: --rkuttiya commented for R12 B Billing Architecture
1755: ,okl_bpd_ar_invoices_v arv
1756: ,okl_trx_ar_invoices_v tai
1757: ,okl_txl_ar_inv_lns_v til
1758: ,okl_txd_ar_ln_dtls_b tld
1759: ,okl_party_payment_hdr pph
1760: ,ar_payment_schedules_all aps
1761: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1762: AND khr.id = kle.dnz_chr_id
1763: AND kle.id = til.kle_id
1834: ,okl_bpd_ar_invoices_v arv
1835: ,okl_trx_ar_invoices_v tai
1836: ,okl_txl_ar_inv_lns_v til
1837: ,okl_txd_ar_ln_dtls_b tld
1838: ,okl_party_payment_hdr pph
1839: ,ar_payment_schedules_all aps
1840: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1841: AND khr.id = sub_kle.dnz_chr_id
1842: AND sub_kle.chr_id is null
1928: ,okl_txl_ar_inv_lns_v til
1929: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
1930: ,okl_txd_ar_ln_dtls_b tld
1931: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
1932: ,okl_party_payment_hdr pph
1933: ,ar_payment_schedules_all aps
1934: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1935: AND khr.id = kle.dnz_chr_id
1936: AND kle.id = til.kle_id
2007: ,okl_txl_ar_inv_lns_v til
2008: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
2009: ,okl_txd_ar_ln_dtls_b tld
2010: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
2011: ,okl_party_payment_hdr pph
2012: ,ar_payment_schedules_all aps
2013: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
2014: AND khr.id = sub_kle.dnz_chr_id
2015: AND sub_kle.chr_id is null
2096: --added for evergreen change request 08_nov_2005
2097: okc_line_styles_b lse,
2098: okc_statuses_b khs,
2099: okc_statuses_b kls,
2100: okl_party_payment_hdr pph
2101: WHERE trunc(ste.stream_element_date) >=
2102: trunc(NVL (p_from_date, ste.stream_element_date))
2103: AND trunc(ste.stream_element_date) <=
2104: trunc((NVL (p_to_date, SYSDATE) ))
2170: --added for evergreen change request 08_nov_2005
2171: okc_line_styles_b lse,
2172: okc_statuses_b khs,
2173: okc_statuses_b kls,
2174: okl_party_payment_hdr pph
2175: WHERE trunc(ste.stream_element_date) >=
2176: trunc(NVL (p_from_date, ste.stream_element_date))
2177: AND trunc(ste.stream_element_date) <=
2178: trunc((NVL (p_to_date, SYSDATE) ))
2248: hr_operating_units hou,
2249: okc_k_lines_b kle,
2250: --added for evergreen change request 08_nov_2005
2251: okc_line_styles_b lse,
2252: okl_party_payment_hdr pph
2253: WHERE oklh.id = okch.id
2254: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)
2255: AND okch.scs_code IN ('LEASE', 'LOAN')
2256: AND okch.sts_code = 'EVERGREEN'