APPS.OKL_LLA_UTIL_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 1621: FROM okl_party_payment_hdr vHdr,

1617: AND kle.orig_contract_line_id is null;
1618:
1619: cursor get_vendor_extid_csr(p_chr_id in number) is
1620: SELECT vDtls.ID
1621: FROM okl_party_payment_hdr vHdr,
1622: okl_party_payment_dtls vDtls,
1623: okc_k_lines_b cle,
1624: okl_k_lines kle
1625: WHERE vDtls.payment_hdr_id = vHdr.id

Line 1746: FROM okl_party_payment_hdr vHdr,

1742:
1743:
1744: cursor get_vendor_extid_csr(p_chr_id in number) is
1745: SELECT vDtls.ID
1746: FROM okl_party_payment_hdr vHdr,
1747: okl_party_payment_dtls vDtls,
1748: okc_k_lines_b cle,
1749: okl_k_lines kle,
1750: okc_k_headers_all_b chr

Line 1772: FROM okl_party_payment_hdr vHdr,

1768: l_orig_chr_id number;
1769:
1770: cursor get_orig_vendor_dtls(p_orig_chr_id in number) IS
1771: SELECT vDtls.orig_contract_line_id, vDtls.vendor_id, cle.id
1772: FROM okl_party_payment_hdr vHdr,
1773: okl_party_payment_dtls vDtls,
1774: okc_k_lines_b cle,
1775: okl_k_lines kle
1776: WHERE vDtls.payment_hdr_id = vHdr.id

Line 1924: FROM okl_party_payment_hdr vHdr,

1920: update okl_party_payment_dtls a
1921: set orig_contract_line_id = t_extr_id_tbl(i)
1922: where id in (
1923: SELECT vDtls.id
1924: FROM okl_party_payment_hdr vHdr,
1925: okl_party_payment_dtls vDtls,
1926: okc_k_lines_b cle
1927: WHERE vDtls.payment_hdr_id = vHdr.id
1928: AND vHdr.CLE_ID = cle.id