APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_CONTRACTS

Line 4652: FROM OKL_TRX_CONTRACTS trx,

4648: -- cursor to get unaccrued subsidy for a contract
4649: --sechawla 19-sep-09 8830506 : added new parameter cp_rep_type
4650: CURSOR total_accrued_csr(p_ctr_id NUMBER, p_date DATE, p_sty_id NUMBER, cp_rep_type IN VARCHAR2) IS
4651: SELECT SUM(trx.amount)
4652: FROM OKL_TRX_CONTRACTS trx,
4653: OKL_TRX_TYPES_V try,
4654: OKL_TXL_CNTRCT_LNS txl
4655: WHERE trx.khr_id = p_ctr_id
4656: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 15137: FROM okl_trx_contracts

15133: RETURN VARCHAR2 IS
15134:
15135: CURSOR c_k_booking_date IS
15136: SELECT date_transaction_occurred
15137: FROM okl_trx_contracts
15138: WHERE khr_id = p_contract_id
15139: AND representation_type = 'PRIMARY'; -- MGAAP OTHER 7263041
15140:
15141: ld_k_booking_date DATE;