1561: --| Function Name : get_quota_assign_id
1562: --| ---------------------------------------------------------------------=
1563: FUNCTION get_quota_assign_id( p_quota_id NUMBER,
1564: p_comp_plan_id NUMBER )
1565: RETURN cn_quota_assigns.quota_assign_id%TYPE IS
1566:
1567: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
1568:
1569: BEGIN
1563: FUNCTION get_quota_assign_id( p_quota_id NUMBER,
1564: p_comp_plan_id NUMBER )
1565: RETURN cn_quota_assigns.quota_assign_id%TYPE IS
1566:
1567: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
1568:
1569: BEGIN
1570: SELECT quota_assign_id INTO l_quota_assign_id
1571: FROM cn_quota_assigns_all
1567: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
1568:
1569: BEGIN
1570: SELECT quota_assign_id INTO l_quota_assign_id
1571: FROM cn_quota_assigns_all
1572: WHERE quota_id = p_quota_id
1573: AND comp_plan_id = p_comp_plan_id;
1574:
1575: RETURN l_quota_assign_id;