DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKL_TXD_QTE_ANTCPT_BILL

Line 4521: -- Business Rules : Dependent on new table okl_txd_qte_antcpt_bill

4517: -- Start of comments
4518: --
4519: -- Function Name : get_anticipated_bill
4520: -- Description : Get anticipated bill total for quote
4521: -- Business Rules : Dependent on new table okl_txd_qte_antcpt_bill
4522: -- Parameters : p_qte_id -- Quote Id
4523: -- History : RMUNJULU EDAT CREATED
4524: -- Version : 1.0
4525: --

Line 4532: FROM okl_txd_qte_antcpt_bill tqa

4528:
4529: -- get sum of anticipated billing for quote
4530: CURSOR get_ant_bill_csr(p_qte_id IN NUMBER) IS
4531: SELECT nvl(sum(tqa.amount),0) amount
4532: FROM okl_txd_qte_antcpt_bill tqa
4533: WHERE tqa.qte_id = p_qte_id;
4534:
4535: l_ant_bill number;
4536: