APPS.OKL_CREDIT_PUB dependencies on OKL_K_LINES_FULL_V

Line 1868: from OKL_K_LINES_FULL_V a

1864:
1865: CURSOR c (p_contract_id NUMBER)
1866: IS
1867: select 'X'
1868: from OKL_K_LINES_FULL_V a
1869: where a.dnz_chr_id = p_contract_id
1870: and a.CREDIT_NATURE = 'NEW'
1871: ;
1872:

Line 2464: l_amount OKL_K_LINES_FULL_V.AMOUNT%type;

2460: IS
2461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2462: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
2463: l_currency_code okc_k_headers_b.currency_code%TYPE;
2464: l_amount OKL_K_LINES_FULL_V.AMOUNT%type;
2465:
2466: cursor c_old_curr
2467: is
2468: select khr.currency_code

Line 2476: from OKL_K_LINES_FULL_V a

2472:
2473: CURSOR c_limit_amt
2474: IS
2475: select nvl(sum(nvl(a.amount,0)),0)
2476: from OKL_K_LINES_FULL_V a
2477: where a.dnz_chr_id = p_chrv_rec.id
2478: ;
2479:
2480: BEGIN

Line 5701: from OKL_K_LINES_FULL_V a

5697:
5698: CURSOR c (p_contract_id NUMBER)
5699: IS
5700: select nvl(sum(a.amount),0)
5701: from OKL_K_LINES_FULL_V a
5702: where a.dnz_chr_id = p_contract_id
5703: and a.CREDIT_NATURE = 'NEW'
5704: and nvl(a.start_date,sysdate) <= sysdate
5705: ;

Line 5746: from OKL_K_LINES_FULL_V a

5742:
5743: CURSOR c (p_contract_id NUMBER)
5744: IS
5745: select nvl(sum(a.amount),0)
5746: from OKL_K_LINES_FULL_V a
5747: where a.dnz_chr_id = p_contract_id
5748: and a.CREDIT_NATURE = 'ADD'
5749: and nvl(a.start_date,sysdate) <= sysdate
5750: ;

Line 5792: from OKL_K_LINES_FULL_V a

5788:
5789: CURSOR c (p_contract_id NUMBER)
5790: IS
5791: select nvl(sum(a.amount),0)
5792: from OKL_K_LINES_FULL_V a
5793: where a.dnz_chr_id = p_contract_id
5794: and a.CREDIT_NATURE = 'REDUCE'
5795: and nvl(a.start_date,sysdate) <= sysdate
5796: ;