APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_LOOKUPS

Line 219: --| cn_lookups instead of cn_quota_lookups_v.

215: --+==========================================================================
216: --| Function : get quota ID
217: --| Desc :
218: --| Modified by Julia Huang on 5/12/04 for bug 3626385. Use cn_quotas and
219: --| cn_lookups instead of cn_quota_lookups_v.
220: --+==========================================================================
221: FUNCTION get_Quota_id( p_quota_name VARCHAR2)
222: RETURN cn_quotas.quota_id%TYPE IS
223:

Line 238: FROM cn_lookups

234: CURSOR get_qid_lkup IS
235: SELECT v.quota_id
236: FROM
237: (SELECT TO_NUMBER(lookup_code) quota_id, meaning name
238: FROM cn_lookups
239: WHERE lookup_type = 'ELEMENT_TYPE'
240: ) v
241: WHERE v.name = p_quota_name;
242: