APPS.OKL_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_B

Line 1804: from okl_txd_assets_b txdb,

1800: --cursor to get multi-gaap reporting book transaction
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

Line 1822: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;

1818:
1819: i number;
1820: l_curr_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1821: l_curr_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
1822: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;
1823: --Bug# 3621663
1824: l_Multi_GAAP_YN varchar2(1);
1825: l_rep_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1826: l_rep_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;

Line 2978: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;

2974:
2975: l_curr_pdt_rec curr_pdt_csr%ROWTYPE;
2976: l_delete_flag VARCHAR(1) := 'N';
2977:
2978: l_rep_book_type okl_txd_assets_b.tax_book%TYPE;
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,

Line 2982: from okl_txd_assets_b txdb,

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

Line 7324: FROM OKL_TXD_ASSETS_B

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
7324: FROM OKL_TXD_ASSETS_B
7325: WHERE tal_id = p_tal_id;
7326:
7327: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
7328:

Line 7327: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;

7323: SELECT ID
7324: FROM OKL_TXD_ASSETS_B
7325: WHERE tal_id = p_tal_id;
7326:
7327: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
7328:
7329: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
7330: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
7331: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 8173: FROM OKL_TXD_ASSETS_B

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
8173: FROM OKL_TXD_ASSETS_B
8174: WHERE tal_id = p_tal_id;
8175:
8176: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
8177:

Line 8176: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;

8172: SELECT ID
8173: FROM OKL_TXD_ASSETS_B
8174: WHERE tal_id = p_tal_id;
8175:
8176: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
8177:
8178: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
8179: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
8180: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;