45: FUNCTION get_recurring_period_id ( p_name IN VARCHAR2 ) RETURN NUMBER IS
46:
47: CURSOR csr_get_recurring_period_id IS
48: SELECT recurring_period_id
49: FROM hxc_recurring_periods
50: WHERE name = p_name;
51:
52: l_recurring_period_id hxc_recurring_periods.recurring_period_id%TYPE;
53:
48: SELECT recurring_period_id
49: FROM hxc_recurring_periods
50: WHERE name = p_name;
51:
52: l_recurring_period_id hxc_recurring_periods.recurring_period_id%TYPE;
53:
54: BEGIN
55:
56: OPEN csr_get_recurring_period_id;