APPS.OKL_LLA_UTIL_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 1622: okl_party_payment_dtls vDtls,

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
1626: AND vHdr.CLE_ID = cle.id

Line 1679: update okl_party_payment_dtls

1675: close get_vendor_extid_csr;
1676:
1677: if t_extr_id_tbl.count > 0 then
1678: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1679: update okl_party_payment_dtls
1680: set orig_contract_line_id = t_extr_id_tbl(i)
1681: where id = t_extr_id_tbl(i)
1682: and orig_contract_line_id is null;
1683: end if;

Line 1747: okl_party_payment_dtls vDtls,

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
1751: WHERE vDtls.payment_hdr_id = vHdr.id

Line 1773: okl_party_payment_dtls vDtls,

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
1777: AND vHdr.CLE_ID = cle.id

Line 1906: update okl_party_payment_dtls

1902:
1903: -- if the upgrade is happening on the original contract or a new line is added
1904: if t_extr_id_tbl.count > 0 then
1905: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1906: update okl_party_payment_dtls
1907: set orig_contract_line_id = t_extr_id_tbl(i)
1908: where id = t_extr_id_tbl(i)
1909: and orig_contract_line_id is null;
1910: end if;

Line 1920: update okl_party_payment_dtls a

1916: close get_orig_vendor_dtls;
1917:
1918: if t_extr_id_tbl.count > 0 then
1919: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
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,

Line 1925: okl_party_payment_dtls vDtls,

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
1929: AND vHdr.PASSTHRU_TERM = 'BASE'

Line 1950: update okl_party_payment_dtls

1946:
1947: -- if a new line is added
1948: if t_extr_id_tbl.count > 0 then
1949: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1950: update okl_party_payment_dtls
1951: set orig_contract_line_id = t_extr_id_tbl(i)
1952: where id = t_extr_id_tbl(i)
1953: and orig_contract_line_id is null;
1954: end if;