DBA Data[Home] [Help]

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_SERVICE_FEES_B

Line 132: okl_service_fees_b svf

128: fnd.meaning svf_name,
129: svf.amount svf_amount,
130: fnd.description svf_desc
131: FROM fnd_lookups fnd,
132: okl_service_fees_b svf
133: WHERE svf.srv_code = p_svf_code
134: AND NVL(svf.organization_id, -99) = NVL(mo_global.get_current_org_id(), -99)
135: AND svf.srv_code = fnd.lookup_code
136: AND lookup_type = 'OKL_SERVICE_FEES';

Line 643: FROM okl_service_fees_b

639: FUNCTION get_svf_id (p_svf_code IN VARCHAR2) RETURN NUMBER IS
640:
641: CURSOR c_svf IS
642: SELECT id
643: FROM okl_service_fees_b
644: WHERE srv_code = p_svf_code
645: AND start_date <= TRUNC(SYSDATE)
646: AND NVL(end_date, SYSDATE) >= TRUNC(SYSDATE);
647: