DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_CURE_AMOUNTS

Line 8377: FROM okl_cure_amounts

8373: ) RETURN NUMBER IS
8374:
8375: CURSOR c_vendor_invoice_amt (p_contract_id IN NUMBER) IS
8376: SELECT NVL(SUM(negotiated_amount),0)
8377: FROM okl_cure_amounts
8378: WHERE chr_id =p_contract_id
8379: AND status ='CURESINPROGRESS';
8380:
8381: l_vendor_invoice_amt NUMBER;

Line 8400: FROM okl_cure_amounts

8396: ) RETURN NUMBER IS
8397:
8398: CURSOR c_get_short_fund_amt (p_contract_id IN NUMBER) IS
8399: SELECT NVL(SUM(short_fund_amount),0)
8400: FROM okl_cure_amounts
8401: WHERE chr_id =p_contract_id
8402: AND status ='CURESINPROGRESS';
8403:
8404: l_short_fund_amt NUMBER;