APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_ASSETS_B

Line 1841: okl_txl_assets_b txlb,

1837: /*cursor l_txd_csr (p_book_type_code in varchar2,
1838: p_chr_id in number) is
1839: select txdb.id
1840: from okl_txd_assets_b txdb,
1841: okl_txl_assets_b txlb,
1842: okc_k_lines_b cleb,
1843: okc_line_styles_b lseb
1844: where txdb.tax_book = p_book_type_code
1845: and txdb.tal_id = txlb.id

Line 1855: okl_txl_assets_b txlb,

1851: cursor l_txd_csr (p_book_type_code in varchar2,
1852: p_chr_id in number) is
1853: select txdb.id
1854: from okl_txd_assets_b txdb,
1855: okl_txl_assets_b txlb,
1856: okc_k_lines_b cleb,
1857: okc_line_styles_b lseb,
1858: okc_k_lines_b cleb_top,
1859: okl_k_lines kle_top

Line 3062: okl_txl_assets_b txlb,

3058: cursor l_txd_csr (p_book_type_code in varchar2,
3059: p_chr_id in number) is
3060: select txdb.id
3061: from okl_txd_assets_b txdb,
3062: okl_txl_assets_b txlb,
3063: okc_k_lines_b cleb,
3064: okc_line_styles_b lseb
3065: where txdb.tax_book = p_book_type_code
3066: and txdb.tal_id = txlb.id

Line 3135: FROM OKL_TXL_ASSETS_B

3131:
3132: --Added by dpsingh for LE Uptake
3133: CURSOR get_con_line_ids_csr(p_chr_id1 NUMBER) IS
3134: SELECT DISTINCT TAS_ID
3135: FROM OKL_TXL_ASSETS_B
3136: WHERE KLE_ID IN
3137: (SELECT OKC.ID
3138: FROM OKC_K_LINES_B OKC,
3139: OKC_LINE_STYLES_B OKC_ST

Line 7417: FROM OKL_TXL_ASSETS_B

7413: --cursor to find out if any transactions hanging off the line to be deleted
7414: CURSOR l_get_txl_crs (p_kle_id IN NUMBER) is
7415: SELECT tas_id,
7416: id
7417: FROM OKL_TXL_ASSETS_B
7418: WHERE kle_id = p_kle_id;
7419:
7420: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
7421: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

Line 7420: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;

7416: id
7417: FROM OKL_TXL_ASSETS_B
7418: WHERE kle_id = p_kle_id;
7419:
7420: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
7421: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
7422:
7423: --cursor to get the transaction detail record if it exists
7424: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is

Line 7421: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

7417: FROM OKL_TXL_ASSETS_B
7418: WHERE kle_id = p_kle_id;
7419:
7420: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
7421: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
7422:
7423: --cursor to get the transaction detail record if it exists
7424: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is
7425: SELECT ID

Line 8266: FROM OKL_TXL_ASSETS_B

8262: --cursor to find out if any transactions hanging off the line to be deleted
8263: CURSOR l_get_txl_crs (p_kle_id IN NUMBER) is
8264: SELECT tas_id,
8265: id
8266: FROM OKL_TXL_ASSETS_B
8267: WHERE kle_id = p_kle_id;
8268:
8269: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
8270: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

Line 8269: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;

8265: id
8266: FROM OKL_TXL_ASSETS_B
8267: WHERE kle_id = p_kle_id;
8268:
8269: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
8270: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
8271:
8272: --cursor to get the transaction detail record if it exists
8273: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is

Line 8270: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

8266: FROM OKL_TXL_ASSETS_B
8267: WHERE kle_id = p_kle_id;
8268:
8269: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
8270: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
8271:
8272: --cursor to get the transaction detail record if it exists
8273: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is
8274: SELECT ID