1583: --| Function Name : get_quota_assign_id
1584: --| ---------------------------------------------------------------------=
1585: FUNCTION get_quota_assign_id( p_quota_id NUMBER,
1586: p_comp_plan_id NUMBER )
1587: RETURN cn_quota_assigns.quota_assign_id%TYPE IS
1588:
1589: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
1590:
1591: BEGIN
1585: FUNCTION get_quota_assign_id( p_quota_id NUMBER,
1586: p_comp_plan_id NUMBER )
1587: RETURN cn_quota_assigns.quota_assign_id%TYPE IS
1588:
1589: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
1590:
1591: BEGIN
1592: SELECT quota_assign_id INTO l_quota_assign_id
1593: FROM cn_quota_assigns_all
1589: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
1590:
1591: BEGIN
1592: SELECT quota_assign_id INTO l_quota_assign_id
1593: FROM cn_quota_assigns_all
1594: WHERE quota_id = p_quota_id
1595: AND comp_plan_id = p_comp_plan_id;
1596:
1597: RETURN l_quota_assign_id;