DBA Data[Home] [Help]

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_SERVICE_FEES_B

Line 122: okl_service_fees_b svf

118: fnd.meaning svf_name,
119: svf.amount svf_amount,
120: fnd.description svf_desc
121: FROM fnd_lookups fnd,
122: okl_service_fees_b svf
123: WHERE svf.srv_code = p_svf_code
124: AND NVL(svf.organization_id, -99) = NVL(mo_global.get_current_org_id(), -99)
125: AND svf.srv_code = fnd.lookup_code
126: AND lookup_type = 'OKL_SERVICE_FEES';

Line 633: FROM okl_service_fees_b

629: FUNCTION get_svf_id (p_svf_code IN VARCHAR2) RETURN NUMBER IS
630:
631: CURSOR c_svf IS
632: SELECT id
633: FROM okl_service_fees_b
634: WHERE srv_code = p_svf_code
635: AND start_date <= TRUNC(SYSDATE)
636: AND NVL(end_date, SYSDATE) >= TRUNC(SYSDATE);
637: