APPS.OKL_CREDIT_PUB dependencies on OKC_K_LINES_B

Line 1622: OKC_K_LINES_B cln

1618: CURSOR c_amount_check1 (p_contract_id NUMBER)
1619: IS
1620: select 1
1621: from OKL_K_LINES kln,
1622: OKC_K_LINES_B cln
1623: where kln.id = cln.id
1624: and cln.dnz_chr_id = p_contract_id
1625: and kln.amount < 0
1626: ;

Line 1633: OKC_K_LINES_B cln

1629: CURSOR c_amount_check2 (p_contract_id NUMBER)
1630: IS
1631: select 1
1632: from OKL_K_LINES kln,
1633: OKC_K_LINES_B cln
1634: where kln.id = cln.id
1635: and cln.dnz_chr_id = p_contract_id
1636: and kln.amount = 0
1637: ;

Line 1644: OKC_K_LINES_B cln

1640: CURSOR c_not_exists (p_contract_id NUMBER)
1641: IS
1642: select 'X'
1643: from OKL_K_LINES kln,
1644: OKC_K_LINES_B cln
1645: where kln.id = cln.id
1646: and cln.dnz_chr_id = p_contract_id
1647: and kln.CREDIT_NATURE = 'NEW'
1648: ;

Line 1655: OKC_K_LINES_B cln

1651: CURSOR c_dup (p_contract_id NUMBER)
1652: IS
1653: select cln.dnz_chr_id
1654: from OKL_K_LINES kln,
1655: OKC_K_LINES_B cln
1656: where kln.id = cln.id
1657: and cln.dnz_chr_id = p_contract_id
1658: and kln.CREDIT_NATURE = 'NEW'
1659: group by cln.dnz_chr_id

Line 1668: okc_k_lines_b cln

1664: CURSOR c_date_check1 (p_chr_id NUMBER)
1665: IS
1666: SELECT 1
1667: FROM okc_k_headers_b chr,
1668: okc_k_lines_b cln
1669: WHERE chr.id = cln.dnz_chr_id
1670: AND chr.start_date IS NOT NULL
1671: AND trunc(cln.start_date) < trunc(chr.start_date)
1672: AND chr.id = p_chr_id

Line 1680: okc_k_lines_b cln

1676: CURSOR c_date_check2 (p_chr_id NUMBER)
1677: IS
1678: SELECT 1
1679: FROM okc_k_headers_b chr,
1680: okc_k_lines_b cln
1681: WHERE chr.id = cln.dnz_chr_id
1682: AND chr.end_date IS NOT NULL
1683: AND trunc(cln.start_date) > trunc(chr.end_date)
1684: AND chr.id = p_chr_id

Line 2185: from OKC_K_LINES_B a

2181: CURSOR c (p_contract_id NUMBER)
2182: IS
2183: -- cklee 12-10-2003 fixed sql performance
2184: select min(start_date)
2185: from OKC_K_LINES_B a
2186: where a.dnz_chr_id = p_contract_id
2187: ;
2188:
2189: BEGIN

Line 2257: from OKC_K_LINES_B a

2253: -- 11-19-2003 cklee fixed sql performance bug
2254: CURSOR c2 (p_contract_id NUMBER)
2255: IS
2256: select max(start_date)
2257: from OKC_K_LINES_B a
2258: where a.dnz_chr_id = p_contract_id
2259: ;
2260:
2261: BEGIN