APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_ASSETS_B

Line 1805: okl_txl_assets_b txlb,

1801: cursor l_txd_csr (p_book_type_code in varchar2,
1802: p_chr_id in number) is
1803: select txdb.id
1804: from okl_txd_assets_b txdb,
1805: okl_txl_assets_b txlb,
1806: okc_k_lines_b cleb,
1807: okc_line_styles_b lseb
1808: where txdb.tax_book = p_book_type_code
1809: and txdb.tal_id = txlb.id

Line 2983: okl_txl_assets_b txlb,

2979: cursor l_txd_csr (p_book_type_code in varchar2,
2980: p_chr_id in number) is
2981: select txdb.id
2982: from okl_txd_assets_b txdb,
2983: okl_txl_assets_b txlb,
2984: okc_k_lines_b cleb,
2985: okc_line_styles_b lseb
2986: where txdb.tax_book = p_book_type_code
2987: and txdb.tal_id = txlb.id

Line 3056: FROM OKL_TXL_ASSETS_B

3052:
3053: --Added by dpsingh for LE Uptake
3054: CURSOR get_con_line_ids_csr(p_chr_id1 NUMBER) IS
3055: SELECT DISTINCT TAS_ID
3056: FROM OKL_TXL_ASSETS_B
3057: WHERE KLE_ID IN
3058: (SELECT OKC.ID
3059: FROM OKC_K_LINES_B OKC,
3060: OKC_LINE_STYLES_B OKC_ST

Line 7315: FROM OKL_TXL_ASSETS_B

7311: --cursor to find out if any transactions hanging off the line to be deleted
7312: CURSOR l_get_txl_crs (p_kle_id IN NUMBER) is
7313: SELECT tas_id,
7314: id
7315: FROM OKL_TXL_ASSETS_B
7316: WHERE kle_id = p_kle_id;
7317:
7318: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
7319: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

Line 7318: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;

7314: id
7315: FROM OKL_TXL_ASSETS_B
7316: WHERE kle_id = p_kle_id;
7317:
7318: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
7319: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
7320:
7321: --cursor to get the transaction detail record if it exists
7322: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is

Line 7319: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

7315: FROM OKL_TXL_ASSETS_B
7316: WHERE kle_id = p_kle_id;
7317:
7318: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
7319: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
7320:
7321: --cursor to get the transaction detail record if it exists
7322: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is
7323: SELECT ID

Line 8164: FROM OKL_TXL_ASSETS_B

8160: --cursor to find out if any transactions hanging off the line to be deleted
8161: CURSOR l_get_txl_crs (p_kle_id IN NUMBER) is
8162: SELECT tas_id,
8163: id
8164: FROM OKL_TXL_ASSETS_B
8165: WHERE kle_id = p_kle_id;
8166:
8167: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
8168: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

Line 8167: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;

8163: id
8164: FROM OKL_TXL_ASSETS_B
8165: WHERE kle_id = p_kle_id;
8166:
8167: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
8168: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
8169:
8170: --cursor to get the transaction detail record if it exists
8171: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is

Line 8168: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;

8164: FROM OKL_TXL_ASSETS_B
8165: WHERE kle_id = p_kle_id;
8166:
8167: l_tas_id OKL_TXL_ASSETS_B.TAS_ID%TYPE;
8168: l_txl_id OKL_TXL_ASSETS_B.ID%TYPE;
8169:
8170: --cursor to get the transaction detail record if it exists
8171: CURSOR l_get_txd_crs (p_tal_id IN NUMBER) is
8172: SELECT ID