DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PUB dependencies on CN_QUOTAS_V

Line 57: FROM cn_quotas_v

53: function validate_pe_name(p_pe_name varchar2,p_org_id number) RETURN number IS
54: l_pe_id number := 0;
55: CURSOR l_pe_id_csr(p_element_name varchar2) IS
56: SELECT quota_id
57: FROM cn_quotas_v
58: WHERE name = p_element_name and org_id = p_org_id;
59: BEGIN
60: OPEN l_pe_id_csr(p_pe_name);
61: FETCH l_pe_id_csr INTO l_pe_id;