[Home] [Help]
229: ,p_term IN VARCHAR2) RETURN NUMBER IS
230:
231: CURSOR l_pph_csr(cp_khr_id NUMBER, cp_kle_id NUMBER, cp_term VARCHAR2) IS
232: SELECT id FROM
233: OKL_PARTY_PAYMENT_HDR
234: WHERE dnz_chr_id = cp_khr_id
235: AND NVL(cle_id, -99) = cp_kle_id
236: AND passthru_term = cp_term;
237:
783: ppd.processing_fee_basis,
784: ppd.processing_fee_fixed_amount,
785: ppd.processing_fee_percent
786: --ppd.processing_fee_formula
787: FROM okl_party_payment_hdr pph,
788: okl_party_payment_dtls ppd,
789: okc_k_headers_b khr,
790: po_vendor_sites pvs
791: WHERE pph.id = cp_pph_id
1641: ,okl_bpd_ar_invoices_v arv
1642: ,okl_trx_ar_invoices_v tai
1643: ,okl_txl_ar_inv_lns_v til
1644: ,okl_txd_ar_ln_dtls_b tld
1645: ,okl_party_payment_hdr pph
1646: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1647: AND khr.id = kle.dnz_chr_id
1648: AND kle.id = til.kle_id
1649: AND til.id = tld.til_id_details
1716: ,okl_bpd_ar_invoices_v arv
1717: ,okl_trx_ar_invoices_v tai
1718: ,okl_txl_ar_inv_lns_v til
1719: ,okl_txd_ar_ln_dtls_b tld
1720: ,okl_party_payment_hdr pph
1721: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1722: AND khr.id = sub_kle.dnz_chr_id
1723: AND sub_kle.chr_id is null
1724: --rkuttiya commented for R12 B Billing Architecture
1806: ,okl_bpd_ar_invoices_v arv
1807: ,okl_trx_ar_invoices_v tai
1808: ,okl_txl_ar_inv_lns_v til
1809: ,okl_txd_ar_ln_dtls_b tld
1810: ,okl_party_payment_hdr pph
1811: ,ar_payment_schedules_all aps
1812: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1813: AND khr.id = kle.dnz_chr_id
1814: AND kle.id = til.kle_id
1887: ,okl_bpd_ar_invoices_v arv
1888: ,okl_trx_ar_invoices_v tai
1889: ,okl_txl_ar_inv_lns_v til
1890: ,okl_txd_ar_ln_dtls_b tld
1891: ,okl_party_payment_hdr pph
1892: ,ar_payment_schedules_all aps
1893: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1894: AND khr.id = sub_kle.dnz_chr_id
1895: AND sub_kle.chr_id is null
1981: ,okl_txl_ar_inv_lns_v til
1982: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
1983: ,okl_txd_ar_ln_dtls_b tld
1984: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
1985: ,okl_party_payment_hdr pph
1986: ,ar_payment_schedules_all aps
1987: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1988: AND khr.id = kle.dnz_chr_id
1989: AND kle.id = til.kle_id
2060: ,okl_txl_ar_inv_lns_v til
2061: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
2062: ,okl_txd_ar_ln_dtls_b tld
2063: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
2064: ,okl_party_payment_hdr pph
2065: ,ar_payment_schedules_all aps
2066: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
2067: AND khr.id = sub_kle.dnz_chr_id
2068: AND sub_kle.chr_id is null
2149: --added for evergreen change request 08_nov_2005
2150: okc_line_styles_b lse,
2151: okc_statuses_b khs,
2152: okc_statuses_b kls,
2153: okl_party_payment_hdr pph
2154: WHERE trunc(ste.stream_element_date) >=
2155: trunc(NVL (p_from_date, ste.stream_element_date))
2156: AND trunc(ste.stream_element_date) <=
2157: trunc((NVL (p_to_date, SYSDATE) ))
2223: --added for evergreen change request 08_nov_2005
2224: okc_line_styles_b lse,
2225: okc_statuses_b khs,
2226: okc_statuses_b kls,
2227: okl_party_payment_hdr pph
2228: WHERE trunc(ste.stream_element_date) >=
2229: trunc(NVL (p_from_date, ste.stream_element_date))
2230: AND trunc(ste.stream_element_date) <=
2231: trunc((NVL (p_to_date, SYSDATE) ))
2301: hr_operating_units hou,
2302: okc_k_lines_b kle,
2303: --added for evergreen change request 08_nov_2005
2304: okc_line_styles_b lse,
2305: okl_party_payment_hdr pph
2306: WHERE oklh.id = okch.id
2307: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)
2308: AND okch.scs_code IN ('LEASE', 'LOAN')
2309: AND okch.sts_code = 'EVERGREEN'