DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_CURE_AMOUNTS

Line 9051: FROM okl_cure_amounts

9047: ) RETURN NUMBER IS
9048:
9049: CURSOR c_vendor_invoice_amt (p_contract_id IN NUMBER) IS
9050: SELECT NVL(SUM(negotiated_amount),0)
9051: FROM okl_cure_amounts
9052: WHERE chr_id =p_contract_id
9053: AND status ='CURESINPROGRESS';
9054:
9055: l_vendor_invoice_amt NUMBER;

Line 9074: FROM okl_cure_amounts

9070: ) RETURN NUMBER IS
9071:
9072: CURSOR c_get_short_fund_amt (p_contract_id IN NUMBER) IS
9073: SELECT NVL(SUM(short_fund_amount),0)
9074: FROM okl_cure_amounts
9075: WHERE chr_id =p_contract_id
9076: AND status ='CURESINPROGRESS';
9077:
9078: l_short_fund_amt NUMBER;