APPS.OKL_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_B

Line 1840: from okl_txd_assets_b txdb,

1836: -- Cursor modified to include validation at asset line
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

Line 1854: from okl_txd_assets_b txdb,

1850:
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,

Line 1881: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;

1877:
1878: i number;
1879: l_curr_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1880: l_curr_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
1881: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;
1882: --Bug# 3621663
1883: l_Multi_GAAP_YN varchar2(1);
1884: l_rep_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1885: l_rep_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;

Line 3057: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;

3053:
3054: l_curr_pdt_rec curr_pdt_csr%ROWTYPE;
3055: l_delete_flag VARCHAR(1) := 'N';
3056:
3057: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;
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,

Line 3061: from okl_txd_assets_b txdb,

3057: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;
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

Line 7426: FROM OKL_TXD_ASSETS_B

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
7426: FROM OKL_TXD_ASSETS_B
7427: WHERE tal_id = p_tal_id;
7428:
7429: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
7430:

Line 7429: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;

7425: SELECT ID
7426: FROM OKL_TXD_ASSETS_B
7427: WHERE tal_id = p_tal_id;
7428:
7429: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
7430:
7431: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
7432: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
7433: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 8275: FROM OKL_TXD_ASSETS_B

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
8275: FROM OKL_TXD_ASSETS_B
8276: WHERE tal_id = p_tal_id;
8277:
8278: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
8279:

Line 8278: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;

8274: SELECT ID
8275: FROM OKL_TXD_ASSETS_B
8276: WHERE tal_id = p_tal_id;
8277:
8278: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
8279:
8280: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
8281: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
8282: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;