DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_CONTRACTS

Line 4087: FROM OKL_TRX_CONTRACTS trx,

4083:
4084: -- cursor to get unaccrued subsidy for a contract
4085: CURSOR total_accrued_csr(p_ctr_id NUMBER, p_date DATE, p_sty_id NUMBER) IS
4086: SELECT SUM(trx.amount)
4087: FROM OKL_TRX_CONTRACTS trx,
4088: OKL_TRX_TYPES_V try,
4089: OKL_TXL_CNTRCT_LNS txl
4090: WHERE trx.khr_id = p_ctr_id
4091: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 13905: FROM okl_trx_contracts

13901: RETURN VARCHAR2 IS
13902:
13903: CURSOR c_k_booking_date IS
13904: SELECT date_transaction_occurred
13905: FROM okl_trx_contracts
13906: WHERE khr_id = p_contract_id
13907: AND representation_type = 'PRIMARY'; -- MGAAP OTHER 7263041
13908:
13909: ld_k_booking_date DATE;